>Hi,
>
>This may sound somehow very naive, but it's a real problem I'm facing.
>
>I must develop an app using SQL Server as the backend, and can't use any VFP tables (.dbfs, .dbcs etc).
>
>The question is: what folks developing with VFP or even other tools (like VB) use to access SQL Server, retrive data, populate a combobox, a listbox, show data in a grid etc, for example?
>
>VFP works easily with that, because its controls can be bound to VFP tables and cursors. But how can I use those controls when data comes from SQL Server? Sometimes I may use cursors, but other times the source of data has thousands (or milions) of records and may not be appropriate to select them into a cursor and show in a control.
>
>So far I've being using SQL passthru for my apps when needed to access SQL Server, Oracle etc, but always brought selected data into VFP cursors and used them.
>
>My problem is that I don't know how to build such an application, and even know how to start! I have the "Client/Server Applications with Visual FoxPro and SQL Server" in my hands, but didn't find the answers to my questions. Of course it's my fault and I couldn't absorb correctly the information contained therein.
>
>So, what's the way to go? CursorAdapter, ADO, SQL passthru...? Them how?
>
>This type of application (SQL Server with no VFP tables) is seeming to be my future, as clients are asking me (forcing me...) more and more frequently to do so.
>
>Any comments about this subject will be highly appreciated.
>
>Thanks,
>
>Fernando

Adding my .02 cents. Don't completely throw away RV.
Cetin