Hi all !
I'm having a problem with manual inserts
My table is pretty simple :
CREATE TABLE "DBA"."USER"
(
"ID" Fixed (10,0) NOT NULL DEFAULT SERIAL (1),
"LOGIN" Varchar (16) ASCII NOT NULL,
"PASSWD" Varchar (16) ASCII NOT NULL,
"FIRSTNAME" Varchar (64) ASCII NOT NULL,
"MIDDLENAME" Varchar (64) ASCII,
"LASTNAME" Varchar (64) ASCII NOT NULL,
"ADDRESS" Varchar (256) ASCII,
"COUNTRY" Varchar (64) ASCII
)
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...
Another weird thing is that when i try to use the "Send to Dialog Form"
function of SQL Studio, the Dialog says the table is read only.
What's wrong ???
I guess it has to do with user rights but i can't see where to define them.
Thanx for your help !
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
