can't fread from ADO Table

[MLNorton]

I have an Access Database In an ADOTable. I can read all field from the table except one, This one is a Currency field, I try to read it with a Currency variable, Dues. The following is my code. I can read all but Dues.

With Form_Main.ADOTable1 do
begin
AssyID := FieldByName('AssyID').AsInteger;
Status := FieldbyName('Status').AsString;
Term := FieldbyName('Term').AsString;
Dues := FieldByName('Dues').AsCurrency;
ExpDate := FieldbyName('ExpDate').AsString;
Charity := FieldByName('Charity').AsString;
CardSent := FieldByName('CardSent').AsBoolean;
end;

I get the following error message:

[DCC Error] Member.pas(98): E2029 '.' expected but ':=' found

What is my problem and what is the solution?

 

[whosrdaddy]

Hi MLNorton,

try to use a Double variable for that field.
Which database backend are you using?

/Daddy

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

 

[MLNorton]

Double did not work. I am using an Access Database. I have been using Access for several years with many programs and I have never had this problem before.

 

[DjangMan]

Check the EnabledBCD setting in your query - try toggling it.