FiveTech Software tech support forums

i have to use it for every "Property" to CATCH Error

Yes.
Better we make a function with TRY/CATCH

under Xbase++ "Property" aof COM/ActiveX are same as Member VAR (DATA)

That's nice. Good to know.
What about HMG?
ps: I am asking because I never used them

hi, thx for Answer under Xbase++ "Property" aof COM/ActiveX are same as Member VAR (DATA) Eigenschaft (engl.: Property) Instanzvariable einer COM/ActiveX-Komponente, entspricht einer Membervariablen (IVar) eines Xbase++-Objektes. thats why ...

... index expressions. BTW- you could use your other indexes to create even more complicated and interesting filters. Finally; you could use the AOF expression even if an index does not exist, but that would make the browse very slow. Hope that helps; Reinaldo.

Carlos,

En la creación del índice, ¿el tag debe ser obligatoriamente igual al nombre del campo para que funcione el AOF?.

Gracias.

Un par de dudas Carlos:

En la creación del índice, ¿el tag debe ser obligatoriamente igual al nombre del campo para que funcione el AOF?.

¿Funciona el AOF con índices temporales TO TEMP TEMPORARY?.

Mil gracias.

... ya que usa los indices para encontrar los registros a incluir en el filtro. (esto en Foxpro por ejemplo se llama tecnologia Rushmore, en ads es AOF) si usas el rdd ADS podras hacer uso de esta tecnologia. basicamente funciona de la siguiente manera. si usas un filtro como este select "prestamos" ...

Dear Mr. Roman,

I'm using ALS too over network.. I haven't experienced such problem.. But take a look at AOF's if you have one.. 'ADS_RESPECTFILTERS' usually the culprit of slowing browses..

... the free local ADS version is (very) slow for larger tables, specially regarding FTS :( So for LAN-users with a running ADS - not ALS -, FTS with AOF is the best. For local users, it's better to buy an ADS licence - running a local ADS - or use 'DBFCDX' with WildMatch. Using WildMatch with ADS ...

Have you looked at FTS indexes in ADS? The free local ADS version works perfectly with dbf/cdx file pairs. These indexes can be used on AOF's() and are very very fast.


Reinaldo.

If the filter can be resolved with the indexes using Comix's Clipmore, Six's Mach Six, or Advantage Optimized Filters (AOF) then yes it is very fast. The important part is the level of optimization. If the filter can be completely optimized using the indexes, if Comix's rlOptLevel() ...

... Estuve leyendo, también en el help, que la función "CONTAINS" se puede usar también en el query, así que en lugar de aplicar un filtro AOF, lo uso así (que en forma indirecta aplica un filtro, pero en el query es más rápido) Saludos Rolando :D

Me rectifico respecto de SET( _SET_OPTIMIZE, .T. ) Para ADS: Advantage Optimized Filters (AOFs) provide high performance filter optimization for Advantage applications. AOFs speed filter processing by using index keys instead of table records. If a specified field has ...

Lorenzo:

En ADS esta el comando AOF (que es un filtro optimizado), quizas te sirva tambien, y ademas mejore tus tiempos.
No se como se usa pero seguramente en el foro te daran la respuesta.

Saludos

Ruben Fernandez

... immediate. But if you need to work with a result set of more than a few thousands, then I suppose it would be better to set an optimized filter (AOF -Advantage optimized filter) based on an index (CDX or ADI work better than NTXs). Here is a link that explains how to use an AOF: http://devzone.advantagedatabase.com/dz/WebHelp/Advantage9.1/advantage_concepts/advantage_functionality/advantage_optimized_filters.htm ...

... me: I have 4 xbrowses, and the display of three xbrowses will depend on what record number is pointing to by the first XBrowse. I tried using AdsAOF to set the filter on the 3 xbrowses and refresh them: REDEFINE XBROWSE oMOXBrow OF oBrowDlg ID 1001 FONT oBrowFont UPDATE; // browse for transact ...