I am working width Sapdb 7_3_0_29 for win32, my operating system is Windows
2000 Pro width Sp3.
I create a table usuarios :
CREATE TABLE "RELUXCAR"."USUARIOS"
(
"IDUSER" Fixed (10,0) DEFAULT SERIAL (1),
"USUARIO" Varchar (30) ASCII,
"PASSW" Varchar (20) ASCII,
"NOME" Varchar (50) ASCII,
"NIVEL" Fixed (4,0),
"COLOR" Varchar (25) ASCII,
"IMAGEM" Varchar (255) ASCII,
"INICIALES" Varchar (4) ASCII,
"EMAIL" Varchar (50) ASCII,
"ANIVERSARIO" Date,
PRIMARY KEY ("IDUSER", "")
)
I insert a record in the table without problems.
I try to execute this query :
Select IdUser, Usuario, Passw, Nome, Nivel From usuarios
where Usuario = 'amichelin'
and PassW = 'peter'
Buts, query returns no value for IdUser field ( Serial column ).
How i get this value ?
Can you help me please.
Thanks
Alejandro Michelin Salomon
PROBrax e-Tech
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
