>>>>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?
>