Search found 127 matches: filtered

Return to advanced search

Re: Filtrar consulta de tdolphin

... realizada para mostrarla en un xBrowse. This is extremely easy using FWH Maria library. But here we are using Dolphin. Do not think of reading the filtered data again from the Server. Let us just filter the data inside XBrowse. i.e., let us display in xbrowse only those records that match the filter ...
by nageswaragunupudi
Tue Sep 26, 2023 5:42 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Filtrar consulta de tdolphin
Replies: 15
Views: 816

Re: Error ADODB.Recordset/6 DISP_E_UNKNOWNNAME: ISKINDOF

... Slip .. I bounce the Name against the Employee table Kayla J Brown ... and when I tried to Filter for the name and looking at the result of the filtered data xBrowse( oRsEmp ) that is where I got the "ISKINDOF error .. I fixed the employee name in both the Security and Employee tables .. ...
by Rick Lipkin
Thu Mar 02, 2023 7:00 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Error ADODB.Recordset/6 DISP_E_UNKNOWNNAME: ISKINDOF
Replies: 1
Views: 166

Re: Copy ARRAY filtered by column

1) Using FWH function ArrayTransposeQ() aData := .... your arrayaNew  := ArrTransposeQ( aData )HB_ADel( aNew, 4, .t. )HB_ADel( aNew, 2, .t. )aNew  := ArrTranposeQ( aNew )  a) This is not efficient b) You do not use FWH functions in modHarbour. 2) AEval ...
by nageswaragunupudi
Wed Nov 16, 2022 7:13 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Copy ARRAY filtered by column
Replies: 2
Views: 206

Re: Copy ARRAY filtered by column

Hello friends, the code is for FIVEWIN and modHarbour. This is how to use in modHarbour. Best regards. Otto https://mybergland.com/fwforum/mod_xbrwclip4.jpg https://mybergland.com/fwforum/mod_xbrwclip3.jpg // Copy an array select cols and col sorting#include "FiveWin.ch&...
by Otto
Tue Nov 15, 2022 6:57 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Copy ARRAY filtered by column
Replies: 2
Views: 206

Copy ARRAY filtered by column

Dear friends,

What is the most effective way to copy certain columns from an ARRAY to a new ARRAY:
eg ARRAY {"col1", "col2", "col3", "col4", "col5"}

new ARRAY {"col1", "col3", "col5"}

Best regards,
Otto
by Otto
Tue Nov 15, 2022 8:05 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Copy ARRAY filtered by column
Replies: 2
Views: 206

Is Xbrowse Barget still intended to filter data

... having a extended call to the function marc_setfilter(oBrwsel,"CustName") and insite the function make a selection for using scoped or filtered data do case case cData = "CustName" ... set index name ... scope the data for quick access case cData = "CustStreet" set ...
by Marc Venken
Sat Nov 05, 2022 1:33 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Is Xbrowse Barget still intended to filter data
Replies: 2
Views: 205

Re: reccount en mariadb

Code: Select all  Expand view
oRs:RecordCount()
oRs:RecCount()
oRs:LastRec()


--> Total number of records

When a filter is applied:
Code: Select all  Expand view
oRs:KeyCount()

Number of filtered records
by nageswaragunupudi
Mon Apr 25, 2022 12:24 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: reccount en mariadb
Replies: 2
Views: 198

xBrowse, xBrowser enhansement - Rao

... Ado or DbfCdx. I would be VERY grateful if you could add some code perhaps like this to be able to show how many records were in the recordset of filtered .dbf    oLbxC:lFooter     := .t.   oCol2             := oLbxC:aCols[ 1 ]   oCol2:bFooter     := { || Ltrim( Str( oLbxC:KeyNo() ...
by Rick Lipkin
Fri Mar 26, 2021 2:56 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse, xBrowser enhansement - Rao
Replies: 3
Views: 716

Incremental search in filtered array

... ) })   EndIFreturn .t.  Giving Set Filter filters it by State = "NY". I need to do incremental search on the filtered. Thanks for the help Regards
by acuellar
Thu Jul 23, 2020 7:51 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Incremental search in filtered array
Replies: 1
Views: 271

Re: xBrowse: Process filtered rows only

Ok. This version seems to work       oCbxAll:bChange := <||                              local hState := {=>}                        &...
by hua
Thu Jun 11, 2020 9:44 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse: Process filtered rows only
Replies: 2
Views: 538

Re: xBrowse: Process filtered rows only

I got an idea to do it this way. But seems to be caught in an infinite loop     redefine checkbox oCbxAll var lAll id 109 of oDlg      oCbxAll:bChange := <||                              local hSta...
by hua
Thu Jun 11, 2020 8:28 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse: Process filtered rows only
Replies: 2
Views: 538

xBrowse: Process filtered rows only

... has been pointed out to me this logic is not accurate if someone did filtering prior to checking it as it will traverse the whole array, not just filtered ones https://i.postimg.cc/0NbPYxNW/emailer.jpg As shown in the screen above which is displaying an array of hashes, when user ...
by hua
Mon Jun 01, 2020 7:59 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse: Process filtered rows only
Replies: 2
Views: 538

Re: xBrowse and SQLRDD bug

... SQLRDD? DBFILTER()ORDSETFOCUS()  Can you also please confirm that when a filter is set, OrdKeyCount() returns the count of filtered records only? In the post you referred, Mr. Kokoo suggested maintaining an array of RecNo()s outside the xbrowse. This works well but the programmer ...
by nageswaragunupudi
Thu Apr 30, 2020 12:25 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse and SQLRDD bug
Replies: 18
Views: 2414

Re: Possible to run 2 browser synchronously ? ( Test-download )

... section = 1 browser ) Browser 3 shows a horizontal scrollbar NO vertical synchronous needed !!! The file is splitted in 3 sections each section is filtered to group and section oProj := TDatabase():Open( , "PROJECT", "DBFCDX", .T. ) oProj:CreateIndex( "PROJECT", "PROJ1", ...
by ukoenig
Wed Oct 09, 2019 1:45 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Possible to run 2 or 3 browser synchronously ?
Replies: 10
Views: 3001
Next

Return to advanced search