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