Update sintax error

[Rodolfo Fontes]

Hi group,

Is there anything wrong with this statment?

DoCmd.RunSQL "UPDATE [T Tabela_de_Precos] SET [T Tabela_de_Precos].Valor_FN
= " & rs_prod!Total & " WHERE (([T Tabela_de_Precos].CodProd) = " &
rs_prod!CodProd & ");"

Another question...
On Sql commands, is there any document with how can i do it using using
variables that are on the code?

Thanks,
Rodolfo Fontes

 

[Ken Snell [MVP]]

If Valor_FN and CodProd fields are numeric fields, then this should work.

However, if they are text fields, you must delimit the values you're
concatenating into the string with ' characters:

DoCmd.RunSQL "UPDATE [T Tabela_de_Precos] SET [T Tabela_de_Precos].Valor_FN
= '" & rs_prod!Total & "' WHERE (([T Tabela_de_Precos].CodProd) = '" &
rs_prod!CodProd & "');"