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