change a table name and redo the query?

[richmcn]

Assume you have a query file tied to a table name.

Change the table name, run the query and get "Table does not exist" message box. Justifiably so.

Is there a way to change a query built on a table after the table has been renamed without typing it in all over again?

Forms will allow for table name changes, but not queries.

I tried editing the file in Notepad but the table name must be hidden and inaccessible.

Would another lower level editor work?

I'd like to reorganize my application and have a lot of table names and query files involved.

Thanks,
Rich McN
Pardox Version 8
Naperville, IL

 

[LWB2005]

Rich,

If you don't mind running the query under ObjectPal, you can always use the "Paste From" in a method to paste the current query file into a method (PushButton or Open or where ever you need to run it). Then you can change the table name by typing in the new one. And add the couple of lines of code to run it (see the ObjectPal help for examples if you don't know how to do this).

I don't know how to easily change the table name in the saved qbe file (and what if multiple tables are in the query), but that doesn't mean it can't be done.

Lynn

 

[TonyMcGuire]

I tried editing the file in Notepad but the table name must be hidden and inaccessible."

The table name of a query is very obvious, in the right-hand column of the query, and USUALLY with a .db extension on it.



Tony McGuire

http://www.thedbaddons.com

http://www.thedbcommunity.com

 

[TonyMcGuire]

..in the right-hand.."

And, of course, the table name is in the left hand column of the query image in the .qbe file.

Tony McGuire

http://www.thedbaddons.com

http://www.thedbcommunity.com