da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Recordcount with TOCIQUERY

Forum List » NCOCI8 » General English

JP
User

Fresh Boarder

Posts: 1

Karma: 0

Recordcount with TOCIQUERY

Posted: 2000/05/08 10:15

I do a query on a table to consider if there are details records to a master table. The amount of records to query is set to 100 in TOCIDATABASE. The query for the first master record returns a recordcount of 100. For the second master record there are only 34 records. The query didn't return the value, but after some time i got the message "ORA-03113: end-of-file on communication channel". Someone to know this problem and can help me?

Thanks!

Diman

Admin

Posts: 1482

Karma: 19

RE: Recordcount with TOCIQUERY

Posted: 2000/05/08 17:03

First at all, "100 in TOCIDATABASE", i think, it is:
TOCIDatabase.DefaultFetchParams.RowsetSize This parameter determines how many records by default TOCIQuery will fetch from server in one fetch operation.

TOCIQuery.RecordCount by default returns total count of fetched records. So, in general, it will increment by RowsetSize for first and next fetches and will show total count after last fetch (all records are fetched).

To solve your issue, i need:
- server version;
- client version;
- NCOCI8 version;
- and will be best - demo project.

Please, send it direcly to me.

Regards,
Dmitry

Forum List » NCOCI8 » General English