Error in SQL

  • Thread starter Thread starter jokobe
  • Start date Start date
J

jokobe

What is wrong with this update:
update mytable set IntWorkFlowStatus = '90' , note = 1 where myid = 9119;


Any helpful hint?

Thanks in advance

jokobe
 
As posted, nothing is wrong.
It would be helpful if you told us what error you are getting. My first
guess is data type mismatch. You are assigning a string value to a field
named IntWorkFlowStatus. Assuming some sort of a naming convention, I would
expect it to be in Ingteger field. If that is correct, remove the quote
marks around the 90.

It is also expecting note to be a numeric field, but it would be more likely
a field named note would be a text field of some kind, most likely a memo
field.
 
thanks for your help:

I inserted this part " , note = 1 ", it was working fine without ...
note is the german word for grade, in my table it is an integer field.
When I try to run the SQL code it is not running and the cursor jumps to
"note".
Is note a reserved word???

jokobe
 
I don't think so, but I could be wront. Try putting brackets around it and
see what happens. [note]
 
One thing the OP could try is create a new query, switch to SWL view and
paste in the SQL statement, then switch back to the query grid.

If everything looks OK, try running the query. Once the query runs, switch
to SQL view, copy the SQL and paste it into the code.


HTH
--
Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)


Klatuu said:
I don't think so, but I could be wront. Try putting brackets around it and
see what happens. [note]
--
Dave Hargis, Microsoft Access MVP


jokobe said:
thanks for your help:

I inserted this part " , note = 1 ", it was working fine without ...
note is the german word for grade, in my table it is an integer field.
When I try to run the SQL code it is not running and the cursor jumps to
"note".
Is note a reserved word???

jokobe
Click to expand...
Click to expand...
 
thanks Klatuu,
the brackets made my day....
with brackets it is working..


jokobe

Klatuu said:
I don't think so, but I could be wront. Try putting brackets around it and
see what happens. [note]
--
Dave Hargis, Microsoft Access MVP


jokobe said:
thanks for your help:

I inserted this part " , note = 1 ", it was working fine without ...
note is the german word for grade, in my table it is an integer field.
When I try to run the SQL code it is not running and the cursor jumps to
"note".
Is note a reserved word???

jokobe
Click to expand...
Click to expand...
 
Back
Top