error on row update: index -1 for this Parameters
Posted: Wed 30 Aug 2006 17:24
I have this error when I use the Update method of the TableAdapter generated for one of my table. Using the bindingNavigator, I click on the disk to save changes to the current row and this error happens all the time.
I use :
Visual Studio 2005 Team edition
CoreLabs component 3.50.12
MySQL 5.0.22 on remote computer
Here is the update query used be the DataAdapter in the TableAdapter:
"UPDATE `Production_Data`.`Inventaire`
SET `# produit` = :__produit,
`Groupe` = :Groupe,
`Description produit` = :Description_produit,
`No de pièce fournisseur` = :No_de_pièce_fournisseur,
`Fournisseur` = :Fournisseur,
`Fabricant` = :Fabricant,
`Location` = :Location,
`Qté stock` = :Qté_stock,
`Qté min` = :Qté_min,
`Qté max` = :Qté_max,
`Qté commande` = :Qté_commande,
`Unité mesure` = :Unité_mesure,
`Délai livraison` = élai_livraison,
`Prix` = :Prix,
`No charge adm` = :No_charge_adm,
`No PO relache` = :No_PO_relache,
`Géré` = :Géré,
`Notes` = :Notes,
`Faire commande` = :Faire_commande,
`Actif` = :Actif
WHERE ((`# produit` = :Original___produit))"
this update query has been auto-generated (along with the 21 parameters). I have dragged the table from the Server Explorer in a dataset generated by the Dataset Wizard.
Does somebody have an idea of what might be the problem? If you need more info, don't hesitate to ask.
Thanks for your help,
Jean
I use :
Visual Studio 2005 Team edition
CoreLabs component 3.50.12
MySQL 5.0.22 on remote computer
Here is the update query used be the DataAdapter in the TableAdapter:
"UPDATE `Production_Data`.`Inventaire`
SET `# produit` = :__produit,
`Groupe` = :Groupe,
`Description produit` = :Description_produit,
`No de pièce fournisseur` = :No_de_pièce_fournisseur,
`Fournisseur` = :Fournisseur,
`Fabricant` = :Fabricant,
`Location` = :Location,
`Qté stock` = :Qté_stock,
`Qté min` = :Qté_min,
`Qté max` = :Qté_max,
`Qté commande` = :Qté_commande,
`Unité mesure` = :Unité_mesure,
`Délai livraison` = élai_livraison,
`Prix` = :Prix,
`No charge adm` = :No_charge_adm,
`No PO relache` = :No_PO_relache,
`Géré` = :Géré,
`Notes` = :Notes,
`Faire commande` = :Faire_commande,
`Actif` = :Actif
WHERE ((`# produit` = :Original___produit))"
this update query has been auto-generated (along with the 21 parameters). I have dragged the table from the Server Explorer in a dataset generated by the Dataset Wizard.
Does somebody have an idea of what might be the problem? If you need more info, don't hesitate to ask.
Thanks for your help,
Jean