TOLEDBRecordSet.Fetch with SNoResultSet

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Nikolai
Posts: 5
Joined: Fri 04 Feb 2005 14:26
Location: Russia, Ufa
Contact:

TOLEDBRecordSet.Fetch with SNoResultSet

Post by Nikolai » Mon 28 Feb 2005 12:28

I'm use blocks of sql scripts in one TMSQuery

[sql1]
go
[sql2]
...
[sqlN]

where SQL is some SQL operator.
It can be "select" or simple "update/insert", but if
TMSQuery.Open has no resultset I'm get

if Fields.Count = 0 then
DatabaseError(SNoResultSet, nil);

Is it possible to add some option allow ignore empty Fields.Count in TMSQuery.Open calls?

Regards,
Nikolai Bochkarev

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Wed 02 Mar 2005 07:21

Remove from the script "go" statements and use OpenNext method.

Post Reply