Android Question SD_SQL Return from ExecNonQuery

[Chicao99]

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]

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

 

[Chicao99]

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?

 

[Star-Dust]

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

 

[Smee]

Update to version 0.04

I believe to get a return on records affected you use something like

        Dim ctr As Int
        ctr= DBase.sql.ExecQuerySingleResult("select changes() as xval")
        Log(ctr)