Hello

In DBISAM, I used code similar to this to clear a parameter...

      if NOT mData.FieldByName('BankBranch').IsNull then
       AQuery.ParamByName('BranchP').AsString := mData.FieldByName('BankBranch').AsString
      else
       begin
        AQuery.ParamByName('BranchP').DataType := ftString;
        AQuery.ParamByName('BranchP').Clear;
       end;

That code still works in EDB, but is it _necessary_ to include the DataType in EDB? I have used AQuery.ParamByName('BranchP').Clear (without
the begin\end and DataType line), and it works Ok, but I am unsure as to whether or not it is a good idea.

Regards & TIA

Peter

Peter

AFAIK .Clear works on any datatype. If you trace it back you get

procedure TField.Clear;
begin
 if FieldKind in [fkData, fkInternalCalc] then
   SetData(nil);
end;


Roy Lambert [Team Elevate]

Peter,

<< That code still works in EDB, but is it _necessary_ to include the
DataType in EDB? >>

Not after a Prepare, no.  EDB automatically discovers and sets the parameter
data types, whereas DBISAM did not.

--
Tim Young
Elevate Software
www.elevatesoft.com