Hello!:)

I have the following code:

CRecordset rs1, rs2, rs3;

CString strSQL1 = "SELECT * FROM [Orders]";
CString strSQL2 = "SELECT *\n FROM [Orders]";
CString strSQL3 = "SELECT *\nFROM [Orders]";

rs1.Open(CRecordset::dynaset, strSQL1, CRecordset::none);
rs2.Open(CRecordset::dynaset, strSQL2, CRecordset::none);
rs3.Open(CRecordset::dynaset, strSQL3, CRecordset::none);

Then I call CanUpdate and CanAppend to find that

rs1 and rs2 are updatable and appendable but
rs3 is not updatable and not appendable!!!

The difference between the 3 sql statements are just spaces and new lines.

I know that a single space in the sql statement sometimes can be the reason for error but the three recordsets are opened successfully and I can read and iterate through them.

Anybody know why is that?:confused:

Thank you in advance.