Sorry if my posts have confused you. For some reason I thought you were trying to port data from Paradox to SQL.
Although Paradox can be accessed with some SQL statements, it is very limited and not really a SQL language.
From 'LocalSQL.hlp' file:
"Local SQL is the subset of the SQL-92 specification used to access dBASE, Paradox, and FoxPro tables. On receiving local SQL statements from front-end applications, the Borland Database Engine (BDE) translates the statements into BDE API functions." I would add "very sloooowly" compared to real SQL databases.
I've never been able to add fields programically to a Paradox table. The easiest way is to use Database Desktop to manage you Paradox tables. I have created new table progamically (cloning the old one) and added new fields (AddFieldDef) during the creation of the new one(CreateTable). Then dump the existing data from the old table to the new. There may be a way to add fields to existing Paradox tables, but I've never succeeded.
See: "AddFieldDef method (TFieldDefs)" in Delphi help. That page has an example link. But the example code includes "if not Table1.Exists then begin" which to me is a clue.
Fighting with Paradox is just not worth the effort with so many alternatives that work so much better. AND you will find much more available help.
If not yet convinced, seach this forum for Paradox.
Roo
Delphi Rules!