hello.
is it possible to reference fields using this format?
i am trying to replace some text within the ScriptDirectory field. Asset is an existing field within the same aScriptUpdater table.
_SQLite_Startup()
_SQLite_Open($sql_db)
_SQLite_Exec(-1, "UPDATE aScriptUpdater SET ScriptDirectory=REPLACE(ScriptDirectory, 'C:', '' & Asset.aScriptUpdater & 'c$')")
_SQLite_Close()
_SQLite_Shutdown()
the error i get is:
thanks in advance!