For example something like
EVAL(IIF(this.recordsourcetype = 4, "'" + SUBSTR(this.recordsource, RAT(" ", this.recordsource) + 1) + "'", this.recordsource))
goes instead
this.recordsource...
:)
(assuming that "...INTO CURSOR ZZZ" is at the end of SELECT statement and probably nobody uses RecordSourceTypes 2 and 3 anyway :)
>Hi, Nick!
>
> What if RecordSource is SELECT - SQL statement? :)))
>
>>Or, IIF(RECNO(this.RecordSource) = grno... so you are not hardcoding the alias.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison