Android Question SQLITE/SQLCipher

[Guenter Becker]

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.

 

[DonManfred]

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.

 

[Guenter Becker]

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.

Thank you for quick response. As I wrote that is exactly what I do. What I do not know if the Resultset is working simmilar to a B4XTable with loading Data by Paging. I did not try it yet but it seems to that loading big Data from the Database (let's say 1000 Records) will use some waiting time. Do you have any experiance?

 

[DonManfred]

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

There is NO SUCH thing.

You can limit the Query to return only x datasets.

 

[DonManfred]

You threadtitle is not accurate. The question is not related to SQLCipher at all.

 

[LucaMs]

You can limit the Query to return only x datasets.

There is NO SUCH thing.

 

[LucaMs]

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.

You will necessarily have to execute the SELECT query again and first close the ResultSet.

 

[Guenter Becker]

Ok, thank you
maybe it will be a good whish to have a sync option in the Resultset but that should be something todo by Erel.

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

 

[DonManfred]

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

If a resultset can be updated or not is not related to SQLCipher.

 

[Daestrum]

The resultset is synchronized if it's set to CONCUR_UPDATABLE and TYPE_FORWARD_ONLY

You can then do a SELECT, change the data in the resultset (rs.updateString(xxx,yyy) ), then update the db with rs.updateRow()

Not sure any current libraries support this though, you may need to revert to pure java to implement.

 

[aeric]

How about using a temporary table?