Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you change the expression in multiple records....
Message
From
05/10/2000 17:16:09
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00424294
Message ID:
00425698
Views:
9
>>>>>>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,
Have you ever browsed the FRX...Do you mean the FRT file....FRT makes more sense. I tried to edit both files and saves my changes in NOTEPAD.. this
destroyed the file...
Robert Keith
Independent Developer
San Antonio, Texas
E-mail address:
rebelrob1@yahoo.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform