>Hi All,
>
>I have a large table on Oracle back-end which I want to print using VFP's SQL Pass-through. What is the best way to achieve this among following options?
>
>1. collect all the data in local cursor and print
>2. collect some data; print that set; collect next and so on
>3. Keep a VFP database and create remote view and use that view in report designer
>
>Or are there any other better approach?
I see no problem using SPT to create a cursor with all the data you need for the report. The data is not for editing so a remote veiw is not necessary. If you use SPT, you can present a setup form to the user to enter some selection parameters. Then build your SQL and send it to Oracle.
Mark McCasland
Midlothian, TX USA