Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Thu, Jun 22 2006 11:07 AM	Permanent Link
Sue M	Is it possible to have a restricted transaction using tables from more than one database? When I try adding a table from a different database to my tableslist, the StartTransaction says 'Table or backup file _____ does not exist'. It drops the name of the table's database. Come to think of it, is it possible to have a regular transaction using tables from more than one database? I've had them for some time, and the query works, but for all I know may not be including the foreign table in the transaction. I'm using v4.24 build 1 and D5. Thanks.
Thu, Jun 22 2006 11:23 AM	Permanent Link
Sue M	two transactions at once?
Thu, Jun 22 2006 2:42 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Sue, << Is it possible to have a restricted transaction using tables from more than one database? >> No. << Come to think of it, is it possible to have a regular transaction using tables from more than one database? >> No. << I've had them for some time, and the query works, but for all I know may not be including the foreign table in the transaction. >> It isn't, unfortunately. Per your other post, yes, you can use two separate transactions to get a similar effect. -- Tim Young Elevate Software www.elevatesoft.com