Hi!
This is property of view, not connection.
You can change view properties in database programmatically by using DBSETPROP() function:
SET DATABASE TO MyDatabase
DBSETPROP("MyView","VIEW","FetchAsNeeded",.F.)
The same for properties for connection. List of all properties you can find in the help for DBGetProp() function.
HTH.
>Thanks a lot for your answer,
>
>My connections are programmatically created. How can set "Fetch Remote data as needed" programmatically
>
>Thanks in advance
>Petros
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.