Questions with ADO and Cursortypes

[Guest_imported]

Ya'll are gonna get sick of hearing me ask all these questions...but I can't really find them anywhere else...plus I'm new to VC++ and I think this message forum is GREAT!

I'm connected to a SQL database using VC++. I've got a problem that when I search for something on the database and it's not there, my program crashes. A friend of mine told me to use the RecordCount method to see if there are any records in my Recordset object...if there is not, then it's not in the database. Well, I thought that was a great idea until I tried it. I keep getting a -1 when I use RecordCount...I've tried the different cursors (mainly adOpenKeyset) but with no luck. Could it be that the provider just doesn't support it? If that's true, why can my friend use the similar RecordCount method in VB? Any and all help would be greatly appreciated. Thanks in advance!

Niky Williams
NTS Marketing

 

[palbano]

Dear Niky,

check this MDAC technical article out:

http://msdn.microsoft.com/library/psdk/dasdk/migr14h3.htm

Hope this helps
-pete

 

[Guest_imported]

Oh great! Wonderful gobs of information. Thank you so much. I've been on MSDN Online to look for things, but it's so large that I sometimes miss some important things. Thanks again!

Niky Williams
NTS Marketing