Hi Benn,

SET DATABASE TO ("MyDatabase")
=DBSETPROP("View_Suspence","VIEW","FetchasNeeded",.T.)

MartinJ

>Hi
>
>Under View Designer in Advanced Options it is possible to set the parameter "Fetch remote data as needed".
>
>How can I set this option "FetchasNeeded" = .T. when I create the Remote view by code.
>
>OPEN DATABASE MyDatabase
>CREATE SQL VIEW View_Suspence CONNECTION Oracle AS SELECT * FROM .......