Flag False on INSERT or $insert()

[Doug Easterbrook]

try  RETURNING  cust_id

there are no brackets.


always try the statement in pgadmin first.

Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 650-1978

> On Jul 5, 2022, at 11:52 AM, Das Goravani <goravanis at gmail.com> wrote:
> 
> 
> Working with Postgres 14
> 
> I try to use either of these lines and I get a flag false on both, why?
> 
> Do tStatObjPGRef.$execdirect(con('INSERT INTO dtcustomers ',$ctask.tSessObjPGRef.$insertnames(tCustomersRow),' RETURNING (cust_id)')) Returns #F
> 
> 
> Do tCustomersRow.$insert(' RETURNING (cust_id)') Returns #F
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com