Description:
"MySqlCommandBuilder doesn't support multi-table statements"
Will this be changed in future releases?
How to repeat:
m_ProductsAdapter = new MySqlDataAdapter("select ptc.products_id, ptc.categories_id, p.manufacturers_id, p.products_tax_class_id, p.products_status, p.products_model, p.products_quantity, p.products_price, p.products_image, p.products_weight, p.products_date_available, pd.products_name, pd.products_description, pd.products_url, pd.language_id, pd.products_viewed from products_to_categories ptc, products p, products_description pd where ptc.products_id = p.products_id and pd.products_id = p.products_id", m_Connection); // Something like this
MySqlCommandBuilder m_ProductsBuilder = new MySqlCommandBuilder(m_ProductsAdapter); // followed by this
MessageBox.Show("Update Command: " + m_ProductsBuilder.GetUpdateCommand().ToString()); // and something like this
Suggested fix:
Well, implement this... ;)
Description: "MySqlCommandBuilder doesn't support multi-table statements" Will this be changed in future releases? How to repeat: m_ProductsAdapter = new MySqlDataAdapter("select ptc.products_id, ptc.categories_id, p.manufacturers_id, p.products_tax_class_id, p.products_status, p.products_model, p.products_quantity, p.products_price, p.products_image, p.products_weight, p.products_date_available, pd.products_name, pd.products_description, pd.products_url, pd.language_id, pd.products_viewed from products_to_categories ptc, products p, products_description pd where ptc.products_id = p.products_id and pd.products_id = p.products_id", m_Connection); // Something like this MySqlCommandBuilder m_ProductsBuilder = new MySqlCommandBuilder(m_ProductsAdapter); // followed by this MessageBox.Show("Update Command: " + m_ProductsBuilder.GetUpdateCommand().ToString()); // and something like this Suggested fix: Well, implement this... ;)