When I call the following:
OleDbDataAdapter1.Update(DsGridDeliverables1)
I get a Syntax error in the Update query.
Here's the update query:
"UPDATE WP WP_P_I = ?, P3 = ?, [DDesc] = ?, [Date] = ? WHERE ([DNumber] = ?) AND ([Date] = ? OR ? IS NULL AND [Date] IS NULL) AND (P3 = ? OR ? IS NULL AND P3 IS NULL) AND (WP_P_I = ? OR ? IS NULL AND WP_P_I IS NULL)"
I know the field shouldn't have used the reserve key word "DATE", but this application was created way before I was here.
Thanks!
OleDbDataAdapter1.Update(DsGridDeliverables1)
I get a Syntax error in the Update query.
Here's the update query:
"UPDATE WP WP_P_I = ?, P3 = ?, [DDesc] = ?, [Date] = ? WHERE ([DNumber] = ?) AND ([Date] = ? OR ? IS NULL AND [Date] IS NULL) AND (P3 = ? OR ? IS NULL AND P3 IS NULL) AND (WP_P_I = ? OR ? IS NULL AND WP_P_I IS NULL)"
I know the field shouldn't have used the reserve key word "DATE", but this application was created way before I was here.
Thanks!