Adding columns to a table?

[soks2626]

Hi again! I was wondering if anyone could help me out here. I want to write a script to a new column to an existing table. I mean I know I could go through queries, tccursors, creating new tables and etc. to do it... but i was wondering if there's an easier way?

And I can't just edit the table because there are other people with the same table but different information... any ideas? Thanks!

-Alex

 

[footpad]

Alex,

In my experience, the most reliable method for ddoing this is to use an ALTER TABLE SQL statemement. Paradox's implementation of the BDE REstructure API isn't as robust as it could be.

For help with the SQL, see the LOCALSQL.HLP file.

Hope this helps...

-- Lance