Hi Marc, Marc-Olivier Meunier [mailto:[EMAIL PROTECTED] wrote: > > I'm having a problem with manual inserts > > > and everytime i try to do this : > > INSERT INTO "DBA"."USER" > ( > "LOGIN", > "PASSWD", > "FIRSTNAME", > "LASTNAME" > ) > VALUES > ( > "Marco", > "passwd", > "Marc-Olivier", > "Meunier" > ) > > I get this error : > > ---- Error ------------------------------- > Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed > General error;-5004 POS(80) Missing constant. > INSERT INTO "DBA"."USER" ("LOGIN", "PASSWD", "FIRSTNAME", "LASTNAME") > VALUES ("Marco" , "passwd" , "Marc-Olivier" , "Meunier") > > I can't see what is wrong in my very simple query... > [snipped question to SQL Studio - no idea] > > I guess it has to do with user rights but i can't see where > to define them. > Nope, it hasn't. Simply replace the double quotes around your values with single quotes and it'll run.
Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
