Open / execute

Olivier Olmer · Post by **Olivier Olmer** » Fri 21 Aug 2009 14:31

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

Ludek · Post by **Ludek** » Fri 21 Aug 2009 14:57

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

Olivier Olmer · Post by **Olivier Olmer** » Mon 24 Aug 2009 14:45

Thanks for you help