Register SQL does not erase

C

carbonsystem

New Member
Licensed User
Longtime User
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?
 
Sort by date Sort by votes

mc73

Well-Known Member
Licensed User
Longtime User
I think you should use
B4X: 
SQLFUNC.ExecNonQuery("DELETE FROM funcionarios WHERE codigo = " & "'" & codigofuncionario & "'")
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Android Question Feature Request: Support registerForActivityResult in B4A
Replies
1
Views
601
Alessandro71
  • Question
Android Question [RESOLVED] One of RECEIVER_EXPORTED or RECEIVER_NOT_EXPORTED should be specified when a receiver isn't being registered exclusively for ....
2
Replies
27
Views
23K
Computersmith64
A
  • Question
Android Question JdbcSQL app works in debug but not in release
Replies
3
Views
4K
Erel
  • Article
B4J Library [B4X] [B4XLib] SD_SQL (direct access to MySQL, MariaDB, MS SQL, FireBird)
2 3 4
Replies
68
Views
43K
Mashiane
  • Article
Android Code Snippet Register User example using OkHttpUtils2
3 4 5
Replies
92
Views
71K
aeric
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…