> show an example of some other language function that returns three resultsets.
There is precedent for this. In SQL Server, the sp_help command returns multiple resultsets. I can see returning multiple resultsets if the developer is asking SELECT * FROM OrderDetail You might say "Well, as long as you're asking for OrderDetail, I can give you all the associated OrderHeader data in a 2nd resultset and the associated customer data in a 3rd." My solution has been to SELECT * FROM OrderDetailView And in that view include all the OrderHeader and Cust data, thereby only 1 resultset. SQL Server commands: DROP TABLE dbo.OrderDetail GO CREATE TABLE dbo.OrderDetail( OrderDetailID Integer Identity Primary Key NONCLUSTERED, OrderHeaderID Integer) GO DROP VIEW dbo.OrderDetailView GO CREATE View dbo.OrderDetailView AS SELECT TOP 100 PERCENT CustNo, InvoiceDate, -- these are in the OrderHeader table CustName, -- this is in the Cust table OrderDetail.* FROM OrderDetail INNER JOIN OrderHeader ON OrderDetail.OrderHeaderID = OrderHeader.OrderHeaderID INNER JOIN Cust ON OrderHeader.CustID = Cust.CustID ORDER BY OrderDetailID GO SELECT * FROM OrderDetailView ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
