Can anyone provide me some examples of using a Heirchal recordset such as Customers - Orders - Order Details in the Northwind database without
employing the use of the Shape construct. Any help would be much
appreciated. Thanks
Re: Update Multiple Tables in Database using DataRelations ... To help me out here, are you isnerting, updating and delting rows? ... > DataTable and Order Details DataTable.... >> the SqlDataAdapter.Update method for each of the DataTables.... >> delete the Customers... (microsoft.public.dotnet.framework.adonet)
Re: Update Multiple Tables in Database using DataRelations ... DataTable and Order Details DataTable.... > delete the Customers... > DataTables using the GetChanges method or the Selet method ... ... >> How do I update my database so that when a Customer is deleted, ... (microsoft.public.dotnet.framework.adonet)
Re: INSERT INTO, UPDATE, ADD ... From looking at the help file, I think you have it right; SQL ALTER TABLE does not have provision for a default value. ... Assuming all the phone numbers are the same format, i.e. with the area code.... INSERT INTO [Order Details]... I had to select Customers with no orders. ... (microsoft.public.access.tablesdbdesign)
RE: INSERT INTO, UPDATE, ADD ... INSERT INTO [Order Details]... The primary key of the table is OrderID + ProductID. ... I need to delete these particular customers....separate tables AND with this Totals over>$10,000. ... (microsoft.public.access.tablesdbdesign)
Re: INSERT INTO, UPDATE, ADD ... I don't know if there's a way to combine them, so I did 2 separate ones -- the 1st one added, but the 2nd didn't. ... INSERT INTO [Order Details]... FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID ... I need to delete these particular customers.... (microsoft.public.access.tablesdbdesign)
