FiveTech Software tech support forums

I have a strange error making index with dbf and ftp on main.prg I set REQUEST DBFCDX REQUEST DBFFPT EXTERNAL ORDKEYNO,ORDKEYCOUNT,ORDCREATE,ORDKEYGOTO FUNCTION Main() PUBLIC oApp RddSetDefault( "DBFCDX" ) SetHandleCount( 100 ) SET DATE FORMAT "dd-mm-yyyy" SET DELETED ...

Indexing 7 DBF's FW_CdxCreate() // WORKS !!! I tested index by index ALL numerics ( red ) don*t work ! //ORDCREATE( ,"TOPICNO", "DESCEND( STR( TOPICNO ) )", ; // {|| DESCEND(STR( TOPICNO ) ) } , .F. ) //ORDCREATE( ,"FORUM","STR( FORUM )", ...

... aFields, bFor, bWhile, nNext, nRec, cRdd, cCp ) Executes COPY TO command 19. CreateIndex( cFile, cTag, cKey, bKey, lUnique) ( ::nArea )->( OrdCreate( cFile, cTag, cKey, bKey, lUnique ) ) 20. DbCreate( aStruct ) DbCreate( ::cFile, aStruct, ::cDriver ) 21. Deactivate() Closes Alias 22. Delete() ...

... because it is a GROUP-number. DOESN't work ! wrong results typing < 1 > shows 100 and next 150 The seek works with < SPACE + 1 + 5 > ORDCREATE( ,"LEISTG1","STR(Klasse0) + Leistung", ; // N 3.0 + C 15 {|| STR(Klasse0) + Leistung } , .F. ) http://www.pflegeplus.com/IMAGES/Seek12.jpg ...

(Google translator) Nueva versión de AdoRdd 1.070317 en https://github.com/AHFERREIRA/adordd.git Mejoras y errores corregidos: ADO_ORDCREATE después de crear el índice no lo estaba abriendo. ADO_SEEK clave con varios campos con softseek en iba a eof en lugar de última clave. ADOFILE si la conexión n...

New AdoRdd Version 1.070317 at https://github.com/AHFERREIRA/adordd.git Improvements and corrected bugs: ADO_ORDCREATE after creating index wasnt opening it. ADO_SEEK key with multiple fields with softseek on was going to eof instead of last key. ADOFILE if connection not valid returns now .F. inste...

... DATE the colums are sorted but the seek doesn't work. ( I can include this test for DOWNLOAD if needed ) The tested INDEX-builds : USE CUSTOMER ORDCREATE( ,"CUST1","UPPER(FIRST)", {|| UPPER(FIRST) } , .F. ) ORDCREATE( ,"CUST2","UPPER(LAST)", {|| UPPER(LAST) ...

In my test I used DBSELECTAREA("KKASSE") 1. Index ORDCREATE( ,"KASSE1","UPPER(KASS1)", {|| UPPER(KASS1) } , .F. ) 2. Index ORDCREATE( ,"KASSE2","KENNER", {|| KENNER } , .F. ) The browser DBSELECTAREA( "KKASSE" ...

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!

... 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 ...

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

INDEX ON <expr> TAG <tagname> UNIQUE

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

... 1 and browser 2 are using the same index My test to split the customer.dbf in 2 browser. USE customer NEW SHARED ALIAS CUSTOMER VIA 'DBFCDX' ORDCREATE( ,"CUST1", "UPPER(LAST)", ; {|| UPPER(LAST) } , .T. ) // .T. = UNIQUE IGNORED !!! ORDCREATE( ,"CUST2", "UPPER(LAST)", ...

... DBFCDX RDDSETDEFAULT ( "DBFCDX" ) NET_USE ( c_Pfad + "KUNDE.dbf", "KUNDE", 3, .T. ) DBSELECTAREA("KUNDE") ORDCREATE( ,"KUNDE1","UPPER(NAME1 + NAME)", ; {|| UPPER(NAME1 + NAME) } , .F. ) NET_USE ( c_Pfad + cMonat + ".dbf", "VPOS12", ...

... http://www.pflegeplus.com/IMAGES/Relation2.jpg USE customer1 NEW SHARED ALIAS CUST1 VIA 'DBFCDX' ORDCREATE( ,"CUST1", "UPPER(LAST)", ; {|| UPPER(LAST) } , .F. ) ORDCREATE( ,"CUST2", "UPPER(LAST)", ; {|| UPPER(LAST) ...