quick question about recordsets, ADO

[Ravi Bhavnani]

GetRows() perhaps? (I don't know ADO). /ravi Let's put "civil" back in "civilization" http://www.ravib.com ravib@ravib.com

[Ravi Bhavnani]

Or maybe you could check its EOF property? (Sorry, just guessing.) /ravi Let's put "civil" back in "civilization" http://www.ravib.com ravib@ravib.com

[Blade DMS]

When the Recordset is empty, both the BOF and EOF flags are set, so...

if (rs.IsBOF() && rs.IsEOF())
{
do this
return
}

should be what you want.... Blade[DMS]

[ns]

This didnt pass the compiler: IsEOF is a dao thing, EOF is not an ADO thing either. getting close though....:)

	/\*	if((m\_photoDb.m\_pRecordsetPhoto.BOF = TRUE) &&                       
                      ( m\_photoDb.m\_pRecordsetPhoto.EOF = TRUE))
		{
			AfxMessageBox ("empty rs");
			return;
		}\*/

Thanks for the responses, ns OOPS! I think I need ->EOF not .EOF....I'm trying it now. DArn! That wasnt it.

[Ravi Bhavnani]

== not = :omg: /ravi Let's put "civil" back in "civilization" http://www.ravib.com ravib@ravib.com

[ns]

guess what - I tried that too....I really did.

Compiling...
Train1View.cpp
C:\Train1View.cpp(2473) : error C2059: syntax error : '('
C:\Train1View.cpp(2474) : error C2143: syntax error : missing ';' before '{'
C:\Train1View.cpp(2475) : error C2039: 'AfxMessageBox' : is not a member of '_Recordset'
c:\trainer\a_tr series\tr8b\release\msado15.tlh(1696) : see declaration of '_Recordset'
C:\Train1View.cpp(2488) : error C2039: 'm_photoDb' : is not a member of '_Recordset'
c:\trainer\a_tr series\tr8b\release\msado15.tlh(1696) : see declaration of '_Recordset'
C:\Train1View.cpp(2488) : error C2039: 'GetPhotoBuffer' : is not a member of '_Recordset'
c:\trainer\a_tr series\tr8b\release\msado15.tlh(1696) : see declaration of '_Recordset'
Error executing cl.exe.

[Blade DMS]

I think it depends how you import the ADO code, but in my version "EOF" is renamed to "adoEOF" because of the conflict with the C EOF define for end of file returned by fgetc etc... try...

if ((m_photoDb.m_pRecordsetPhoto->BOF == TRUE)
&& (m_photoDb.m_pRecordsetPhoto->adoEOF == TRUE))
{
AfxMessageBox ("empty rs");
return;
}

Blade[DMS]

[Ravi Bhavnani]

Mail me Train1View.cpp. Looks like you got a misplaced ->. /ravi Let's put "civil" back in "civilization" http://www.ravib.com ravib@ravib.com

[ns]

I checked for the recordcount and used that instead. SO the original mystery is unsolved, but I have a workaround.. :)

[Rashid Thadha]

I would be careful on how you use the recordcount method. I think this is just a water mark of the number of records you have iterated through. The count that it returns is only correct if you have iterated through the whole recordset. You have to use EOF and BOF to work out if you have any records. When you Import the ADO object you usually rename EOF to what ever you want

[Ranjan Banerji]

If you are using namespaces then you may need to say something like ADODB::EOF or ADODB::adEOF etc. Check the .tlh file and see what the constant is.

[Mazdak]

There is other way for it too.First Execute this query: select count(*) from yourtable It always return 1 record and its number of rows in table(at least it return 0 in that record),so you can find out how many records are in the table. Mazy **"If I go crazy then will you still Call me Superman If I’m alive and well, will you be There holding my hand I’ll keep you by my side with My superhuman might Kryptonite"**Kryptonite-3 Doors Down

[Jon Hulatt]

that is hideously inefficent. i'd just get the EOF thing working. STL is a religeon. Enquiries to Reverend Christian Graus