Android Question SD_SQL Return from ExecNonQuery

Chicao99

Member
Licensed User
Longtime User
Hi.
I'm doing some tests with the SD_SQL from @Star-Dust but I didn't figure out how to get a return from the ExecNonQuery function, any idea?
Thank you.
 

Mahares

Expert
Licensed User
Longtime User
but I didn't figure out how to get a return from the ExecNonQuery function
I have not used SD_SQL. But, any ExecNONquery does not return a value. That is why it is called NonQuery. It is usually used to INSERT, DELETE , CREATE or UPDATE
 
Upvote 0

Chicao99

Member
Licensed User
Longtime User
I have not used SD_SQL. But, any ExecNONquery does not return a value. That is why it is called NonQuery. It is usually used to INSERT, DELETE , CREATE or UPDATE
Thanks for answering.
What I really need is to know if it worked or not.
In the LOG I can see that, but how do I do that in the code?
 
Upvote 0

Star-Dust

Expert
Licensed User
Longtime User
Hi.
I'm doing some tests with the SD_SQL from @Star-Dust but I didn't figure out how to get a return from the ExecNonQuery function, any idea?
Thank you.
Update to version 0.04
 
Upvote 0

Smee

Well-Known Member
Licensed User
Longtime User
Update to version 0.04
I believe to get a return on records affected you use something like
B4X:
        Dim ctr As Int
        ctr= DBase.sql.ExecQuerySingleResult("select changes() as xval")
        Log(ctr)
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…