Batch Execute SQL Script with Progress

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Mimar

Batch Execute SQL Script with Progress

Post by Mimar » Mon 07 Feb 2005 18:53

Hello,

I want to batch execute a SQL script prepared by a user on the target system. During execution I want to display progress (execution percentage of script) and also allow a choice of aborting/continuing execution.

How can I do this with SDAC?
Sinan
Top
Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 08 Feb 2005 16:16

For MS SQL it is a quite difficult task as scripts are passed to the server by single block. Try to use MSConnection.OnInfoMessage, but it may solve the problem only for some particular cases.
Top
Post Reply

Return to “SQL Server Data Access Components”