Solved

RecordCount = -1 (???)

Posted on 2000-04-17
5
210 Views
Last Modified: 2010-04-04
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?
0
Comment
Question by:binho
  • 3
5 Comments
 

Author Comment

by:binho
Comment Utility
Motaz: sure it is opened. That's when it returns -1.
0
 
LVL 13

Accepted Solution

by:
Epsylon earned 100 total points
Comment Utility
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
 
LVL 7

Expert Comment

by:Motaz
Comment Utility
Make sure that the DataSet is opened
0
 

Author Comment

by:binho
Comment Utility
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
 

Author Comment

by:binho
Comment Utility
Calling FetchAll before reading RecordCount solve the problem :))
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now