Maybe OT: OrdCreate with Unique Clausule

[hidroxid]

Hi all

Any one has used OrdCreate( ... ) with the UNIQUE clausule and work as expected ?

Help say: OrdCreate(<cOrderBagName>,[<cOrderName>],<cExpKey>, <bExpKey>, [<lUnique>])

But when use with lUnique .T. nothing happens

Sorry if is Off Topic

Regards

[nageswaragunupudi]

I used unique indexes and they work the way they are expected to work.
I use command syntax

INDEX ON <expr> TAG <tagname> UNIQUE

[ukoenig]

hidroxid,

I'm using it in some complicated situations

a sample

The index :

cUnique := cRMonat + "P" // cRmonat can be January - Dezember 12 different DBF

ORDCREATE( ,cUnique, "UPPER(PAT_NNAME + PAT_VNAME)", ;
{|| UPPER(PAT_NNAME + PAT_VNAME) } , .T. ) // .T. = UNIQUE

ORDCREATE( ,cRMonat, "UPPER(PAT_NNAME + PAT_VNAME)", ;
{|| UPPER(PAT_NNAME + PAT_VNAME) } , .F. )

It is the same DBF but opend twice. Once with a UNIQUE on NAMES
and the 2. with a normal index on NAMES

The result :

The left browser-sample -> NO unique
The right browser-sample -> UNIQUE

The upper browser UNIQUE is needed
The lower browser is related to brower 1



I hoüpe it helps

regards
Uwe

[hidroxid]

I have to check my source carefully because in an example that would send to your..... it worked , then the problem is not the function the problem is me lol

Thanks so much!