Error in Recordset

[SunnyPriya]

Thanks every one.
I have solved the problem, It was my first program out of C++, I mean involving MFC, etc
I really appreciate evey one involved in helping me, esp Amarcode.
Thanks a lot again.
Regards
Sunnypriya

[GCDEF]

It's not true. The CRecordset class doesn't do it for you. You have to specify the select statement in the recordset open function.

Dude, I've been working with CRecordsets for 10 years. You don't need to specify a select statement. I have NEVER specified a select statement. If you need to, then you are doing something wrong.

[amarcode]

Dude, I've been working with CRecordsets for 10 years. You don't need to specify a select statement. I have NEVER specified a select statement. If you need to, then you are doing something wrong.

You can pass NULL parameter to the CRecordset Open function. In this case the default SQL statement is used, but you have to specify this statement in derived from CRecordset class function GetDefaultSQL().

[GCDEF]

Moron, you can pass NULL parameter to the CRecordset Open function. In this case the default SQL statement is used, but you have to specify this statement in derived from CRecordset class function GetDefaultSQL().

Which is it? First you say that you have to pass a select statement to the Open function then you say it can be NULL. And you call me a moron - sheesh.

If you use class wizard to create your CRecordset derived class, you don't need to write any select code yourself. GetDefaultSQL should return a table name, not a complete select statement. CRecordset builds the select statement for you using the table name that class wizard inserts in your coce. You don't even need to create a CDatabase object.

If you're going to give advice and go around calling people names, you should have some clue what you're talking about.