Paradox Community

Items in pnews.paradox-programming

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.

Larry DiGiovanni

Copyright © 2004