Code Comments
Programming Forum and web based access to our favorite programming groups.Hi, using Clipper 5.2.e since 1995. The file DODLIST.DBF is opened with INDEX DODLIST.CDX, which contains 3 orders. Somwhere in application I want to build a temporary index with FOR expression with the same 3 orders, to show only the part of records. Here is the code, DODLIST is the current workarea: cTmpNtx1 := "Temp111.CDX" DBCLEARINDEX() && close the zoznamdl.cdx -> works O.K., no opened index file INDEX ON (dodavatel+cislofakt) TAG CisloFak TO (cTmpNtx1) FOR; RIGHT(DTOC(DatumDod),7) == cObd DBCLEARINDEX() INDEX ON DTOS(datumdod) TAG Datum TO (cTmpNtx1) FOR; RIGHT(DTOC(DatumDod),7) == cObd DBCLEARINDEX() INDEX ON Doklad TAG Doklad TO (cTmpNtx1) FOR; RIGHT(DTOC(DatumDod),7) == cObd CLOSE INDEXES SET INDEX TO (cTmpNtx1) All works fine: after CLOSE INDEXES the debugger shows: the workarea is not indexed -> O.K. but after SET INDEX TO (cTmpNtx1) the debugger shows the workarea has 2 opened index files DODLIST and TMP111 and 6 active orders !!!! I have 2 questions: 1. Why is opened the DODLIST.CDX ?? It seems, like the Autoopen feature of CDX driver in Visual Objects, but I did not read about it in documentation. 2. How can I close only one order bag, in this case DODLIST? The NG says about the next order managment functions: - OrdlistClear() - closes ALL the indexes - OrdDestroy() - removes the specified order from the order bag Gejza Horvath
Post Follow-up to this messageGejza > DBCLEARINDEX() && close the zoznamdl.cdx -> works O.K., no opened index file[/co lor] To my knowledge that doesn't work for the 'DBFCDX' implemented by Successwar e which the 'DBFCDX' RDD driver in 5.2 is based on (SIX2) (not sure about COMIX as I haven't tried to do it). ie - You cannot close the structural index and keep the DBF open. -- HTH Steve Quinn
Post Follow-up to this message"Stephen Quinn" <steveqNOSPAM@integritynet.com.au> wrote in message news:c3o1tv$29l1b0$1@ID-88745.news.uni-berlin.de... > Gejza > > To my knowledge that doesn't work for the 'DBFCDX' > implemented by Successware which the 'DBFCDX' RDD > driver in 5.2 is based on (SIX2) (not sure about COMIX > as I haven't tried to do it). > ie - You cannot close the structural index and keep the > DBF open. That is correct in regards to 5.2+Comix. The only way to close a structural index is to close the dbf, turn off autoopen (cmxAutoOpen(.F.)) and reopen the dbf. -- Ray Marron
Post Follow-up to this messagePowered by vBulletin
Copyright 2000-2006 Jelsoft Enterprises Limited.