----- Original Message -----
From: "Robert Klemme" <[EMAIL PROTECTED]>
To: "Luca Calderano" <[EMAIL PROTECTED]>
Cc: <maxdb@lists.mysql.com>
Sent: Thursday, May 31, 2007 10:10 AM
Subject: Re: DEFAULT USER
2007/5/30, Luca Calderano <[EMAIL PROTECTED]>:
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
Well, that clearly indicates that USER is evaluated on table creation
not on record insertion. You probably want to be using a trigger
instead.
robert
sorry, but the user that alwais appears in the field named "USERID" is not
the user that created the table
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
