Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you change the expression in multiple records....
Message
 
To
05/10/2000 16:02:03
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00424294
Message ID:
00425630
Views:
16
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform