Register SQL does not erase

[carbonsystem]

Expensive Gentlemen I am excluding a register in SQL lite using the following line:

SQLFUNC.BeginTransaction
SQLFUNC.ExecQuery("DELETE FROM funcionarios WHERE codigo = '" & codigofuncionario & "'")
SQLFUNC.TransactionSuccessful
SQLFUNC.EndTransaction


Error is not presented, however the register remains in the database. What it can be? What I must make to bring up to date the database after the exclusion?

 

[NJDude]

Transactions are used only for "writing" procedures, not needed in this case.

 

[mc73]

I think you should use

SQLFUNC.ExecNonQuery("DELETE FROM funcionarios WHERE codigo = " & "'" & codigofuncionario & "'")