| re: SQL Insert question
Hi, still got syntax error, missing operator. "[job_order]='xxx'"
Rgds,
Daniel
"KeejToe" <bitplace@hotmail.com> wrote in message news:<cigHb.99028$Tf7.4397168@phobos.telenet-ops.be>...[color=blue]
> The right syntax should be something like:
> INSERT INTO Custorder (job_order) VALUES (123)
> or, in case of alfanumeric values:
> INSERT INTO Custorder (job_order) VALUES ('abc')
>
> so your code should be something like:
>
> sqlstr = "INSERT INTO Custorder (job_order) VALUES (" & Jobno & ");"
> or
> sqlstr = "INSERT INTO Custorder (job_order) VALUES ('" & Jobno & "');"
>
> hope this helps....
>
>
>
> "Daniel Tan" <danieltan@time.net.my> wrote in message
> news:6a6a9040.0312270548.588ebe9@posting.google.co m...[color=green]
> > I got a syntax error in SQL insert into statement , hope someone can
> > help me .Thanks.
> >
> > job_search = "[job_order]='" & Me.Jobno & "' "
> > sqlstr = "INSERT INTO Custorder (job_order) " & _
> > "values " & (job_search) & ";"
> >
> > Regards,
> > Daniel[/color][/color]
| 
