FiveTech Software tech support forums

YES, i have try to SET bSeek to NIL

my "Problem" was that i have many DBF which work with *.NTX which does not "Autopen" Index

Does not matter.
It is not a good idea to disturb XBrowse's internal defaults.
The default bSeek does not harm you when you are browsing DBFNTX dbfs.

... bSeek returns .F. YES, i have try to SET bSeek to NIL my "Problem" was that i have many DBF which work with *.NTX which does not "Autopen" Index

... 'dd/mm/yyyy' set century on Request DBFCDX, DBFFPT, OrdCreate, OrdKeyCount, OrdKeyNo, OrdKeyGoto RddSetDefault( 'DBFCDX') set deleted on set autopen off set exclusive on Set optimize on cursorwait() readinsert( .t. ) SetBalloon( .T. ) setresdebug( .F. ) clear all FwSetLanguage( 2 ) Request ...

Sivio, Maybe you didn't know that CDXs have always had the option to open all the indexes automatically when the DBF is opened. And as I understand it, NTXs can now do that also. REQUEST DBFCDX rddsetdefault( "DBFCDX" ) SET EXCLUSIVE OFF SET(_SET_AUTOPEN, .T. ) yes I knew it but it happen...

Sivio,

Maybe you didn't know that CDXs have always had the option to open all the indexes automatically when the DBF is opened. And as I understand it, NTXs can now do that also.

REQUEST DBFCDX
rddsetdefault( "DBFCDX" )
SET EXCLUSIVE OFF
SET(_SET_AUTOPEN, .T. )

Set autopen off

... Area ......:1 -------------------------- Environmental Information -------------------------- SET ALTERNATE......: OFF SET ALTFILE........: SET AUTOPEN........: ON SET AUTORDER.......: 0 SET AUTOSHARE......: 0 SET BACKGROUNDTASKS: OFF SET BACKGROUNDTICK.: 1000 SET BELL...........: OFF SET BLINK..........: ...

... TEMPORAY NAMES INDEX LIST TO {"TMP","TEMP"} // SET ADO FIELDRECNO TABLES LIST TO {{"EMPRESA","ID"}} // SET AUTOPEN OFF // SET ADO FORCE LOCK OFF SET ADO DEFAULT DATABASE TO "EMPRE01" SERVER TO "localhost" ENGINE TO "MYSQL" USER ...

Gunther, USE cTable SET INDEX TO index1,index2,index3 Order focus should be index1. If SET AUTOPEN ON the order focus will be on the first index in the SET ADODBF.. You should only use INDEX ON for temporary indexes as permanent ones should be indicated on SET ADODBF ...

... autoopen on always the ADBODBF INDEX its added first to the order list when you open the table. If INDEX ON is after it will be added after. If autopen off index on will be added first if you not did explicitly set index to the index in ADODBF INDEX. If you found other behavior this is not the ...

... ,; {"TEST2", "LAST"} ,; {"TEST3", "AGE"} }} SET ADO DEFAULT RECNO FIELD TO "ID" SET AUTOPEN ON //might be OFF if you wish SET AUTORDER TO 1 // first index opened can be other SET ADO DEFAULT DATABASE TO "TEST2.mdb" ENGINE ...

... ,; {"TEST2", "LAST"} ,; {"TEST3", "AGE"} }} SET ADO DEFAULT RECNO FIELD TO "HBRECNO" SET AUTOPEN ON //might be OFF if you wish SET AUTORDER TO 1 // first index opened can be other SET ADO DEFAULT DATABASE TO "TEST2.mdb" ENGINE ...

Next, I SET AUTOPEN OFF: Error description: Error BASE/1075 Argument error: > Args: [ 1] = N 1 [ 2] = C Stack Calls =========== Called from: .\source\classes\DATABASE.PRG => ORDERTAGINFO( 1258 ) Called from: .\source\classes\XBROWSE.PRG ...

... be present. It is working. Define at FUNCTION ListIndex() the indexes. They will be opened with SET INDEX TO INDEX1, INDEX2, INDEX3... if SET AUTOPEN is OFF. AUTO OPEN and SET AUTOORDER should be working. Define globally with a SetUp ADORDD function the RBDM type (Access, MSSQL, MySQL..), ...

... only do two little changes : Define at FUNCTION ListIndex() the indexes. They will be opened with SET INDEX TO INDEX1, INDEX2, INDEX3... if SET AUTOPEN is OFF. Define globally with a SetUp ADORDD function the RBDM type (Access, MSSQL, MySQL..), the server, the user name, the password to connect ...