Recordset GetFieldValue for list values

Hello All,

this is my first post here, but I tried several things before posting here...

Here is my problem :

I'm reading different tables inside an Access Database (I'm more used to SQL...), and for some specific fields, i'm getting strange readings...

here is the code :

"CString csRequete;
CDaoRecordset recordset2(&database);
COleVariant l_vProcedure;

csRequete.Format("SELECT * FROM [LB Analysis Profiles] WHERE [LB Analysis Profile Key] = %d",l_vAnalysisProfile.intVal);
recordset2.Open(AFX_DAO_USE_DEFAULT_TYPE,csRequete.GetBuffer(), 0);
recordset2.MoveFirst();

l_vProcedure = recordset2.GetFieldValue(17);
csProcedure = l_vProcedure.bstrVal;"

The problem is that I am getting Chinese symbols in the BSTR of l_vProcedure, or invalid characters...
the field is a text type containing "FILTRE", and that's what I should read...

This functions are working fine on others tables, or for some numerical value...

Do you have any idea what can be happening?

Thanks on advance

I'd like to add one thing :

the content of the requiered field is a text coming from a query, so it's a combobox selected text.

Ok, I finally found what happened...

Contrarely to what the variant said, it's not a BSTR type, the data to read is :

"csProcedure = l_vProcedure.pbVal;"

I don't know why it's so, but it can be useful to someone any day ^^

good luck.

Hmm, I use DAO and a somewhat simular technique/approach that works well. I don't have time to look it up right now, but I don't use .GetBuffer().


Why are you using .GetBuffer()? ... if I recall correctly you just enter the value CString.


.. I think you are also using Bstr value incorrectly.

Hi CNemo, thanks for your answer.

I'm using .GetBuffer() because I had several problems retrieving text from CString in the past.
This is a habit I have which prevent me from having some conversion problems.

I agree it may not be necessary here.


The use of BSTR may be wrong... but the solution here is :

"l_vProcedure = recordset2.GetFieldValue(17);
csProcedure = l_vProcedure.pbVal;"