Hi,

I can't find out why I get this error in my application : EPQDatabase Error
pqMyServer1 : Preparation of query failed (PostgreSQL:ERROR: prepared statement "prepst0" already exists)
Severity : ERROR
SQL State : 42P05

I'm using a TPQConnection, and I can make it active. My TSQLQuery.SQL (pqQuery2) is this :
UPDATE mydbcarrview_10.carrier_magname
SET location = :location
where carrierid = :carrierid

Then I do this :

  with Datamodule1 do
   begin
//    pqQuery2.UnPrepare; <-- does not help
     pqQuery2.ParamByName('Location').AsString:=edtLocation.Text;
     pqQuery2.ParamByName('CarrierId').AsString:=edtCarrierId.Text;
     try
       pqQuery2.ExecSQL; <-- gives the error
       pgTransaction1.Commit;
     except
       on e:exception do
        begin
         showmessage(e.Message);
         pgTransaction1.Rollback;
        end;
     end;
   end;

pqQuery2.UpdateMode was UpWhereKeyOnly, and I tried UpWhereAll, with the same error as result.

Lazarus 1.08, fpc 2.6.2 on winXP-32 bit.

What am I doing wrong ?

Thanks,

Koenraad Lelong

Hi,

The problem is solved. To my shame I used the wrong transaction for the query. And I didn't see this until after a few hours of debugging.

Regards,

Koenraad Lelong