|Subject:||Re: New fields to existing table
|Date:||Wed, 4 Apr 2018 18:11:52 -0400
|From:||"Larry DiGiovanni" <nospam@nospam>
Roger Phil wrote:
> Question can I use SQL to check the field structure and write needed
> fields if they don't exist
You can check for the column in the enumStruct and create a SQL ALTER
statement to add the missing column(s). I don't think you can check for the
presence of a field in a table with LocalSQL.
But there are Paradox table and field settings you cannot set via SQL ALTER.