Page 1 of 1

Open / execute

Posted: Fri 21 Aug 2009 14:31
by Olivier Olmer
We created a tool which helpes us to create stored procedures and query the database. It basically does the same as microsoft starshipenterprise manager. We use Execute and OpenNext to go throug the resultsets. We like to navigate back through the resultsets. Is this possible to implement or do we need to copy each resultset into a memory table and use this?

with kind regards,

Olivier Olmer

Posted: Fri 21 Aug 2009 14:57
by Ludek
i'm nobody from devart, but: did you read the help to the execute method?
Call the Execute method to execute a SQL statement on the server. If SQL statement is a query, Execute calls the Open method.
exactly the functionaly you wish to have :)

Thanks for you help

Posted: Mon 24 Aug 2009 14:45
by Olivier Olmer
Thanks for you help