FiveTech Software tech support forums

DbSetFilter( <bFilter>, [<cFilter>] ) --> NIL Arguments <bFilter> A code block containing the filter expression. The expression must yield a logical value. <cFilter> The filter expression in form ...

Maybe trying INDEX ON giorno TAG ASS1 or AS->( OrdScope(0, { || dtoc(date()) }))

I made SELECT AS AS->(DbSetOrder(1)) AS->(DbSetFilter( {|| AS->Giorno=date() }, )) AS->(DbGoTop()) and I wish show only the record have as->giorno = date() it run ok but sometimes it show also one record with another date http://www.eoeo.it/wp-content/uploads/2015/10/nn.jpg ...

... Another solution ( maybe better ), using one browser and filtering the 4 sections on button-action. ACTION ( ("BACKUP")->( DBSETFILTER( NIL ) ), ; ("BACKUP")->( DBSETFILTER( {|| ("BACKUP")->(RECNO()) > 24 .and. ("BACKUP")->(RECNO()) ...

... oApp():oTab,oApp():oTab:nOption) ) Function Cufiltrar (oGrid,oTab,n,nOrder) ?alltrim(oApp():oTab:aPrompts[n] ) do case case nOrder= 1 CU->(DbSetFilter( alltrim(Left(CU->First,1))==alltrim(oApp():oTab:aPrompts[n] ) )) case nOrder= 2 CU->(DbSetFilter( alltrim(Left(CU->Last,1))==alltrim(oApp():oTab:aPrompts[n] ...

... ) it run ok bu tI mean to show sample only that customer init for "A" or "B" ... I hope you understand me I tried with CU->(DbSetFilter( alltrim(Left(CU->First,1))==alltrim(oApp():oTab:aPrompts[oApp():oTab:nOption] ) )),; oApp():oGrid:refresh(),; but it not run

... de artículo y desde otro terminal, se busca "cola" y los resultados se mezclan en ambos equipos. En el código fuente evito hacer un dbsetfilter, porque son muy lentos, y hago un indice temporary, que son superrapidos, tal cual así: index on descrip tag tempor to tempor additive for ...

... Statement (ADORDD) for more easy to read/write db. I try to "USE" with cQuery but it is not successful and "USE" and DbSetFilter() and SET RELATION TO is taking more time, because the Main data has 3300 records but Child data has 33x,xxx records. Regards, Dutch

1) Function and Command to open/read/write, relation, dbsetfilter(), ordsetfocus(), dbseek() is working well. 2) open record with relation is quite slow. I think the point is JOIN table is the key. Because 'CCRGST' table (guest details) no need to open ...

EXPORTS HB_FUN_AADD @1 HB_FUN_ABS @2 HB_FUN_ACCELERATO @3 HB_FUN_ACCELERATOR @4 HB_FUN_ACHOICE @5 HB_FUN_ACLONE @6 HB_FUN_ACOPY @7 HB_FUN_ADEL @8 HB_FUN_ADIR @9 HB_FUN_AEVAL @10 HB_FUN_AFIELDS @11 HB_FUN_AFILL @12 HB_FUN_AINS @13 HB_FUN_ALERT @14 HB_FUN_ALIAS @15 HB_FUN_ALLTRIM @16 HB_FUN_ALTD @17 H...

... from DBF 1 cNName := ("KUNDE")->NAME1 cVName := ("KUNDE")->NAME // change to dBF 2 DBSELECTAREA( cMonat ) (cMonat)->( DBSETFILTER( NIL ) ) SET FILTER TO (cMonat)->KUNDE = cNName .and. (cMonat)->NAME1 = cVName DBGOTOP() // move to browser 2 oBrw2:SetFocus() oBrw2:Refresh() ...

... aware that using filters we have to ensure that besides the filter block there is a filter literal expression. In the app they use it like this : dbsetfilter(&("{ || " + cfilter + "}"), ; cfilter ) Please check .ppo file if translates to that. Please check filter2sql and ...

... function ListFilter1( aList, cData, oSelf ) local cAlias := oSelf:uDataSource SELECT AT AT->(DbSetOrder(2)) AT->(DbGoTop()) AT->( DBSETFILTER( NIL ) ) AT->( DBSETFILTER( {|| UPPER(ACACTIVIDA ) >= UPPER( ALLTRIM( cData ) ) .AND. UPPER( ACACTIVIDA ) <= UPPER( ALLTRIM( cData ...

... order and the table has error because I see a data instead of the right why ? it seems wrong this commands ...or it not run ok OR->(DbSetFilter( {|| OR->PROF=nDOCENTE }, ))

Hola.

Falta probarlo en red, aunque precisamente ese era el problema, que estaba usando dbSetFilter() y se ralentizaba a veces bastante. Espero que funcione bien y mejor; mantendré informado en cuanto lo haya instalado en el usuario.