FiveTech Software tech support forums

... already in the memory. Filters, sorting, seeking are all done in memory and do not read from the server. So there is no dependance at all on the indexes on the server.

Dear Rao, a question if I have an xbrowse with customer.dbf (with a combobox to select the indexes and a get to search for customers - see the example diagram below) USE CUSTOMER.... DEFINE DIALOG oDlg @ 10, 165 GET oGet VAR cSeek SIZE 200,19 PIXEL OF oDlg PICTURE ...

... you could use a function that generates an ID not currently used in `oBrw:aArrayData`. ### Notes - Ensure that `oBrw:aSelectedRows` contains the indexes of selected rows in `oBrw:aArrayData`. This might require additional implementation based on how row selection is handled in your application. ...

... DBFCDX DBFNTX DataBases in use ================ 1: => EMP RddName: DBFNTX ============================== RecNo RecCount BOF EOF 1 1 .F. .F. Indexes in use TagName Relations in use Classes in use: =============== 1 ERROR 2 HBCLASS 3 HBOBJECT 4 TFONT 5 WIN_OLEAUTO 6 TOLEAUTO 7 TWINDOW 8 TDIALOG ...

... DBFCDX DBFNTX DataBases in use ================ 1: => EMP RddName: DBFNTX ============================== RecNo RecCount BOF EOF 1 1 .F. .F. Indexes in use TagName Relations in use Classes in use: =============== 1 ERROR 2 HBCLASS 3 HBOBJECT 4 TFONT 5 WIN_OLEAUTO 6 TOLEAUTO 7 TWINDOW 8 TDIALOG ...

... age >50) making the user select the desired group and then go back to normal xbrowse obviously with search on the fields depending on the indexes thanks for a solution a small test #include "fivewin.ch"REQUEST DBFCDXstatic lTipo1:=.f.,ltipo2:=.f.//----------------------------------------------------------------------------////----------------------------------------------------------------------------//function ...

... agree on this. Thanks a lot Mr. Enrico. Sorry, I did not know about this before. Yes, I see the difference in the timestamps of the dbf file (also indexes and memo files, if exist) Just for information to all: COMMIT executes the WinAPI function FlushFileBuffers( handle ) thereby ensuring that ...

... SET HARDCOMMIT ON OR OFF Simply changing the data and if shared executing UNLOCK is all that is enough to ensure visibility of data as well as indexes to all other users on the network immediately So, please keep aside the documentation and STOP using COMMIT. Please Note: I am saying this with ...

... it need an Index to SEEK. *CDX seems to be open "automatic" but *.NTX must be open before ? Yes. In case of DBFNTX, after USE, open indexes by SET INDEX TO ..... and it is ready. b.) if *.CDX have TAGs, how to change TAG when click on Header of Column ? XBrowse automatically does ...

... .f.? oRs:Supports( "seek" ) // --> .f. This is a synthetic recordset and has no server and no physical table and no physical indexes. So this recordset's CursorLoction property is adUseClient. Even oRs:ActiveConnection is NIL, because this is not connected to any server. Being ...

Dear Marc,

No timeframe yet, just thinking about the DBF structure for help.dbf

What DBF structure (fields and indexes) should we use for it ?

... content. 6. Organize topics: After creating help topics, you need to organize them into a logical structure. You can create tables of contents, indexes, and other navigation elements to help users find information easily. Use the "Project" menu to add, reorder, and modify the structure ...

Rao

Brilliant ... been working on this RUSH project .. Thank You, Rick

We do not need to create indexes at all.
Just set order to the column name we want like this:

Code: Select all  Expand view

oRs:Sort := "OwnerName"
// or
oRs:Sort := "PetName"

Or use the default AUTOSORT clause of Xbrowse and use Incremental search

I have a single Sql table oRs and I want to have 2 lookup options or Sql indexes on the same recordset .. This dataset is for a local town park where you have information on Owners ( name ) and pets by name . I want to be able to have a single recordset where ...