da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: OCIQuery is busy?

Forum List » NCOCI8 » General English

rt
User

Senior Boarder

Posts: 24

Karma: 0

OCIQuery is busy?

Posted: 2004/11/08 04:48

Can I determine somehow when tociquery is busy (runing of fetching record)? when I connect to a server on a slower network and I connect in nonblocking mode and I browsing a table I always get ncoci error?
Anyone know a solution to this problem?
Thanks in advance RT

Diman

Admin

Posts: 1470

Karma: 18

RE: OCIQuery is busy?

Posted: 2004/11/08 10:49

Hello !

1) What error do you get ?
2) What is a Oracle version ?
3) You can try to use thread, where TOCIQuery will be executing and fetching records. This thread will communicate with main thread and notify it about "executing", "fetching", etc

Regards,
Dmitry

rt
User

Senior Boarder

Posts: 24

Karma: 0

RE: OCIQuery is busy?

Posted: 2004/11/08 11:49

HI!

For example if I hold the PGDown key down on a DBGrid I get OCI-03106 error. I use Oracle 8.1.6 both server and client. From where can the new thread know that TOciQuery is fetching? Which property or function tell it?

Thanks in advance rt

Diman

Admin

Posts: 1470

Karma: 18

RE: OCIQuery is busy?

Posted: 2004/11/08 15:21

Hi !

> For example if I hold the PGDown key down on a DBGrid I get OCI-03106 error.

It is a kind of AV at server side. Nonblocking = True and 8.1.6 may give that ...

My approach will not work, if you need that for DB aware controls. Also, TOciQuery does not have events like a BeforeFetch, AfterFetch. But you have sources

Regards,
Dmitry

Forum List » NCOCI8 » General English