>>use SomeView >>index on bintoc(dossier) tag xx >>index on name tag name >>?juststem(dbf())==juststem(cdx(1)) && TRUE >>=requery() >>?juststem(dbf())==juststem(cdx(1)) && FALSE >>.... >>>I was over this point since the start of this thread.
>IF CURSORGETPROP('SourceType')=1; > AND !EMPTY(CDX(1)); > AND !JUSTSTEM(CDX(1))==JUSTSTEM(DBF()) THEN >
> INDEX ON ; > &lc__SortExpr ; > TAG (.gcCurrentTag) OF (CDX(1)) ADDITIVE >
>ELSE &&CURSORGETPROP('SourceType')=1 > INDEX ON ; > &lc__SortExpr ; > TAG (.gcCurrentTag) >ENDIF &&CURSORGETPROP('SourceType')=1 >>
AND !JUSTSTEM(CDX(1))==JUSTSTEM(DBF())I do not think you do in this construction, ie whenever there is a cdx(1) you keep adding to it, since we have seen that (1) requery changes the dbf() and (2) we can do a begin transaction after a requery without any problems
IF CURSORGETPROP('SourceType')=1; AND !EMPTY(CDX(1)); THEN
INDEX ON ; &lc__SortExpr ; TAG (.gcCurrentTag) OF (CDX(1)) ADDITIVE
ELSE &&CURSORGETPROP('SourceType')=1 INDEX ON ; &lc__SortExpr ; TAG (.gcCurrentTag) ENDIF &&CURSORGETPROP('SourceType')=1All in all, you are the one that solved it