SQL Syntax Error

[Frank Py]

Having some problems with my SQL statement syntax:

Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression
'MealsExCode=0000104Amount=23.56'.

Can anyone tell me what I might be doing wrong. Help apprecaited.
Thanks:

SQLstmt = "UPDATE Expense SET "
SQLStmt = SQLstmt & "ExDate='" & form_ExDate & "',"
SQLstmt = SQLstmt & "Expense=" & form_Expense
SQLstmt = SQLstmt & "ExCode=" & form_ExCode
SQLstmt = SQLstmt & "Amount=" & form_Amount
SQLStmt = SQLStmt & " WHERE ExpenseID=" & form_id

Set rstSimple = cnnSimple.Execute(SQLStmt)

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Chris Hohmann]

"Frank Py" <fpy@proactnet.com> wrote in message
news:e2ixqw8RDHA.1720@TK2MSFTNGP10.phx.gbl...

> Having some problems with my SQL statement syntax:
>
> Microsoft JET Database Engine (0x80040E14)
> Syntax error (missing operator) in query expression
> 'MealsExCode=0000104Amount=23.56'.
>
> Can anyone tell me what I might be doing wrong. Help apprecaited.
> Thanks:
>
> SQLstmt = "UPDATE Expense SET "
> SQLStmt = SQLstmt & "ExDate='" & form_ExDate & "',"
> SQLstmt = SQLstmt & "Expense=" & form_Expense
> SQLstmt = SQLstmt & "ExCode=" & form_ExCode
> SQLstmt = SQLstmt & "Amount=" & form_Amount
> SQLStmt = SQLStmt & " WHERE ExpenseID=" & form_id
>
> Set rstSimple = cnnSimple.Execute(SQLStmt)
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

You're missing the comma between your field assignment clauses. You did
it for the first one but not the others. In the future, when you
encounter an error, you should "Response.Write SQLStmt", copy the
outputted SQL statement and paste into the Access Query Builder/SQL
Server Query Analyzer depending on your database platform. This will
give you more details on the errors the SQL parser is encountering.
Also, when posting a database related issue please include your database
platform and version. I would also suggest you consider using a stored
procedure or a parameterized query for this update, again depending on
your database platform.

HTH
-Chris

[Frank Py]

That helped with all my syntax errors. Thanks.

Sincerley,
Frank



*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!