xsharp.eu

I start the convertion of a VO program to use ADS

First problem encountered is that in many dbf files I use a function (user defined function) for the expression of the index as

FIELD1 + Func1(FIELD2, FIELD3)

Is it possible to do the same with ADS indexes? Or it is not supported?

I have versions ADS 11.10 and 12.0 to test


Thanks for any idea or suggestion

Benito Fernández

Hi Benito,
the use of your own functions in index expression is not supported on ADS. On ADS, the server maintains the indexes, and since the server cannot know your function, the function cannot be used.
What I have done in such cases (and others, because I was also using parts of memo fields in index expressions - another thing not supported on ADS): I have defined fields that contained the index expression and are written in the Commit() method of the relative DBServer class. And of course there is a maintenance function that rebuilds these fields.
Wolfgang

Thank you very much Wolfgang

I will do as you sugest

Benito