Please free me from this - I'll PAY

[Das Goravani]

SUCCESS AT LAST


Begin statement
Sta: {INSERT INTO customers ("cust_id","cust_firstname","cust_lastname","cust_email","cust_phone","cust_address1","cust_address2","cust_city","cust_state","cust_zip","cust_balowed","cust_bizname") VALUES (nextval('seq_cust_id'),@[$cinst.cust_firstname],@[$cinst.cust_lastname],@[$cinst.cust_email],@[$cinst.cust_phone],@[$cinst.cust_address1],@[$cinst.cust_address2],@[$cinst.cust_city],@[$cinst.cust_state],@[$cinst.cust_zip],@[$cinst.cust_balowed],@[$cinst.cust_bizname])  RETURNING ('cust_id')}
End statement
Do tstaobj.$prepare() Returns lReturnFlag
Do tstaobj.$execute() Returns lReturnFlag


I SIMPLY HAD TO TURN THE CALLING ITEM FROM MY LIST TO THE STATEMENT OBJECT

NOW THE ABOVE CODE GIVES THE SEQUENCE NUMBER IN THE NEW RECORD

NOTE I’M USING NEXTVAL, a Postgres thing, and NOT DEFAULT, so I guess I can turn off my Default for that column

PHEWY,  I finally am able to INSERT A RECORD WITH A SEQUENCE NUMBER