>>>>>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
>>
>>You cannot put the expression like SUBSTR(EXPR,1,7) instead of a field name in REPLACE command.
>ok - I understand....where can I find all of the "objtype" values?
>>
Well, I assume in those documents Cindy pointed you to, also you can just BROWSE your FRX and see what record and it's objectcode is what.
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