Hello! Sorry for the late response. If you are trying to use SQL in the Database Desktop to do something, you can't do what you want to do...:-(
Database desktop is not Paradox. It has limited functionality and the interactive SQL is limited to creating Queries. My recommendation would be to create a stub program that will run your SQL file. Using this method, you should be able to do what you want to do. Hope this helps! Tom Nesler -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Damon Theis Sent: Wednesday, December 30, 2009 7:00 PM To: delphi...@yahoogroups. Com Subject: [delphi-en] Old BDE sql help Not sure why this is giving me fits, but I just want to insert some data from one table to another based on where clause. insert into labels(cost) select worktable(cost) from worktable where labels.upc = worktable.upc I get capability not supported in the database desktop app. -thanks. [Non-text portions of this message have been removed] ------------------------------------ ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [email protected]! Groups Links
