On 4/26/22 2:31 PM, Rich Shepard wrote:
I'm getting a syntax error with an input into statement and I cannot see
the
cause.
A MWE and the result (N.B.: line one wrapped for readability; it ends with
'values'):
insert into people (person_nbr,lname,fname,job_title,company_nbr,loc_nbr,
loc_phone_ext,direct_phone,direct_fax,cell_phone,email,active,comment)
values (6000,'No','Name',null,404,1,null,null,null,null,null,null,null);
2: ERROR: syntax error at end of input
LINE 2: (
^
What do I keep missing?
I'm guessing some sort of hidden character.
What client are you using to run this?
Where is the query string coming from?
TIA,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
