Page 1 of 1

TOLEDBRecordSet.Fetch with SNoResultSet

Posted: Mon 28 Feb 2005 12:28
by Nikolai
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

Posted: Wed 02 Mar 2005 07:21
by Ikar
Remove from the script "go" statements and use OpenNext method.