Synax error

[ifeyinwa]

hey guys,
Have a quick question. The Sql statement below works.

SQlstmt = "Update tblopgaCom2 Set "
SQLStmt = SQlstmt & "comments ='" & "" & "',"
SQLStmt = SQlstmt & "priorcomments ='" & Strpriorcomments & "."&" "& ";" & vbcrlf & Strcomments & "',"
SQLStmt = SQlstmt & "updDate=#" & Date & "# "
SQLStmt = SQlstmt & " Where Test =" & Test
Conn.Execute(SQLStmt)


however I need to add another line after theline with the date statement which is
SQLStmt = SQlstmt & "Time =#" & time() & "# "
But when I do that I get a (Syntax error (missing operator) in query expression). Can anyone pls tell me what I am missing out

 

[steven290]

try this

SQlstmt = "Update tblopgaCom2 Set "&_
"comments ='',"&_
"priorcomments ='" & Strpriorcomments & ". ;" & vbcrlf & Strcomments & "',"&_
"updDate=#" & Date & "#, "&_
"Time =#" & time() & "# "&_
" Where Test ='" & Test &"'

 

[Sheco]

Did you put the comma?

 

[steven290]

you were missing a , between the date and time statement

 

[Sheco]

ah rats, steven beat me again!

 

[steven290]

also i put ' around your test variable,i'm assuming its its not a numeric field - if it is remove them

 

[Sheco]

oh I just assumed that was OK 'cause it supposedly works as-is without the time.

 

[steven290]

could be but the field name sounds suspicious

 

[ifeyinwa]

This is what I have below and i still get an error message.
my test field is numeric.also my back end is access database

SQlstmt = "Update tblopgaCom2 Set "
SQLStmt = SQlstmt & "comments ='" & "" & "',"
SQLStmt = SQlstmt & "priorcomments ='" & Strpriorcomments & "."&" "& ";" & vbcrlf & Strcomments & "',"
SQLStmt = SQlstmt & "updDate=#" & Date & "#, "
SQLStmt = SQlstmt & "Time =#" & time() & "# "
SQLStmt = SQlstmt & " Where Test =" & Test
Conn.Execute(SQLStmt)

 

[DotNetGnat]

Time is a key word...

so wrap it around [] something like this


SQLStmt = SQlstmt & "[Time] =#" & time() & "# "

-DNG

 

[steven290]

good one DNG, missed that one

 

[ifeyinwa]

You guys are the best. It worked Time is a reserved word.the [Time] worked.thanks as always

 

[DotNetGnat]

These kinds of finer details are always easily ignored...
I am glad that its working for you

-DNG