FiveTech Software tech support forums

... filters in mysql tables using fwh maria library. The data is in memory and filter is applied on data which is 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.

... new hex code is already in the MemoEdit: https://i.postimg.cc/jSC5QS5W/2023-06-27-14-11-57.jpg Due to the Unicode code 0xC4 the sorting is not ok. MsgInfo() to control what to change: https://i.postimg.cc/prbv8PSF/2023-06-27-14-13-11.jpg The UTF-8 Ä (0xC3 84) ...

hi,

nageswaragunupudi wrote:After sorting, oRs:BookMark points to the record number in the original order as read where as oRs:AbsolutePosition points to the relative position in the sorted order.

ah, understand

thx for all Answer

... reading a recordset, both point to the same record. After reading a recordset, we can sort the recordset in memory by oRs:Sort := cFieldName After sorting, oRs:BookMark points to the record number in the original order as read where as oRs:AbsolutePosition points to the relative position in the ...

... .......................... CLIENT->(dbseek(COD_CLI+str(COD_NUM,2))) with MARIA DB oRS:seek(COD_CLI, COD_NUM) correct ? tia We are thinking of sorting and seek on compound expressions. We will announce this enhancement soon

... .AND. AGE > 40" )// for locating next oRs:Locate( "CITY = 'N' .AND. AGE > 40",, .T. )  Note: With FWMariaDB, all sorting, seeking and locating are done in memory. Database is not acccessed or queried. Therefore these operations are very fast.

... Otto ChatGPT says: The bOnSort property is defined as a code block, but its implementation is missing in the provided code. You need to define the sorting logic inside this code block to make the sorting functionality work. In the MakeGroup function, there is a line oDbf:close(), which is closing ...

... Otto ChatGPT says: The bOnSort property is defined as a code block, but its implementation is missing in the provided code. You need to define the sorting logic inside this code block to make the sorting functionality work. In the MakeGroup function, there is a line oDbf:close(), which is closing ...

... date as above. This feature can be disabled or enabled by assigning classdata TGet():nDateKey := 0 or 2 * XBROWSE: - Autosort of array browse was sorting on a single column only. Now it is possible to specify multi-column sort by assigning an array of column numbers to oCol:cSortOrder. - SeekNext: ...

hi,

nageswaragunupudi wrote:And wherever possible, it may be easier to leave the sorting business to xbrowse itself and xbrowse does a good job.

thx for help

i´m sure it work under Fivewin but i use also HMG or Xbase++
so i always search Solution which i can use for all xBase-Dialect

And wherever possible, it may be easier to leave the sorting business to xbrowse itself and xbrowse does a good job.   local aDir  := DIRECTORY( "c:\fwh\samples\*.*" )   SET DATE FORMAT TO "dd.mm.yyyy"   SET TIME FORMAT ...

... Excel. * New functions in olefuncs.prg: - WinHttpObj( [[@]cCls] ) --> oHttp - FileSysObj() --> oFileSystem * FWMariaRowSet: - improvement in sorting speeds of char fields. * New function FW_SaveThumbnail( cImage, cThumb, nWidth, [nHeight] ) --> lSuccess in source\function\imgtxtio.prg

Hello to all friends There's a way to click on the Xbrowse column, it changes the sorting arrow according to the image Arrow up and down https://i.ibb.co/cJpQNPV/Whats-App-Image-2022-11-16-at-14-23-39.jpg OR https://i.ibb.co/sPvT19v/Whats-App-Image-2022-11-16-at-14-23-29.jpg ...

... 7162  7263  7364  7465  7566  7667  7768  7869  7970  8071  8172  8273  8374  8475  8576  8677  8778  8879  8980  90  that is in practice the sorting is from the number 1 and even if the number 1 is in the second column but it is at the bottom it is inserted before the 2 and so on ... Perhaps ...

From Harbour-users group DESCEND() function is designed to operate on binary (BYTE) sorting and gives reverted collation order only for codepages which use such collation. Because DESCEND() converts numbers to characters which have special order in CP you are using. ...