Solved

RecordCount = -1 (???)

Posted on 2000-04-17
5
212 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
ID: 2722420
Motaz: sure it is opened. That's when it returns -1.
0
 
LVL 13

Accepted Solution

by:
Epsylon earned 100 total points
ID: 2722494
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
ID: 2722368
Make sure that the DataSet is opened
0
 

Author Comment

by:binho
ID: 2722532
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
ID: 2722565
Calling FetchAll before reading RecordCount solve the problem :))
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Delphi with SQL Natvie Client 15 86
find a node in VST 2 64
can't find the executable in Simulator 1 80
Unique identifier on a terminal server (rdp) 4 46
A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

867 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

22 Experts available now in Live!

Get 1:1 Help Now