record count mismatch

  • Thread starter Thread starter ravindar thati
  • Start date Start date
R

ravindar thati

hello friends,

i have a table named "Technology"
it has few columns.
of them two are
1.Name
2. Type



i have written a query and exectued like this
my code goes like this

dim db as database
dim rs as Recordcount
set db=CurrentDb
set rs=db.OpenRecordset("select * from Technology where
Technology.Type="Water" ")
rs.getRows
msgbox(rs.RecordCount)

if i execute this query in query wizard i get record count correctly.
but when i implement this query in my code, it displays record count
as 2 every time.

same query , but why i am facing the problem?
but if i put rs.getRows command multiple times, the record count is
increasing by one.
actually we have to get all the rows with single rs.getRows command .
but why this peculiar thing?
whats wrong in my code?
Thank you
 
Hello Ravindar.

ravindar said:
Hello friends,

I have a table named "Technology", two of the columns are
1. Name
2. Type
Click to expand...
I have written a query and exectued. My code goes like this:
------------------
Dim db as Database
Dim rs as RecordSet
Set db = CurrentDb
Set rs = db.OpenRecordset("select * from Technology where" & _ " Technology.Type='Water'")
rs.GetRows
MsgBox rs.RecordCount
Click to expand...

The recordset was not filled, because you did not yet retrieve all
records.
Try this before using the GetRows method:
if not rs.eof
rs.movelast
rs.movefirst
end if

Get rows returns an array, that you don't mention in your code...
 
The recordset was not filled, because you did not yet retrieve all
records.
Try this before using the GetRows method:
if not rs.eof
rs.movelast
rs.movefirst
end if

Get rows returns an array, that you don't mention in your code...
Click to expand...

thank you friend, it worked perfectly
 
One other thing you need to know. Name and Type are both Access reserved
words and should not be used as names of objects. Access can become confused
and return incorrect results.
 
Try this before using the GetRows method:
if not rs.eof
rs.movelast
rs.movefirst
end if

Get rows returns an array, that you don't mention in your code...
Click to expand...






Thank you friend.
it worked perfectly.
many thanks
 
yes they are reserved words,
only to get my doubt clarified, i used those columns names.

Thank you friend
 
Back
Top