On 13/04/2007 19:25, Raymond O'Donnell wrote:
PSQLQuery1.SQL.Add ('Where P_ID.Loops.Loop_Name = :Loop_Name'); PSQLQuery1.ParamByName('LoopNumberEdit').Value := Edit1.Text;
I meant to say also that the parameter name you're passing to the ParamByName() function isn't the same as the one you've specified in the query.
Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx ---------------------------------------------------------------