Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread USE DATABASE or OPEN DATABASE SQL syntax?
Tue, Nov 21 2006 12:02 PMPermanent Link

David Keith
Is there a command similiar to the SQL Server 'USE <DATABASE>' command? I would like to
use this type of command in a script so that I can switch contexts while in through the
script.

Thanks.

David Keith
Tue, Nov 21 2006 1:28 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

David,

<< Is there a command similiar to the SQL Server 'USE <DATABASE>' command? I
would like to use this type of command in a script so that I can switch
contexts while in through the script. >>

DBISAM requires that SQL scripts use the same default database for the
entire script.  You can use different database names in the actual SQL
statements (SELECT, INSERT, UPDATE, DELETE), however:

http://www.elevatesoft.com/dbisam4d5_naming_conventions.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

Image