|
Click to See Complete Forum and Search --> : Updating database using CommandBuilder erezrave February 18th, 2003, 03:22 PM How do I update a database from a dataset with SQL "JOIN" using CommandBuilder... The problem appears when I try to update from a dataset made from SQL with "JOIN"... :confused: Iouri February 18th, 2003, 03:27 PM Check how many columns you have in the table. The CommandBuilder is designed for "normalized" tables less than 101 columns. Maybe you JOIN gives you more DdH February 19th, 2003, 01:41 AM You can't use the CommandBuilder on SQL statements that contain a JOIN, only on single table SQL statements. A quote from the MSDN library: "Automatically generates single-table commands used to reconcile changes made to a DataSet with the associated SQL Server database." erezrave February 19th, 2003, 04:30 AM OK... Thank you. :mad: codeguru.com
Copyright Internet.com Inc., All Rights Reserved. |
|