[L]Database Field change of[/L] [value mvc_data_field] [L]in[/L] [value mv_data

[if-mm !tables] [bounce href="[area config/violation]"] [/if-mm] [if-mm !edit] [bounce href="[area config/violation]"] [/if-mm] [L]Database Field change of[/L] [value mvc_data_field] [L]in[/L] [value mv_data_table]

[set name=result][/set] [set name=result_delete][/set] [if value mv_data_function eq 'delete'] [and !value mv_data_verify]

[L]Need to verify before deleting a field[/L].

[elsif value mv_data_function eq 'delete'] [set name=result_delete interpolate=1][export-database table="[value mv_data_table]" file="[value mv_data_file]" type="[value mv_data_export_type]" field="[value mvc_data_field]" delete="delete" verify="[value mv_data_verify]" ][/set] [/elsif] [elsif value mvc_export_database] [set name=result interpolate=1][export-database table="[value mv_data_table]" file="[value mv_data_file]" type="[value mv_data_export_type]" field="[value mvc_data_field]" ][/set] [value name="mv_data_function" set=""] [/elsif] [/if] [if scratch result] [L]Database[/L] [value mv_data_table] [L]field[/L] [value mvc_data_field] [L]added successully[/L]

[elsif scratch result_delete] [L]Database[/L] [value mv_data_table] [L]field[/L] [value mvc_data_field] [L]DELETED[/L]

[/elsif] [else] [L]Database export error[/L]: [data session last_error] [/else] [/if]

[value name="mv_data_function" set=""] [value name="mv_data_verify" set=""] [quick-table] [L]Table name[/L]: [value mv_data_table] [L]File name[/L]: [default mv_data_file] [L]File type[/L]: [default mv_data_export_type] [L]Field name[/L]: [value mvc_data_field] [/quick-table]

[if type=explicit compare="[calc] q{[dbinfo table='[value mv_data_table]' attribute=type]} eq '8'; [/calc]"]

You will probably have to reconfigure for the changes to show up. [/if]

[loop list="[value mv_data_table]"]

[title-bar 200 2][L]Database Configuration[/L][/title-bar]
[if-mm upload]
[L]Upload new ASCII source[/L]
[/if-mm] [if-mm journal_update]
[L]Upload partial update file[/L]
[/if-mm] [if-mm export]
[L]Export to ASCII file[/L]
[/if-mm] [if-mm advanced add_delete]
[L]Add or delete column[/L]
[/if-mm]
[L]Edit menu[/L]

[if-mm advanced search] [title-bar 200 2][L]Search by keyword for records[/L][/title-bar]
[if type=explicit compare="[calc] q{[dbinfo table='[value mv_data_table]' attribute=type]} eq '8'; [/calc]"] [elsif type=file term="products/[value mv_data_table].ks"] [/elsif] [else] [/else] [/if]
[/if-mm]
[scratch menu]
[/loop]

[title-bar 200 2][L]Database Configuration[/L][/title-bar] [if-mm upload] [L]Upload new ASCII source[/L] [/if-mm] [if-mm journal_update] [L]Upload partial update file[/L] [/if-mm] [if-mm export] [L]Export to ASCII file[/L] [/if-mm] [if-mm advanced add_delete] [L]Add or delete column[/L] [/if-mm] [L]Edit menu[/L]	[if-mm advanced search] [title-bar 200 2][L]Search by keyword for records[/L][/title-bar] [if type=explicit compare="[calc] q{[dbinfo table='[value mv_data_table]' attribute=type]} eq '8'; [/calc]"] [elsif type=file term="products/[value mv_data_table].ks"] [/elsif] [else] [/else] [/if] [/if-mm]
[scratch menu]