RecordCount = -1 (???)

Something "strange" in D5 and Oracle7.3.4. The application runs a SELECT statement in a table which contains VARCHAR2(2000) fields. Well... sometimes (only SOMETIMES) I get a RecordCount with value = -1 (negative 1). Any idea?
binhoAsked:
Who is Participating?
 
EpsylonConnect With a Mentor Commented:
Here is a link that relates to this:

http://www.borland.com/devsupport/sqllinks/pub-52.html


Another thing you could try is to call 'FetchAll' before you read 'RecordCount'. However this could be slow...

Regards,

Epsylon.
0
 
binhoAuthor Commented:
Motaz: sure it is opened. That's when it returns -1.
0
 
MotazCommented:
Make sure that the DataSet is opened
0
 
binhoAuthor Commented:
I just found out that it returns -1 only when the number of rows returned is greater than 10. If the # is eleven, then I get -1.
0
 
binhoAuthor Commented:
Calling FetchAll before reading RecordCount solve the problem :))
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.