Subject: | Re: New fields to existing table
| Date: | Wed, 4 Apr 2018 18:11:52 -0400
| From: | "Larry DiGiovanni" <nospam@nospam>
| Newsgroups: | pnews.paradox-programming
|
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.
--
Larry DiGiovanni
|