Using Maxdb I've found a strange error

I've defined a table this way:

CREATE TABLE FOO(
   ID Fixed (10,0) NOT NULL DEFAULT SERIAL (1),
   NOTES Varchar (255) ASCII NOT NULL,
   USERID Varchar (32) ASCII NOT NULL DEFAULT USER
)

I've defined 20 USERS which in order to insert records in the table above defined have to exec the folowing stored procedure:

CREATE DBPROC "GestionePratiche"."spFOO_INS" ( IN @P1 Fixed (10,0) ,
IN @P2 varchar(32)
) AS
INSERT INTO FOO ( ID,
NOTES)
VALUES ( :@P1, :@P2);
//

here comes the error:
doesn't matter which user executes the stored, but the username recorded in the table is the one of the first user who has logged in the database
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to