Board index » delphi » Unusable result sets

TG

Delphi Developer
Sun, 21 Mar 2004 21:44:43 GMT

Unusable result sets

When using SQL server commands such as @@Version  or RESTORE FILELIST
ONLY.... that return a result set from Delphi 5 database components (not
ADO), the result sets (when interrogated) have a positive row count but the
fields appear to hold nothing when accessed with FieldByName.AsString etc.
If I attempt to access them via the fields[n] property I can access and
display some fields but the fieldcount is substantially less then the
results set that is produced by the same command in Query Analyser.

How can I access the values of these seemingly non-existent yet vital
fields?

Thanks
TimmyG

 
Mike Wals

Delphi Developer
Tue, 23 Mar 2004 01:02:36 GMT

Re:Unusable result sets


Hi,

I believe your problem is that the BDE doens't support the nverchar type
used for these procs. I've had similar problems with some of thre system
tables, and have had to structure queries that cast the fields as regular
varchars.

Mike Walsh

Quote
"TG" <t...@pracctice.com> wrote in message news:3bbb1586$1_1@dnews...
> When using SQL server commands such as @@Version  or RESTORE FILELIST
> ONLY.... that return a result set from Delphi 5 database components (not
> ADO), the result sets (when interrogated) have a positive row count but
the
> fields appear to hold nothing when accessed with FieldByName.AsString etc.
> If I attempt to access them via the fields[n] property I can access and
> display some fields but the fieldcount is substantially less then the
> results set that is produced by the same command in Query Analyser.

> How can I access the values of these seemingly non-existent yet vital
> fields?

> Thanks
> TimmyG

Other Threads

1. result sets from Oracle Stored Procedures

2. Query returned multiple result sets

3. Working with TQuery Result Set

4. Live result set - MS SQL 6.0

5. Why does this query return no result set???

6. BDE Paradox NET DIR Setting unusual result

7. BDE Paradox NET DIR Setting unusual result

8. print a decision cude result set

9. Delphi 1 - querying a result set

10. Retrieving a result set with a TQuery