>>It goes into EXPR field in .FRX. Yes, you need to know OBJTYPE and for the report field
>>OBJTYPE = 8
>Hi Nick:
>ok - it works, but I do not want to replace the whole expression.
>my expressoion is MYTABLE.MYFLDNAME. I just want to replace MYTABLE with NEWTABLE. I tried the following...REPLACE ALL substr(EXPR,1,7) WITH "NEWTABLE" FOR objtype = 8...it does not like the substr(EXPR,1,8)...any ideas?
REPLACE ALL EXPR WITH STRTRAN(EXPR, "MYTABLE", "NEWTABLE") FOR objtype = 8
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