C carbonsystem New Member Licensed User Longtime User May 14, 2012 #1 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?
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 Expert Licensed User Longtime User May 14, 2012 #2 Transactions are used only for "writing" procedures, not needed in this case. Upvote 0
mc73 Well-Known Member Licensed User Longtime User May 14, 2012 #3 I think you should use Code: Copy SQLFUNC.ExecNonQuery("DELETE FROM funcionarios WHERE codigo = " & "'" & codigofuncionario & "'") Upvote 0
I think you should use Code: Copy SQLFUNC.ExecNonQuery("DELETE FROM funcionarios WHERE codigo = " & "'" & codigofuncionario & "'")
