BorlandTalk.com

tuxim · Guest

I have posted this message before in several delphi news boards but never
got any answer (help) to resolve the problem. I can't continue my work
without resolving this problem, with is quit frustrating for me. Please,
can sombody help me ?

I'm working with Delphi 6 (SP2).

I can't access to any numerical fields in my Access 2000 database via ADO.

The following query (text value) works fine :

ADOQuery1.Sql.Add('select * from DOSSIER');
ADOQuery1.Sql.Add('where DOS_EMPR_PRENOM = "' +'Maria' +'"');
try
ADOQuery1.Open;

but the next query (numerical value) generates an error message during the
excecution:

ADOQuery1.Sql.Add('select * from DOSSIER');
ADOQuery1.Sql.Add('where DOS_ID = "' +'10' +'"');
try
ADOQuery1.Open; //Generates error message

ERROR MESSAGE:
Project Datamanager.exe raised exception class EOleException with message
'Incompatible data type in the criteria expression'. Process stopped. Use
Step or Run to continue.

Whats wrong in the second query?

Complementary informations :
DOS_EMPR_PRENOM is Text type (visual Basic .mdb file)
DOS_ID is long integer type (visual Basic .mdb file)

Thanks for helping.