Did sql query fetch some result??

[mclueless]

I am working with VB6 and Access. I am using ADODB. when i set a reordset and run a sql query then how do i check if the query has fetched some result or no??

eg. I have a query as follows:

rs.open "SELECT * FROM Invoice_Master WHERE Inv_No=" & val(txtInvNo.te xt) & "",con,3,3

and now i wish to know if the invoice no mentioned in the textbox was found in the table or no then how do i do that??

[lotus18]

I am working with VB6 and Access. I am using ADODB. when i set a reordset and run a sql query then how do i check if the query has fetched some result or no??

eg. I have a query as follows:

rs.open "SELECT * FROM Invoice_Master WHERE Inv_No=" & val(txtInvNo.te xt) & "",con,3,3

and now i wish to know if the invoice no mentioned in the textbox was found in the table or no then how do i do that??

[code=vb]rs.open "SELECT * FROM Invoice_Master WHERE Inv_No=" & val(txtInvNo.te xt),con,3,3

If Not (rs.BOF And rs.EOF) then
Msgbox "Inv_No Found"
else
Msgbox "Inv_No Not Found"
End If
[/code]

Rey Sean

[mclueless]

Thanks a tonnnnnnn...... ......

[daniel aristidou]

You could also use the count method
[CODE=vb]if rs.count = 0 then
MsgBox("No Results")
Else
MsgBox(rs.count & " Results Where Found")
End if
[/CODE]

[Killer42]

You could also use the count method ...

Wouldn't it be RecordCount? (I'm not familiar with ADODB)

[daniel aristidou]

Wouldn't it be RecordCount? (I'm not familiar with ADODB)

Probably.... i'm not very familiar with vb6 anymore (i still can use it though) ......in vb08 ...you have so many snippets

[lotus18]

Wouldn't it be RecordCount? (I'm not familiar with ADODB)

Yes, it should be RecordCount.