General information
Category:
Coding, syntax and commands
Hi Borislav. Thanks for your reply.
How do you set the slect string in SqlDataSource to come from 2 separate select commands ?
Regsrds,
Gerard
>>Hi Kevin. Thanks for your reply.
>>
>>My 2 joins was just an example. In VFP, I quite frwquently would have more than 3 joins with lots of where conditions, and from experience have found that breaking it up into a no. of joins is
>>1. Easier to follow
>>2. Easir to Debug
>>3. Usually more efficient
>> as you are crating Subsets all the way, and then working from these subsets on the subsequent selects.
>>I also dont want to limit apps to Sql server as most of our clients are currenlty using VFP, and would like the option, with whatever the solution is, to ensure that it works in VFP and SQL.
>>
>>Taking your comments on board, is it not possible to have multiple selects as a source into a SqlDatasource ?
>>
>>Regards,
>>
>>Gerard
>
>Gerard,
>most of the SQL Server queries could be run on VFP 9 w/o any changes (you only need to change the functions you use in them to match VFP syntax). VFP9 supports derived tables in both FROM and JOIN clauses.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only