Search found 77 matches: cfilter

Return to advanced search

Re: Creation an array Multiple on Horizontal on Xbrowse

Cesar, to select 2022 year I made cFilter:= "LTRIM(STR(YEAR(FIELD->DATA)))= '" + nyear + "'" oQry:SetFilter(cFilter) oQry:GoTop() and run ok I f the user want show only ( 10,20,30,40,50,100,200,300,500) records How I ...
by Silvio.Falconi
Tue Sep 27, 2022 8:45 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Creation an array Multiple on Horizontal on Xbrowse - RESOLV
Replies: 7
Views: 760

Re: show only some records on Xbrowse ( nRecords, year)

this run ok        cFilter:= "LTRIM(STR(YEAR(FIELD->DATA)))= '" + nyear + "'"        oDbf:SetFilter(cFilter)        oDbf:GoTop()  How I can add the number of records to show ? sample only 5 records ...
by Silvio.Falconi
Tue Sep 27, 2022 10:20 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: show only some records on Xbrowse ( nRecords, year)
Replies: 10
Views: 590

Re: Help with ascan

... then you have to code it in pure C language. C language is the fastest speed you will ever get. Antonio, I not understood If I make number:= 34 cFilter := "oDbf:Ba1=" +number oDbf:setFilter(cFilter) nFreq:= oDbf:keycount() It immediately gives me the frequency value in fast mode for ...
by Silvio.Falconi
Fri May 13, 2022 8:42 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Help with ascan
Replies: 16
Views: 906

Re: To Nages : locate ... 2

... in Dos in the Dos window (cmd) On Old dbf I had a field "settimana" was of 10 CR , on new dbf I have a date field I tried without locate cFilter := "ltrim(str(year(data))) == '" + ltrim(str(nYear1)) +"'" oDbf:setFilter(cFilter) oDbf:gotop() ?oDbf:recno() and returns ...
by Silvio.Falconi
Sat Apr 02, 2022 3:42 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: To Nages : locate ... 2
Replies: 3
Views: 288

Re: MARIADB cSELECT?

cFilter := oQry:cFilter
by vilian
Mon Feb 28, 2022 11:27 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: MARIADB cSELECT?
Replies: 4
Views: 377

Re: TDatabase: Parameterized filters and ReFilter()

When you set filter with
oDbf:SetFilter( cFilter, aParams )
The method applier the aParams to cFilter and prepares the filter string to set the filter.
You can check the exact filter string with
? oDbf:DBFILTER()
and see if this is what you expected.
by nageswaragunupudi
Tue May 25, 2021 4:52 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: TDatabase: Parameterized filters and ReFilter()
Replies: 9
Views: 1095

Re: TDatabase: Parameterized filters and ReFilter()

cFilter := "TRIM(TIPO) == ? .AND. GIORNI == ? .AND. IDELEMENTO == ? .AND. " + ;
"SETTORE == ? .AND. ALLTRIM(IDLISTINO) == ? .AND. MESE == ?"

oDbf:SetFilter( cFilter, { cTipo, nGiorni, cidelemento, cSettore, clistino, nmese } )
by nageswaragunupudi
Tue May 25, 2021 3:17 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: TDatabase: Parameterized filters and ReFilter()
Replies: 9
Views: 1095

TDatabase: Parameterized filters and ReFilter()

SetFilter( cFilter, aParams ) oDbf:SetFilter( "AGE >= ? .AND. AGE <= ?", { 30, 40 } )// This sets filter AGE >= 30 .AND. AGE <= 40// LateroDbf:ReFilter( { 40, 50 } )// changes ...
by nageswaragunupudi
Fri May 21, 2021 4:08 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: TDatabase: Parameterized filters and ReFilter()
Replies: 9
Views: 1095

Re: Can FW also read a intire online webshop ?

cFilter will look like this --->> 'DASSY' $ UPPER( DBRECORDINFO( 9 ) ) .AND. 'BARI' $ UPPER( DBRECORDINFO( 9 ) ) What is DBRECORDINFO(9) doing ? Looking into all field :?: :?: This is the full record as a string. You ...
by nageswaragunupudi
Thu Mar 18, 2021 11:52 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Can FW also read a intire online webshop ?
Replies: 14
Views: 1686

Re: Can FW also read a intire online webshop ?

I'm trying to analyse the function below and see that this is the string that is build up when typing words in Xbrowse cFilter will look like this --->> 'DASSY' $ UPPER( DBRECORDINFO( 9 ) ) .AND. 'BARI' $ UPPER( DBRECORDINFO( 9 ) ) What is DBRECORDINFO(9) doing ? Looking into ...
by Marc Venken
Thu Mar 18, 2021 9:53 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Can FW also read a intire online webshop ?
Replies: 14
Views: 1686

Re: New FTDN August/Agosto 2020 (FWH 20.08)

... mientras que los datos se alinean a la derecha. http://forums.fivetechsupport.com/viewtopic.php?f=6&t=39312 * TArrayData: El método SetFilter( cFilter ) falla cuando la expresión de filtro contiene un nombre de campo más de una vez. Esto se debe a un error en la función FW_ExprnAsBlock() en ...
by Antonio Linares
Tue Sep 22, 2020 4:33 pm
 
Forum: WhatsNew / Novedades
Topic: New FTDN August/Agosto 2020 (FWH 20.08)
Replies: 3
Views: 2255

New FTDN August/Agosto 2020 (FWH 20.08)

... displayed centered, while data is aligned right. http://forums.fivetechsupport.com/viewtopic.php?f=6&t=39312 * TArrayData: Method SetFilter( cFilter ) fails when the filter expression contains a field name more than once. This is due to a bug in the function FW_ExprnAsBlock() in fwh\source\function\vstrfun1.prg. ...
by Antonio Linares
Sun Sep 20, 2020 11:38 am
 
Forum: WhatsNew / Novedades
Topic: New FTDN August/Agosto 2020 (FWH 20.08)
Replies: 3
Views: 2255

Re: tArrayData

... que estoy con esto pero quería agotar todas las posibilidades antes de molestar. Corrijo el mensaje, Me da este error usandolo asi tal cual: cFilter := DBF_ApplyParams( "id_cliente = ? .AND. cpte_fecha >= ? .AND. cpte_fecha <= ?", { ::id_contribuyente, dFecDes, dFecHas } ) ...
by Marcelo Roggeri
Tue Sep 01, 2020 7:08 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: tArrayData
Replies: 12
Views: 1188

Nages test sample ( search in array)

... https://i.postimg.cc/Z5KL0HfB/voce.png the error if on this line oBrw:bFilterExp := &( cFilter ) I have this error Error occurred at: 04/16/20, 18:06:55   Error description: Error BASE/1068  Argument error: array access   Args:     [ ...
by Silvio.Falconi
Thu Apr 16, 2020 4:30 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Nages test sample ( search in array)
Replies: 0
Views: 183

Re: Multiple Dimension Array in Combobox

use an array and combobox instead of dbcombo

@ 36,75 COMBOBOX cFilter ITEMS ArrTranspose( aListini )[ 2] SIZE 120,400 PIXEL OF oInfoTariffe;
ON CHANGE
by Silvio.Falconi
Wed Aug 28, 2019 2:14 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Multiple Dimension Array in Combobox
Replies: 24
Views: 4009
Next

Return to advanced search