Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Executing Consecutive SQL Statements
Thu, Apr 4 2013 7:20 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 (Wink 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

Image