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

[if-mm !tables] [bounce href="[area @@MM_BASE@@/violation]"] [/if-mm] [if-mm !edit] [bounce href="[area @@MM_BASE@@/violation]"] [/if-mm]

[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]