On Mar 2, 2012, at 6:21 PM, Adrian Klaver wrote:
> Exactly. This is not VFP so it will require a different set of glasses:) In
> Dabo
> you can work with multiple DataSets, just in a different manner. More detail
> see:
>
> http://wiki.dabodev.com/DataSet
>
> Just substitute DataSet for TempTable.
The difference, of course, is that with Dabo datasets, the processing
is done locally. He wants to have this done on the server.
To be honest, Ricardo, I've never tried sending multiple commands via
the dbapi to be processed together. According to the spec, such behavior is
undefined at the dbapi level:
.executemany(operation,seq_of_parameters)
Prepare a database operation (query or command) and then
execute it against all parameter sequences or mappings
found in the sequence seq_of_parameters.
Modules are free to implement this method using multiple
calls to the .execute() method or by using array operations
to have the database process the sequence as a whole in
one call.
Use of this method for an operation which produces one or
more result sets constitutes undefined behavior, and the
implementation is permitted (but not required) to raise
an exception when it detects that a result set has been
created by an invocation of the operation.
The same comments as for .execute() also apply accordingly
to this method.
Return values are not defined.
That doesn't mean that a particular backend adapter couldn't return
multiple cursors, but that would be up to that implementation, not up to the
dbapi.
What about creating temporary tables in the server that persist for
more than one query? From your notation, it looks like you're using MS SQL
Server. Temporary tables continue to exist for the life of the connection, so
you could simply create the tables in one call, grab the data after the first
query, and then grab the data into another cursor from the second query, etc.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
