Create Unique Index

[Ruslan Zasukhin]

On 11/21/10 7:37 PM, "Warren Kuhl" <warrenkuhl at gmail.com> wrote:

> I have a table called table1 and want to create a unique index (called index1)
> with the fields - field1 and field2.  What is the snytax?
>  
> I am trying:
>  
> CREATE [UNIQUE] INDEX index1 ON table1 (field1,field2)
>  
> I get the error:
>  
> 11:24:19 AM Kernel error: 0x71000. line 1:15: expecting "database", found
> 'UNIQUE'

Valentina not supports such syntax directly.

Btw, what field types ?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]