>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

Is there any particular reason you're not using views - either parameterized, or via CREATE SQL VIEW?