Solved Syntax error (1 Viewer)

[Versus]

I'm having problems with Syntax of SQL strings, what is wrong in this string

Dim Localizacao As String
Dim Patrimonio As String

Localizacao = Me.txt_localoculto
Patrimonio = Me.txt_patrimonio

Comando = "UPDATE FROM tabela_ferramentas SET Local = '" & Localizacao & "'" WHERE PatrimonioFerramenta = '" & Patrimonio & "'"

I would also like to know where I can study to learn more about these indentation problems with SQL Strings, thank you all for your attention.

 

[Gasman]

Update From?
https://docs.microsoft.com/en-us/of...ference/update-statement-microsoft-access-sql

Someone just posted a function that would handle quotes and # making creating sql strings easier.

 

[jdraw]

You need a table name in your UPDATE "tablename" statement. I think your "FROM" could be removed.
For SQL help and examples -w3schools.

For indentation see this free online utility Poor SQL

Good luck with your project

 

[Gasman]

Here you go.
https://www.access-programmers.co.uk/forums/threads/work-smarter-not-harder-sql-and-filters.311743/

Whilst it will not solve your current problem, it could help with variables and SQL in the future?

 

[June7]

FROM is not appropriate in UPDATE. There is an extra quote mark in front of WHERE. Always make sure quotes and apostrophes are in pairs - an even number by counting.

 

[cheekybuddha]

Comando = "UPDATE FROM tabela_ferramentas SET Local = '" & Localizacao & "'" WHERE PatrimonioFerramenta = '" & Patrimonio & "'"
                   ^                                                       ^
                   |                                                       |
            INCORRECT SYNTAX                                     Extra double quote here

Comando = "UPDATE tabela_ferramentas SET Local = '" & Localizacao & "' WHERE PatrimonioFerramenta = '" & Patrimonio & "'"

(Sorry, June, I only read your response after I hit 'Post' )

hth,

d