Search found 221 matches: setfilter

Return to advanced search

Re: Mr Rao :SetFilter no funciona

...  oRs   := oCn:RowSet( "select * from states" )   cFilter  := "NAME Like '%nta-cat%'"  // case not sensitive   oRs:SetFilter( cFilter )   ? oRs:Filter   oRs:GoTop()   xbrowser oRs title FWVERSION   oRs:Close()   oCn:Close()return nil ...
by nageswaragunupudi
Sat Mar 23, 2024 10:52 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Mr Rao :SetFilter no funciona
Replies: 11
Views: 213

Re: Mr Rao :SetFilter no funciona

Just sent revised FiveH.lib (for FWH2307) for Harbour and BCC Sent through "wetransfer.com" You must 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 ackno...
by nageswaragunupudi
Sat Mar 23, 2024 10:27 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Mr Rao :SetFilter no funciona
Replies: 11
Views: 213

Re: Mr Rao :SetFilter no funciona

Muy agradecido Mr Rao
funciona perfectamente
by Willi Quintana
Sat Mar 23, 2024 10:07 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Mr Rao :SetFilter no funciona
Replies: 11
Views: 213

Re: Mr Rao :SetFilter no funciona

We fixed the bug and this will work from the next release.

You said you are using FWH2307 with Harbour and BCC.
Please contact me on this email
nageswaragunupudi [at] gmail [dot] com.

I will send you the revised FiveH.lib for FWH2307 with this fix.
by nageswaragunupudi
Sat Mar 23, 2024 8:25 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Mr Rao :SetFilter no funciona
Replies: 11
Views: 213

Re: Mr Rao :SetFilter no funciona

MR. Rao, con tablas de miles de 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 ...
by nageswaragunupudi
Sat Mar 23, 2024 7:54 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Mr Rao :SetFilter no funciona
Replies: 11
Views: 213

Re: Mr Rao :SetFilter no funciona

MR. Rao, con tablas de miles de registros con índices es mas rápido
saludos.
by sysctrl2
Sat Mar 23, 2024 4:07 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Mr Rao :SetFilter no funciona
Replies: 11
Views: 213

Re: Mr Rao :SetFilter no funciona

Mr Eao, gracias por atenderme...

FW 23.07,
BCC 7.10
Harbour 3.2.0dev (r1904111533)

Saludos
by Willi Quintana
Sat Mar 23, 2024 12:15 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Mr Rao :SetFilter no funciona
Replies: 11
Views: 213

Re: Mr Rao :SetFilter no funciona

Mr Rao. esto no funciona: oData:SetFilter("codbar1 LIKE '%RF-10392%'") // NO Funciona oData:SetFilter("codbar1 LIKE '%RF10392%'") // Si Funciona Gracias por su atencion This is a bug in our library. We regret for this. ...
by nageswaragunupudi
Sat Mar 23, 2024 8:28 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Mr Rao :SetFilter no funciona
Replies: 11
Views: 213

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: 213

Re: Mr Rao :SetFilter no funciona

Estimado sysctrl2 cVar := "RS-00887" //------------ el dato contioene un guion oData:SetFilter("codbar1 LIKE '%" + cVar + "%'") //-----------------------> NO funciona, no filtra cVar := "RS000887" //------------ el dato contioene ...
by Willi Quintana
Fri Mar 22, 2024 10:30 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Mr Rao :SetFilter no funciona
Replies: 11
Views: 213

Re: Mr Rao :SetFilter no funciona

La tabla debe de tener un indice ordenado por el campo FIRST   //setfilter cFirst := "Santos"oRs:SetFilter( "FIRST = ?", { rtrim(cFirst) } )//locate  bSeek    := oRs:ExprAsBlock( "first ...
by sysctrl2
Fri Mar 22, 2024 7:43 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Mr Rao :SetFilter no funciona
Replies: 11
Views: 213

Mr Rao :SetFilter no funciona

Mr Rao.
esto no funciona:
oData:SetFilter("codbar1 LIKE '%RF-10392%'") // NO Funciona
oData:SetFilter("codbar1 LIKE '%RF10392%'") // Si Funciona

Gracias por su atencion
by Willi Quintana
Thu Mar 21, 2024 11:30 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Mr Rao :SetFilter no funciona
Replies: 11
Views: 213

Re: MariaDb SetFilter Error no definida: SOLUCIONADO

... ) If cPer = Space(30) x := "" Else x := Upper(Alltrim( cPer )) EndIf cWhere := "detalle LIKE '"+x+"%'" oQry:SetFilter( cWhere ) aServer:ShowError() SysRefresh() oBrw:Refresh() WaitOff( @oWait ) EndIf
by CARLOS ATUNCAR
Sat Jan 27, 2024 1:14 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: MariaDb SetFilter Error no definida: SOLUCIONADO
Replies: 2
Views: 136

Re: MariaDb SetFilter no realiza Filtrado

... ) If cPer = Space(30) cWhere := "" Else x := Upper(Alltrim( cPer )) cWhere := "c.detalle LIKE '% ? %' " EndIf oQry:SetFilter( cWhere ,{x}) aServer:ShowError() SysRefresh() oBrw:Refresh() WaitOff( @oWait ) EndIf Return da este resultado Compiler version: xHarbour ...
by CARLOS ATUNCAR
Sat Jan 27, 2024 12:04 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: MariaDb SetFilter Error no definida: SOLUCIONADO
Replies: 2
Views: 136

MariaDb SetFilter Error no definida: SOLUCIONADO

... ) If cPer = Space(30) cWhere := "" Else mWhere := {Upper(Alltrim( cPer ))} cWhere := "c.detalle LIKE '%?%'" EndIf TRY oQry:SetFilter( cWhere , mWhere) CATCH o SysRefresh() END oBrw:Refresh() WaitOff( @oWait ) EndIf Return Pero no me esta realizando el filtrado
by CARLOS ATUNCAR
Fri Jan 26, 2024 11:36 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: MariaDb SetFilter Error no definida: SOLUCIONADO
Replies: 2
Views: 136
Next

Return to advanced search