Alejandro Michelin Salomon wrote:
> 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", "")
> )
You succeeded with this PRIMARY KEY-clause ???
with an empty second column-name ??
I do not believe this. What did you do instead?
>
> 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 ).
What do you mean with ' query returns no value for IdUser field'?
Is an error given ? Which one?
Is the NULL-value returned or 0 or what happened?
What did you insert into IdUser, NULL, 0, or didn't you
specifiy IdUser in the insert statament ?
Elke
SAP Labs Berlin
>
> 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
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
