Re: Syntax error in INSERT

2002-12-03 Thread Achille M. Luongo
Hi, I suppose you have to use a NULL value: INSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES (2113,NULL,NULL)I [EMAIL PROTECTED] wrote: > > Hi, > I have the following statement causing an error near "," > sNewCallBackSQL = "INSERT INTO CallBacks (LearnerID,CallDate,CallTime) V

Syntax error in INSERT

2002-12-03 Thread Sam4Software
Hi, I have the following statement causing an error near "," sNewCallBackSQL = "INSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES (" & ExLearnerID & " , " & sCallDate & " , " & sCallTime & ")" The executed statement is: INSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES (211