Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
Executing Consecutive SQL Statements |
Thu, Apr 4 2013 7:20 PM | Permanent Link |
James Summerlin | In SQL Server you can do this:
Update myTable set Myfield = myValue where blah blah GO Update anotherTable set AnotherField = AnotherValue where HAR HAR GO Can something similar be done with DBISAM? JamesNT |
Thu, Apr 4 2013 7:43 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | James,
<< In SQL Server you can do this: Update myTable set Myfield = myValue where blah blah GO Update anotherTable set AnotherField = AnotherValue where HAR HAR GO Can something similar be done with DBISAM? >> Sure, just delimit each SQL statement with a semicolon ( and then you can just execute them all at once in a single TDBISAMQuery (or a single query in the ODBC driver or the Database System Utility): Update myTable set Myfield = myValue where blah blah; Update anotherTable set AnotherField = AnotherValue where HAR HAR; If you have any other questions, please let me know. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |