SQL Problem in Delphi

[PaidtheUmpire]

I have suddenly got a problem in a SQL query using an ADO connection from Delphi7 to Access...

here is the code...

//CODE START
With SimCardCRNQuery do begin
Close;
SQL.clear;
SQL.Add('SELECT Client_Reference_Number, SimCardPlan ');
SQL.Add('FROM SimCard_Details ');
SQL.Add('WHERE IMSI_Number = VALUE AND Current_Owner = Yes;');
SimCardCRNQuery.Parameters.ParamByName('VALUE').Value := IMSI;
Open;
try
First;
CRN := Fields[0].asString;
SCP := Fields[1].asString;
showmessage(SCP);
finally
Close;
end;
end;
//CODE END

All fields are there... so any ideas????

 

[whosrdaddy]

small change in bold

SQL.clear;
SQL.Add('SELECT Client_Reference_Number, SimCardPlan ');
SQL.Add('FROM SimCard_Details ');
SQL.Add('WHERE IMSI_Number = :VALUE AND Current_Owner = Yes;');
SimCardCRNQuery.Parameters.ParamByName('VALUE').Value := IMSI;

cheers,

http://www.damovo.com