7 Replies Latest reply on Jul 3, 2016 4:18 AM by beverly

    How can I alter a table (adding a column) with a calculated value as entry option with sql?


      I would like to alter a table by adding a column with a calculated value option via SQL. In https://fmhelp.filemaker.com/docs/14/en/fm14_sql_reference.pdf I found only a solution to set the creation option (by setting DEFAULT = CURTIMESTAMP). Is there an option to set the lookup values and the calculated value as well?


      Thanks for your help!