Problem Inserting Postgres
Das Goravani
goravanis at gmail.com
Sat Jul 9 17:11:17 UTC 2022
This is the SQL my line generates:
INSERT INTO dtcustomers ("cust_firstname","cust_lastname","cust_email","cust_phone","cust_address1","cust_address2","cust_city","cust_state","cust_zip","cust_balowed","cust_bizname","cust_rep_id") VALUES ($1 ,$2 ,$3 ,$4 ,$5 ,$6 ,$7 ,$8 ,$9 ,$10 ,$11 ,$12 ) RETURNING cust_id
I’m surprised by the presence of like $1 and $12 for values. I hope that is some omnis shorthand that works. I thought I was going to see bind variables in VALUES or actual values.
More information about the omnisdev-en
mailing list