Search found 42 matches: dbfilter

Return to advanced search

Re: XBrowse con xBase - Efecto Pijama - Error en Red

... ), OrdKeyGoTo( n ), OrdKeyRelPos( n / ::nLen ) ) ) ) } * else ::lRelyOnKeyNo := If( Set( _SET_DELETED ), "DELETED()" $ Upper( DbFilter() ), .t. ) * endif endif DEFAULT ::bKeyNo := {| n | iif( n == nil,; ( ::cAlias )->( OrdKeyNo() ),; ( ::cAlias )->( OrdKeyGoto( n ); ) ...
by José
Tue Mar 21, 2023 2:41 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: XBrowse con xBase - Efecto Pijama - Error en Red
Replies: 3
Views: 385

Re: dbase III/IV file encrypted

Cannot find definition for DBI_PASSWORD here are all DBI_ the constant i found for dbinfo() /* constants for dbInfo() */ #define DBI_ISDBF 1 /* Does this RDD support DBFs? */ #define DBI_CANPUTREC 2 /* Can this RDD Put Records? */ #define DBI_GETHEADERSIZE 3 /* Data file's header size */ #define DBI...
by lorenzoazz
Sat Jan 29, 2022 1:17 pm
 
Forum: All products support
Topic: dbase III/IV file encrypted
Replies: 8
Views: 980

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: seek with tdatabase

I found this solution but I not Know if is Good or exist another method Making a dbfilter , creating an array then search on this array if there is the number of Room Any suggestions ? static function SearchRooms( dStart, dEnd, cRoom )   field ...
by Silvio.Falconi
Wed Jun 03, 2020 8:41 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: seek with tdatabase
Replies: 1
Views: 381

Re: xBrowse and SQLRDD bug

Yes, I confirm that DBFILTER()/SET FILTER TO and ORDSETFOCUS() work under SQLRDD.

And yes, when a filter is set, OrdKeyCount() Works too.

But never OrdKeyNo()

I am going to test your new versión and share the results.

Thank you.
by MOISES
Thu Apr 30, 2020 7:41 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse and SQLRDD bug
Replies: 18
Views: 2400

Re: New FTDN May/Mayo 2019 (FWH 19.05)

... .AND. HIREDATE >= 0d20000101" SET FILTER TO &cFilter * Nueva función FW_DbFilterBlock() --> bFilterExp La función de Harbour DBFILTER() devuelve la condición del filtro como una cadena de caracteres. Esta función devuelve el bloque de código usado por el filtro. * Database.prg ...
by Antonio Linares
Fri Jun 07, 2019 11:14 am
 
Forum: WhatsNew / Novedades
Topic: New FTDN May/Mayo 2019 (FWH 19.05)
Replies: 4
Views: 3097

New FTDN May/Mayo 2019 (FWH 19.05)

... "T" .AND. HIREDATE >= 0d20000101" SET FILTER TO &cFilter * New function FW_DbFilterBlock() --> bFilterExp Harbour functin DBFILTER() returns the filter condition as string This function returns the codeblock used for filter * database.prg. - New: Method SetFilter( cFilter, ...
by Antonio Linares
Mon Jun 03, 2019 12:54 pm
 
Forum: WhatsNew / Novedades
Topic: New FTDN May/Mayo 2019 (FWH 19.05)
Replies: 4
Views: 3097

Re: class xbrowse: suggestion for improvement

We can not use DBFILTER() and that is proved in the above sample. DBFILTER() returns the current filter string. What we need is the current filter codeblock. FWH1905 provides a new function FW_DBFILTERBLOCK() which returns the current ...
by nageswaragunupudi
Sun Jun 02, 2019 12:32 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: class xbrowse: suggestion for improvement
Replies: 6
Views: 784

Re: class xbrowse: suggestion for improvement

... that when using the RddIncrFilter method, it made a preexisting filter be lost when changing the search filter, This is an issue. We can not use dbfilter() to combine the existing filter because, if the existing filter contains local variables, evaluation of such filter results in a runtime error.
by nageswaragunupudi
Sat Jun 01, 2019 8:55 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: class xbrowse: suggestion for improvement
Replies: 6
Views: 784

Problema con filtros

... en un programa, creo un filtro de esta manera: CO->( dbSetFilter( {|| Upper( CO->CoFila ) == Upper( cFila ) } ) ) y a continuación ? CO->(DbFilter()) me devuelve la cadena vacía. Necesito controlar por programa cuando tengo un filtro sobre una tabla, porque hay situaciones que necesito ...
by José Luis Sánchez
Thu May 23, 2019 3:16 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Problema con filtros
Replies: 8
Views: 872

Re: lgetbar on road

Now I changed if Empty( cFilter ) if ! Empty( DBFILTER() ) oDbf:setfilter() * DBCLEARFILTER() oBrw:Refresh() endif else if !( DBFILTER() == cFilter ) * SET FILTER TO &cFilter oDbf:setfilter(cFilter) oDbf:gotop() *GO TOP oBrw:Refresh() endif ...
by Silvio.Falconi
Sun Mar 31, 2019 7:13 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: lgetbar on road
Replies: 8
Views: 1169

Re: lgetbar on road

with oldest mode run ok
now with tdatabase make error on setfilter func
this line

if !( DBFILTER() == cFilter )
SET FILTER TO &cFilter
by Silvio.Falconi
Sun Mar 31, 2019 7:05 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: lgetbar on road
Replies: 8
Views: 1169

Re: funciones de FWH y Harbour en un archivo .txt

... DBFilePut(<nFieldPos>,<cSourceFile>,[<Mode>])->lSuccess DBFilter()->cFilter DBFSize()->nFileSize DBGoBottom()->Nil DBGoTo(<nRecordNumber>)->Nil DBGoTop()->Nil DBInfo(<nDefine>,[<xNewSetting>])->xCurrentSetting ...
by carlos vargas
Sat Oct 21, 2017 8:44 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: funciones de FWH y Harbour en un archivo .txt
Replies: 7
Views: 5627

Re: funciones de FWH y Harbour en un archivo .txt

... DBCommitAll DBCopyExtStruct DBCopyStruct DBCreate DBCreateIndex DBDelete DBDrop DBEdit DBEval DBExists DBF DBFieldInfo DBFileGet DBFilePut DBFilter DBFSize DBGoBottom DBGoTo DBGoTop DBInfo DBJoin DBList DBOrderInfo DBPack DBRecall DBRecordInfo DBReindex DBRelation dbRename DBRLock DBRLockList ...
by carlos vargas
Sat Oct 21, 2017 8:43 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: funciones de FWH y Harbour en un archivo .txt
Replies: 7
Views: 5627

Re: Poner filtro y saber si hay otro?

noe aburto wrote:Saludos.

En mi app quiero establecer un filtro, pero mi problema es que desconozco que si ya esta establecido un filtro antes, como restablezco a mi filtro anterior?

Gracias.


? Empty( DbFilter() )
by cnavarro
Sat Jan 14, 2017 5:16 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Poner filtro y saber si hay otro?
Replies: 2
Views: 1418
Next

Return to advanced search