Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View to Select Union
Message
From
24/10/2003 17:24:43
 
 
To
24/10/2003 17:15:10
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
00842327
Message ID:
00842471
Views:
19
>Before going that, I would simply just add another method to return as is.<

OK, well, whatever ... I was under the impression that you already had the data in bits and pieces (mulitple DataSets maybe or multiple Tables and Views, I'm not sure how you're getting it) ... but anyway, my suggestion to use .ImportRow() was because I thought you already had the data and you were just looking for a way to combine it all into one DataSet.

~~Bonnie


>>OK, I think part of the problem is that VFP only gives you a DataSet with one Table. However, you can either pre-define your DataSet with an additional table, or add a Table to your DataSet once you get it from the WS and if I were you, I'd add a Speaker Table so that for each row in your main table (for each meeting), you'll add one to three rows in the new Speaker table.
>
>Yes, that would be in the very last resort. Before going that, I would simply just add another method to return as is. It surprises me a lot that there are many limitations with a DataSet or a view that we cannot do such a SQL. I thought it was SQL compliant.
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform