Recent

Author Topic: How make it work this Query un Postgres  (Read 2414 times)

cpalx

  • Hero Member
  • *****
  • Posts: 753
How make it work this Query un Postgres
« on: April 09, 2018, 05:52:53 am »
i tried with PQconection
SQLquery
SQLtransaction

with any combination
(open, ExecSQL, Active:= true)
 (Transaction.commit, Transaction.commitRetain) 

Any Help? (i can not change The Query)

Code: MySQL  [Select][+][-]
  1. DO $$
  2.  DECLARE mainid INTEGER;
  3.  
  4. INSERT INTO job (name ,compid )  
  5. VALUES ('Chofer ','1 ' )
  6.  RETURNING jobid INTO mainid;
  7. END$$;

kapibara

  • Hero Member
  • *****
  • Posts: 610
Re: How make it work this Query un Postgres
« Reply #1 on: April 09, 2018, 07:44:17 am »
Lazarus trunk / fpc 3.2.2 / Kubuntu 22.04 - 64 bit

goodname

  • Sr. Member
  • ****
  • Posts: 297
Re: How make it work this Query un Postgres
« Reply #2 on: April 09, 2018, 01:50:09 pm »

 

TinyPortal © 2005-2018