Thread: Syntax error INSERT INTO
View Single Post
  #3 (permalink)  
Old January 31st, 2006, 07:50 AM
ITladybug ITladybug is offline
Registered User
  
Join Date: Dec 2005
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Quote:
quote:Originally posted by nalla


Hi ITladybug,
Check the data type of job# if it's number change the string as

"insert into MasterJobT(job#,jobstartdate,projectedcompletionda te) values (" & strJobNo & ",#01/10/2002#,#01/10/2002#)"

If still you are getting an error please let us know the error number and the description


nalaka hewage

Thanks for the reply. Job# is of type string. I've another question. I've column of type currency. I've declare variable with type decimal to store currency value. Am I correct ? PLease help me to solve this 'INSERT INTO' syntax error.

Thanks

Reply With Quote