FiveTech Software tech support forums

... operator ( and not or ) to insert the second row of expression into xbrowse using only an array then we can save all on a inifile and call it with dbsetfilter function we can save for that dbf many expressions we want , we can use it also for the report just an idea .....

Otto;

On the subject of RDP, I'm using a product called WinFlector. It is written with xharbour. My experience as a whole has been positive but I never use it for more than 3 users.

What are you using? Can you compare it to Winflector?

Thank you,


Reinaldo.

Reinaldo, you are right in every point. What I want to say is that RDP offers now possibilities we didn’t had before. And we should evaluate if we really need a client/server solution. Till one understands and feels comfortable with “client server“ programming he has to learn much. Then there are al...

We are doing queries on dbf/cdx files without a dictionary. The only thing to notice is that any condition like "Where Name = 'Smith'" needs an index on Name without a condition Alex Alex; True, you may execute SQL without a DD connection and still take advantage of indexes, but that's on...

Hello Reinaldo, I read your post and then I made a test with pure DBF. This is what I did. Database with 124 fields 280.000 records 500 MB. I simulate your Select statement with a temporary index. In the screen shot you see the technical data of my RDP – Server. I get the result within a 1 sec. Best...

We are doing queries on dbf/cdx files without a dictionary. The only thing to notice is that any condition like "Where Name = 'Smith'" needs an index on Name without a condition The process is basically: #include "ads.ch"Adsconnect("c:\pathtodata")select 0if ads...

Hi. You must connect to an ADS data dictionary. The SQL engine is smart enough to know which indexes or combination of indexes based on the metadata on the DD should be used to produce an optimized result. No need to open tables or specify index tags. For example, provided that you have an index bas...

Dear All, I use ADS but never use with SQL Statement. How does it different speed between DbSetFilter and ADS with SQL Statement? May I have an example to use SQL Statement to open file with ADS? Do I need to use and Index file for SQL Statement? If so, how can I specific ...

... "fecha>='"+dtos(dDesde)+"' .and. fecha<='"+dtos(dHasta)+"'" bfiltro := "{||"+cfiltro+"}" dbsetfilter(&bfiltro,cfiltro) saludos paco

No veo necesario declarar el array como private, todo depende de la situación. En el ejemplo que pone el compañero, me gusta más la solución de la expresión, porque aunque requiera elaborar la expresión como string, 1)me permitiría ponerla y quitarla, 2)es más rápida seguro, 3)funcionaría con ADS (p...

Estimado Carlos, Es cierto que el Eval() para filtrar tiene un coste... pero da unas posibilidades que la creacion de la condicion literal no da: se pueden hacer complicadisimas condiciones sin tener que estar construyendo la condicion literal: imaginate si en la condicion tienes que incluir que un ...

... aFiltros[1]    FOR i:= 2 TO Len(aFiltros)        cFiltro+= '.AND.'+aFiltros[i]    NEXT    (carticulo)->(DbSetFilter( &('{||'+cfiltro+'}'), cfiltro ) )    (carticulo)->(dbgotop())return nil  con esto lo ...

ok. lo he hecho con dbsetfilter() en lugar de set filter pero funciona de miedo. Gracias.

Amigo Garbi, ¿ Qué quieres, dos anidamientos, doscientos o dos mil ? Los que quieras :wink: Mira el ejemplo: FUNCTION Sample()Local bFil1:= {|| .t. },;         bFil2:= {|| .t.},;         bFil3:= {|| .t.},;  ...

... ->( dbClearFilter(NIL) )    cfiltro:=""    IF Var(1) > 1      * (carticulo)->(DbSetFilter(;      *                  { || (carticulo)->ancho=val(tancho[Var(1)]) },;      *       ...