>UPDATE PWS_Assessment SET > PWS_Phone = ?pcSysPhone, > Response_Testing_pH = ?pcPh, > Response_Testing_FCl = ?pcFCl, > Response_Testing_TCl = ?pcTCl, > Response_Testing_Alk = ?pcAlk, > Response_Testing_Trb = ?pcTrb, > Additional_Notes = ?pcComments >WHERE PWS_Number = ?pcPWSID > AND Assessment_Date = ?pdStatusDate>All parameters are private variables. Here are the data types in the Access table:
> PWS_Phone (Text) > Response_Testing_pH (Yes/No) > Response_Testing_FCl (Yes/No) > Response_Testing_TCl (Yes/No) > Response_Testing_Alk (Yes/No) > Response_Testing_Trb (Yes/No) > Additional_Notes (Memo)>The values that I passing for the Yes/No fields are either Y or N. Here is my error message, that makes no sense to me:
>1526 >Connectivity error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 13. >[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 13. >07001 >-3010 >1 >.NULL.>Why is it expection 13 parameters?