Getting the value from nextval()
Das Goravani
das at Goravani.com
Sun Jan 28 14:48:35 EST 2018
I am having a problem. It stops on $prepare() with unrecognized attribute. I’ve tried everything.
At this point I’m pretty sure I have a sequence generator as I got flags true on creating it, and then dropping it, and creating it again.
All flags true on those things.
Then I’ve made what I think is a correct INSERT INTO statement pasted here
Sta: {INSERT INTO customers VALUES (DEFAULT,@[$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”}
Omnis’s own checking is stopping it. It’s not a false flag I’m getting, the Omnis execution stops on $prepare, beeps, and gives error unrecognized custom attribute
Since I’ve tried everything I know, I’m throwing this back up for help.
Oh yes, I have gotten flags true on setting the DEFAULT for that column
I’ve tried using DEFAULT in the values as shown above, and I’ve tried nextval (seq_cust_id)
Anyone see why Omnis is barking at this INSERT INTO command ?????
More information about the omnisdev-en
mailing list