Hi Kevin.
I'm building many apps, some of which will have VFP files as the backend, others will have SQL Server as the back End, but all using Visual Studio .net 2005.

My original query was of a general nature. In a web form, there is a SqlDatSource (or OLEDBDaraSource for VFP) which you can drop on a form.
One of its properties is a Select String.Usually the select string would go like: Select.... from ...MyTable where .....

My question was, if you have lots of tables with lots of joins,is there a way of having the SelectString made of of multiple select statements as in:
Select * from MyTbale into Cur1....
Select * from Cur1 Join.... Into Cur2
Select * from Cur2 Join.... in to Cur3
and then have Cur3 (i.e.the resulting Cursor, or Table or whatever) as the source of the SqlDataSource.
I know this is very VFP'ish but that's where I am coming from.....
Regards,
Gerard





>ust want to make sure I understand something - you're building a .NET application that must support either VFP or SQL Server as the back-end database?
>
>Kevin