Android Question SQLITE/SQLCipher

DonManfred said:

You can update any Data in your Database.
Use Update to update a dataset.

You can not change a Resultset though.
Change the data and run the query again to get updated results in Resultset.

Click to expand...

Guenter Becker said:

What I do not know if the Resultset is working simmilar to a B4XTable with loading Data by Paging

Click to expand...

DonManfred said:

You can limit the Query to return only x datasets.

Click to expand...

DonManfred said:

There is NO SUCH thing.

Click to expand...

Guenter Becker said:

Good Morning to you,
as I understood the database itself and the Resultset are two independent Objects. INSERT/UPDATE DELETE will change the Database Data but the Resultset Data is not synchronized and is not effected by those actions.

To solve this I save the SELECT statement and after doing one of this operation I reloaded the Resultset to make shure that it contains the newly Database changes. In my opinion this is not the best solution.

My question:
Is it possible and if yes how to insert, update or delete a row of the Resultset by code? B4A codesnipped would be fine. Thankyou.

Click to expand...

Guenter Becker said:

Nearby the requested help/information are good as well for SQLCipher because the Base of SQLCipher is SQLite.

Click to expand...