Open / execute

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Olivier Olmer
Posts: 8
Joined: Wed 09 Mar 2005 12:11

Open / execute

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
Last edited by Olivier Olmer on Fri 21 Aug 2009 15:07, edited 1 time in total.

Ludek
Posts: 296
Joined: Thu 12 Oct 2006 09:34

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
Posts: 8
Joined: Wed 09 Mar 2005 12:11

Thanks for you help

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

Thanks for you help

Post Reply