Search found 488 matches: filters

Return to advanced search

Re: Mr Rao :SetFilter no funciona

... have received a mail from them with link to download. Please keep a safecopy of your present lib and use this new lib Please let me know if the filters are working as expected. Please acknowledge
by nageswaragunupudi
Sat Mar 23, 2024 10:27 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Mr Rao :SetFilter no funciona
Replies: 11
Views: 2417

Re: Mr Rao :SetFilter no funciona

... registros con índices es mas rápido saludos. Here we are not talking about DBF tables. What you said is true for DBF fiters. We are talking about 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, ...
by nageswaragunupudi
Sat Mar 23, 2024 7:54 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Mr Rao :SetFilter no funciona
Replies: 11
Views: 2417

Re: Mr Rao :SetFilter no funciona

La tabla debe de tener un indice ordenado por el campo FIRST

It is not at all necessary to have index for filters to work.
by nageswaragunupudi
Sat Mar 23, 2024 8:21 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Mr Rao :SetFilter no funciona
Replies: 11
Views: 2417

Re: Question about performance RowSet

... which makes usage faster. First time reading is a bit slower when compared to other libraries. Once opened, updates, inserts, deletes, sorts, filters, etc. are all extremely faster than the other libs. If we look back in the forums, we posted speed comparison with other libraries a few years ...
by Eroni
Wed Mar 20, 2024 1:35 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about performance RowSet
Replies: 19
Views: 4039

Re: Question about performance RowSet

... which makes usage faster. First time reading is a bit slower when compared to other libraries. Once opened, updates, inserts, deletes, sorts, filters, etc. are all extremely faster than the other libs. If we look back in the forums, we posted speed comparison with other libraries a few years ...
by nageswaragunupudi
Sat Mar 16, 2024 10:20 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about performance RowSet
Replies: 19
Views: 4039

Fulltext-Search

... your own input DIALOG. Using a HASHis a bit unusual at the beginning. I need this search for my DMS system. I will gradually expand the query filters. Best regards, Otto #include "fivewin.ch"static h := {=>}static oTimerREQUEST DBFCDXREQUEST DBFFPTfunction main  ...
by Otto
Fri Mar 15, 2024 9:02 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Fulltext-Search
Replies: 6
Views: 1247

Re: Count xbrowse records

... ON or OFF: Both LASTREC() and RECCOUNT() include deleted records also. ORDKEYCOUNT() also does not exclude deleted records by itself, but honors filters, scopes and index expressions. So, 1) SET FILTER TO !DELETED()? OrdKeyCount() 2) INDEX ON RECNO() TAG RECS FOR !DELETED() ...
by wartiaga
Fri Feb 23, 2024 4:39 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Count xbrowse records
Replies: 5
Views: 254

Re: Count xbrowse records

... ON or OFF: Both LASTREC() and RECCOUNT() include deleted records also. ORDKEYCOUNT() also does not exclude deleted records by itself, but honors filters, scopes and index expressions. So, 1) SET FILTER TO !DELETED()? OrdKeyCount() 2) INDEX ON RECNO() TAG RECS FOR !DELETED() ...
by Silvio.Falconi
Fri Feb 23, 2024 1:26 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Count xbrowse records
Replies: 5
Views: 254

Re: Count xbrowse records

... ON or OFF: Both LASTREC() and RECCOUNT() include deleted records also. ORDKEYCOUNT() also does not exclude deleted records by itself, but honors filters, scopes and index expressions. So, 1) SET FILTER TO !DELETED()? OrdKeyCount() 2) INDEX ON RECNO() TAG RECS FOR !DELETED() ...
by nageswaragunupudi
Fri Feb 23, 2024 4:07 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Count xbrowse records
Replies: 5
Views: 254

Re: RAO advice on using Mysql

Hello RAO Since it is not possible to use filters with RecSet I am trying to close and reopen RecSet in xBrowse. I normally use WITH OBJECT oBrw:oRs         :Close()         :Source  := cNewSelectWithWhere          :ActiveConnection := ...
by Maurizio
Tue Feb 06, 2024 5:34 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: RAO advice on using Mysql
Replies: 12
Views: 979

Re: Error in FW_ArrayAsRecordSet Seek - Please help

... We can sort on any column We can do incremental seek on the sorted column We can do incremental wild seek Also We can do incremental filters including wild filters. XBrowse uses Find method for incremental seeks.
by nageswaragunupudi
Wed Aug 09, 2023 7:31 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Error in FW_ArrayAsRecordSet Seek - Please help
Replies: 6
Views: 359

Re: XBROWSE ERROR

... 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 perform the ...
by nageswaragunupudi
Tue Aug 08, 2023 8:13 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: XBROWSE ERROR
Replies: 5
Views: 389

Make a dialog MDI or at least stay on screen

... I want. I have to close this dialog to go back to the first xbrowse, select a second field and do the process all over The function is called, filters are set again, I select, need to close the dialog and keep going on... I would like that the function eanfotoselect is called onces and stay ...
by Marc Venken
Tue Jun 27, 2023 9:15 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Make a dialog MDI or at least stay on screen
Replies: 1
Views: 250

Re: lIncrFilter + MDI

... GO TOP DEFINE FONT oFont NAME "TAHOMA" SIZE 0,-12 DEFINE DIALOG oDlg SIZE 750,300 PIXEL FONT oFont ; TITLE "XBrowse Incremental Filters" aFlds := aHdrs := HB_ATokens( cList, ',' ) @ 30,10 XBROWSE oBrw SIZE -10,-10 PIXEL OF oDlg ; COLUMNS aFlds HEADERS aHdrs ; DATASOURCE ...
by cpheraclio
Sun Jun 04, 2023 11:22 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: lIncrFilter + MDI
Replies: 4
Views: 370

Create reports by pagination TReport, TPreview

... have the following idea to generate reports in FiveWin using TReport.prg: Today, the report is created like this: 1) Creates the window to get the filters 2) Do the SELECT - MySQL 3) Rotate the report 4) Opens the automatic Preview, if you are not going to generate .xls or .pdf So if I have a report ...
by Ari
Wed May 31, 2023 1:01 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Create reports by pagination TReport, TPreview
Replies: 0
Views: 129
Next

Return to advanced search