Using RWDBConnection in nested RWDBReaders

Article ID: 1085
Last updated: 05 Feb, 2008
Article ID: 1085
Last updated: 05 Feb, 2008
Revision: 1
Views: 2869
Posted: 19 Aug, 1997
by Dean J.
Updated: 05 Feb, 2008
by Dean J.
Problem


When I use the same RWDBConnection for nested RWDBReaders, will the two RWDBReaders produce the correct results?


Cause


Many databases do not allow multiple result sets to be active on one connection. Creating multiple RWDBReaders on one connection can cause the result sets to be mixed or otherwise become invalid.


Action


If you need to write database-independent code, don't simultaneously use more than one RWDBReader on a connection, or an RWDBReader and some other operation (like an RWDBInserter, etc.) on the same connection.

 

This article was:   Helpful | Not helpful
Report an issue
Article ID: 1085
Last updated: 05 Feb, 2008
Revision: 1
Views: 2869
Posted: 19 Aug, 1997 by Dean J.
Updated: 05 Feb, 2008 by Dean J.

Others in this category