Thanks Sergey for your response.
But I have to do this at designtime.
How does one change the ViewSQL in View Designer or ViewEdit by Steve. Steves ViewEdit works by allowing me to change the local view SQL but is not able to update the remote view SQL. Why?
>Because it's read only. See help for DBGETPROP() function.
>
>>Hi all
>>
>>I just tried the following command:
>>
DBSetProp(lcViewName, 'view', 'SQL',lcSQL)
>>
>>where lcSQL is the modified view SQL. I got the message that the property is read-only.
>>
>>Why is this so?
>>Also the view I am trying to update is a remote view.
>>
>>Please advise.