Making “returning” give back the SERIAL

Omnis doesn’t like this statement

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”

Can you see anything wrong with it

Note it contains a call to DEFAULT the first field, and a RETURNING clause at the end for the name of that field

I have double and rechecked that I have a serial generator running and have set the default for that column to the serial generator

The above should work but it’s not and I’m frustrated
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com