Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Write to expr memo in frx w/alines
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00453960
Message ID:
00454390
Views:
21
>I need to change two fields in the expr field of an frx, but leave the rest. I'm doing this by scattering the memo and using an alines command. Then I loop through the array and change what I need. What I don't know how to do is write the array back to the memo.
>
>Can anyone help me with the syntax?
Why not do the replace in situ?
Lets say your Frx expr field contains
Alias = "system"
Database = ..\data\acc_recv.dbc
CursorSource = "system"
Name = "Cursor1"
You could update both instances of the word system by doing the following:
UPDATE MyFrx ;
	SET Expr = STRTRAN( Expr, "system", cNewValue ) ;
	WHERE ObjType = 26
Note that it will probably be a good idea to do the reverse STRTRAN() again when you have finished using the Frx in its modified state, otherwise your system will either have to programatically determine the value to StrTran() or carry it forward between runs. Also note that StrTran() is case sensitive.
censored.
Previous
Reply
Map
View

Click here to load this message in the networking platform