Getting error while retrieving value from ADO recordset.

[sankar540]

I have a vc++ project file which reads data from access 2007 database.

I have successfully declared and opened connectionPtr and recordSetPtr objects.

The follwoing code is giving an error message that "item cannot be found in the collection"
stringVar = (recordSet->Fields->GetItem("[String]")->GetValue()).bstrVal;

If i replace "[String]" with "String" then above statement executed successfully.

How can i execute the above statement with "[String]" without errors?


Thanks in advance.

Regards,
Siva.