2007/5/31, Luca Calderano <[EMAIL PROTECTED]>:
----- Original Message ----- From: "Robert Klemme" <[EMAIL PROTECTED]> To: "Luca Calderano" <[EMAIL PROTECTED]> Cc: <[email protected]> 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
That's an interesting point. But regardless of that it seems to be clear that the value is evaluated only once. Did you try to use a trigger? Kind regards robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
