Question about ADS/ALS query size limits

[Randy]

Hi all,

Can anyone help me with this question?

BACKGROUND:

ADS (and ALS) are limited to a max filter query string length of 32K.
HOWEVER, it seems that it is actually limited to a max of 32K PER
SEGMENT of the query string. For example...

"FIELD_A $ '<A 32K STRING HERE>' .OR. FIELD_B $ '<A 32K STRING HERE>'"

While the overall length of this is about 64K, it still seems to work.
That is, AdsIsExprValid() returns TRUE and AdsGetRecordCount() returns
the correct number of filtered records (it returns all records when the
filter is not handled by ADS so this indicates that ADS is managing the
filter properly).

The only thing that seems NOT to work is AdsGetAof() which truncates the
query string - HOWEVER, if you use DbSetFilter() to set the filter
(which uses AdsSetAof() internally in Harbour) then DbFilter() can be
used to get the entire query string.

QUESTION:

Is it safe to rely on this undocumented behavior where the query string
can be longer than 32K as long as each query "segment" is not more than 32K?

Thank you!

Randy.

[antonio....@gmail.com]

Randy,

https://deepwiki.com/search/background-ads-and-als-are-lim_a9a1bdd5-25da-4588-9a86-0cc4a63beb15?mode=fast

best regards