Android Question Resultset

Guenter Becker said:

I have a question concerning Database and Resultset. For Example if I am performing an SQL INSERT or UPDATE the data saved in the database ist changed but the data in the resultset is not!

Click to expand...

How would anyone help here if we do not know what you are doing.

Using a INSERT or UPDATE query does not change any resultset.

If if you want to get updated data call the Select query again to create a new resultset. Check this resultset then for the updated or new data.

Guenter Becker said:

It seems to me that going this way is not efficient if I am working with a Database having heavy Data load (a Million or more records)

Click to expand...

Why you need to call a select for millions datasets? NO USER will EVER want to see millions of rows of data.

What exactly are you trying to archieve? Sound like your database structure is not what you really need.

Ok thank you for your quick response and now step by step...

As you wrote 'do a SELECT' is exactly what I do and what I pointed out in my post.
I also posted that I know that a resultset is not affected by SQL Commands except SELECT.
Sorry but to repeat what I wrote does not help me.

It is not the question what I am doing on a special project. The question is in general important to get knowledge about the best and quickest way to do it. May be that at the end the last answer is 'NO other way than SELECT again'. But I think we are not at this point.

In your 2nd reply you talk about the Database. You are to be right no one will make SELECT with a million of records. That statement was only to point to the background of the question dealing with heavy dataload of databases. In a project there is a database with many thousands of records containing description and sales data of products sold worldwide. On base of this example there are cases where the result of a SELECT will have hundreds or even more than a thousand of records. To examin them or for printout.

At least the question is still open. Conclusion to the audiance Any other Ideas?

Look at Resultset.CONCUR_UPDATABLE

Daestrum said:

Look at Resultset.CONCUR_UPDATABLE

Click to expand...

Hi, never heard about that. This is not a property of the Resultset Object nor of the SQL Object. Could you give an example /description.

It has to be set from java as I don't think it's in the resultset library.

It allows the resultset to be updated and reflect changes back to the underlying database.

Whereas now we have readString(...) you gain updateString(...,value).
If used with SENSITIVE , the resultset is 'live' and will change with outside database changes.

Not too hard to use, but you have to weigh up the extra effort involved against using select then update queries.

Sounds good but I am not so familar in coding java. I am coding in B4A.
Could you please give an exmple or a place wehre to take one from.

I will try to find the test I wrote (it's on another computer).

I don't understand the question.
After you issue a SELECT command, the returned resultset is used for reading.
It is not intended for writing.
I never come across the need to write to this temporary data.
If I want to, I can issue another SQL command.

Doesn't look like sqlite supports Resultset.TYPE_SCROLL_SENSITIVE or Resultset.CONCUR_UPDATABLE.

I was using it on a different database.

Ok thank you