General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL wont overwrite table in DBC
I'm trying to run an SQL into a table with long field names, and fox balks, refusing to overwrite the table.
Is there a way to get SQL to overwrite the table?
I came up with two workarounds:
1) Run the SQL to a cursor, zap the table, and append from the cursor. This means writing the table twice.
2) Open the DBC, look for the table using ADBOBJECTS, close the table if it's open, and drop the table if it's in the DBC. This is not very clean, and DBUSED has been flaky.
Surely I'm not the first person to run an SQL into a DBC. Is there something I'm missing?
Thanks,
-hans
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only