Syntax error on Update for OleDBDataAdapter

bubberz

New member
Joined
Apr 15, 2005
Messages
3
Programming Experience
3-5
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!
 
Top Bottom