Hi Bonnie.
I have never used Views (In C#.Sql DServer) so I just need to invest a bit of time in studying your suggested solution.
Thanks again for your help.
Regards,
Gerard



>Hi Gerard,
>
>>I think I will need to put more thought into this
>
>Does this mean that my DefaultView.ToTable() suggestion isn't going to work for you? My example just showed a simple RowFilter, but it could be much more complex than what I showed.
>
>~~Bonnie
>
>
>
>
>
>>Thanks for your replies
>>
>>I was trying to do this in code, with a VFP mindset, rather than having to go into the database and set up views.
>>As well as a specific requirement, this is a lso a general question re th correct method in C# to do the
>> sort of thing I have always being doin g in VFP. i.e Selecting out Cursors from Cursors etc.
>>
>>I think I will need to put more though into this
>>Regards,
>>Gerard
>>
>>
>>
>>>Hi Gerard,
>>>Could you possibly accomplish what you are after by setting up views in your database and building business objects for the views? The other possibility might be to reference other business objects from within the primary business object.
>>>Linda
>>>
>>>>Hi.
>>>>Is there a way in .net (C#) to select to a temporary Cursor and then use this as the source
>>>> of another select e.g.
>>>>
>>>>Select * ,.....from Tablea Into Table Temp1
>>>>Select * from Temp1 into Table Temp2
>>>>Select * from Temp2 into table Temp3...etc
>>>>
>>>>The above selects are just examples
>>>>Each select is more complicated , with numerous fields and some
>>>> of the selects are done for grouping purposes.
>>>>
>>>>Any help appreciated.
>>>>regards,
>>>>Gerard