FiveTech Software tech support forums

... of xbrowse unless we inhibit it by setting oBrw:lIncrSeek := .f. if the data is sorted on any column and lFastEdit is not .t., pessing any key seeks the first row where the sorted column value begins with that character. Example, pressing "a" seeks value starting with "a" ...

... sorted column We can do incremental wild seek Also We can do incremental filters including wild filters. XBrowse uses Find method for incremental seeks.

... To experience the behavior of "incremental" seek/filter please XBROWSER oRs AUTOSORT and then play with the auto "incremental" seeks and filters. Well, if you dont want this, the old traditional ways is always available to you. Use a Get to get the seek expression, then you ...

In RDBMSs other than DBFs, indexes are not used for Navigation or for Seeks. The purpose of indexes is only to optimize where clauses for queries. Intelligent planning of indexes is an essential part of database design to optimize queries in OLAP (Online Analytical ...

1) Can you provide link to my original sample? I would have never used bStrImage here.

2) Gets and Incremental seeks are mutually exclusive. If you want to use Get, then let the user enter the value in the Get first. After her enters you SEEK the vaue and then set oBrw:BoookMark := RECNO()

Hola Jose Luis: Puedes probar con los valores de la clase xbrowse // Data for Incremental Seeks/Filters DATA lSeekWild AS LOGICAL INIT .f. DATA lIncrFilter AS LOGICAL INIT .f. DATA bFilterExp DATA cFilterFld // end of block Con lSeekWild en .t. busca por contenido y ...

Hola Jose Luis: Puedes probar con los valores de la clase xbrowse // Data for Incremental Seeks/Filters DATA lSeekWild AS LOGICAL INIT .f. DATA lIncrFilter AS LOGICAL INIT .f. DATA bFilterExp DATA cFilterFld // end of block Con lSeekWild en .t. busca por contenido y ...

Uwe, Some suggestions : Why do you copy to one of the files ? From day one, I use your version with just 1 file, and ALL seeks (Topic, User, ...) are done like the original version. Quick and simple I see the logic if you say that after time, you select items from the browse (based ...

... by ::Blank() method, then the data is appended, 81. SaveBuff() Internal Used by ::Save() 82. Seek( uExpr, [lSoft], [lWildSeek] ) --> lFound Seeks uExpr and returns lFound. 83. SetArea( nWorkArea ) Internal 84. SetBuffer( [lOnOff] ) --> ::lBuffer Optionally sets ::lBuffer and returns value ...

... in Runtime error. Fixed. - Fix: Incremental Seek in XBrowse: When a space character only is pressed, the row pointer is moved to the top. Now it seeks to a value starting with space. If not found, the key is rejected. This is the correct behavior. * Enhancement: TDataRow class now supports TPQQuery ...

... If you are using Dolphin, the limitations are due to oQry:Seek( .. ) method. If you are using FWMARIADB, you should be able to use incremental seeks with date and numeric fields also. Solutions: 1) Improve oQry:Seek method for your neeeds. 2) Set oCol:cSortOrder of date and numeric columns ...

... class will be fully ready by 17.04. Now it can be used with some limitations: 1. Edits possible, but not appends 2. Sorts, filters, incremental seeks/filters not yet supported. - MYSQL EMBEDDED SERVER: This version enables connecting to embedded server. For full details please see: http://forums.fivetechsupport.com/viewtopic.php?f=3&t=33798 ...

... writing data. (f) Examines all open indexes and determine what index tag (order) should be used for which column to autosorting and incremental seeks,etc. (g) And a lot more. Adopting the old style of programming used with other browses is the surest way to deny all the power of xbrowse and ...

... is not necessary. This may result in very large cdx files and slow down on networks. Better you create index on fields that are necessary for seeks and filters. ( Filters are optimized when the fields involved are indexed) If you specify fieldlist, you do not need to specify UPPER(), because ...

Numerics and dates are sorted in the order of the values, not as character values.
So the seeks can not be on the initial characters as they appear in the browse.

Numerics: Seek to the value next higher than the value entered.
Dates: Seeks to the value next higher than the value in YYYYMMDD format