problem with access db and delphi 7

[billpoul]

hello everyone and thanks for your help in advance.

i am using ADO connection in delphi 7 with an access db.
all of my queries are correct and also the names of my fields in access.
the problem is that some times i get the following error on select * from Table queries!

MyVal:= vartostr(fieldvalues['fieldName']);
the fieldname may dy ID autonumber or same text

ADOQuery 1! Field 'fieldname' not found

the think is that the field does exists.
when i press ok to the error message and if i try to do the same query again i may have no problem.

this queries must run automaticaly in my prog as a result i have a little problem here.

please help!

 

[Griffyn]

I've found that forgetting to Open the table prior to referencing it's fields will result in a 'Field not found' exception, rather than a 'Table not open' exception.

 

[whosrdaddy]

Hi,

no need for VarToStr! Normally you retreive your field like this:

MyFieldValue := ADOQuery1.FieldByName('MyField').AsString; (or .AsInteger, and son on...).

/Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[billpoul]

hi and thanks a lot for your replies!
i have found that there has been some kind of problem with the db relations, you see i was given the db form my partner and i had to build my apllication on it!
some times it is better to do some things by your self!
any way thanks again for your consideration!