🚀 go-pugleaf

Hi all,

Since last time this group was of great help, I'll try my luck again.
I'm using ODBC.PL to connect to Access 7.0. I have no problems sending
INSERTand SELECT SQL commands, but the update appears not to give the
proper result. This is the command I'm sending:

UPDATE ServiceRecords 
SET 
QueryID = '144', CustomerID='123456789012345',
EmployeeID='YossiK', ServiceDate = '24/10/96', ServiceTime =
'ServiceTime', ProductVersion = '2.0',
ServiceRecords.ProductName='Dagesh', ServiceRecords.Status='ON',
ServiceRecords.AnswerDescription='goodbye',
ServiceRecords.ProblemDescription='hello again?',
ServiceRecords.Version='2.0' 
WHERE 
QueryID='144';  

And the error message I'm receiving is:

[Microsoft][ODBC Microsoft Access 7.0 Driver] Too few parameters.
Expected 2 

The only other relevent thing is that QueryID is an Access generated
field that increments by 1 every time a new entry is entered.

Any advice will be appreciated. If possible please use mail, the
newsgroup server isn't that good.

Oh, and while on the subject, does anyone know what escape sequence I
should use to send a single-quote to a text field? I'm trying to type
'Can't' but the quotes are confusing Access.

Thanks,

Yossi