Thanks Tom, that's exactly what I did. ;)
From: [email protected] [mailto:[email protected]] On Behalf Of Nesler, Thomas J Sent: Monday, January 04, 2010 9:35 AM To: [email protected] Subject: RE: [delphi-en] Old BDE sql help 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:delphi-en%40yahoogroups.com> [mailto:[email protected] <mailto:delphi-en%40yahoogroups.com> ] 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] <mailto:delphi-en-unsubscribe%40yahoogroups.comYahoo> ! Groups Links [Non-text portions of this message have been removed]
