DEFAULT USER

"Luca Calderano" <[email protected]> Wed, 30 May 2007 17:49:11 +0200
Newsgroups gmane.comp.db.maxdb
Message-ID <[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 

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]