Alejandro Michelin Salomon ( Adinet ) wrote:
> Hi:
>
> I need create a PK for a table.
> This PK has 3 fields.
> PK is : CONSTRAINT ff_navios PRIMARY KEY ( idempresa, idarmador, UPPER(
> nome ) )
> But seems not work.
This is a useless error report ;) You need to provide the error message
you get. Usually this error message says in plain english (or even plain
spain or something ;) what the problem is anyway :-)
Ah yes, you should use (UPPER(nome)) in the place you wrote UPPER(nome)
> I have and other way to do this ?
> If this fields are not null and i create a unique index in place off pk,
> i have the same effect ?
What is the desired effect? PK is usually implemented as unique index
anyway.
...
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.7.0/346 - Release Date: 23/5/2006
>
>
> ------------------------------------------------------------------------
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.7.0/346 - Release Date: 23/5/2006
>
I'd get rid of those messages. They are useless anyway.
Regards
Tino