Android Question Inserting Into SQLite

[Terradrones]

Hi All

Need help again please.

I have a SQLite database which has all the information on the widths of a road. It consists of the following:

Stake Left Width Right Width
0.000 5.000 5.000
120.000 5.000 5.000
1000.000 6.000 6.000
......etc.

I want insert a Stake between SV 120 and SV 1000, that it looks as follows:

Stake Left Width Right Width
0.000 5.000 5.000
120.000 5.000 5.000
900.000 5.000 5.000
1000.000 6.000 6.000
......etc.

At the moment I am reading the Database into an array, sorting the array and then writing everything back into the database.

Is there an easier way?

Thanks
Michael

 

[KMatle]

and then writing everything back into the database

It's all about the design of your database. You should only write back the new/changed entries.

sorting the array

Let SQlite do the sort for you (via ORDER BY <column name> ASC or DESC). So the result set is already sorted.

Which column names do you use? Or do you store anything int ONE column (which is bad)?

 

[RB Smissaert]

Hi All

Need help again please.

I have a SQLite database which has all the information on the widths of a road. It consists of the following:

Stake Left Width Right Width
0.000 5.000 5.000
120.000 5.000 5.000
1000.000 6.000 6.000
......etc.

I want insert a Stake between SV 120 and SV 1000, that it looks as follows:

Stake Left Width Right Width
0.000 5.000 5.000
120.000 5.000 5.000
900.000 5.000 5.000
1000.000 6.000 6.000
......etc.

At the moment I am reading the Database into an array, sorting the array and then writing everything back into the database.

Is there an easier way?

Thanks
Michael

>>

Hi All

Need help again please.

I have a SQLite database which has all the information on the widths of a road. It consists of the following:

Stake Left Width Right Width
0.000 5.000 5.000
120.000 5.000 5.000
1000.000 6.000 6.000
......etc.

I want insert a Stake between SV 120 and SV 1000, that it looks as follows:

Stake Left Width Right Width
0.000 5.000 5.000
120.000 5.000 5.000
900.000 5.000 5.000
1000.000 6.000 6.000
......etc.

At the moment I am reading the Database into an array, sorting the array and then writing everything back into the database.

Is there an easier way?

Thanks
Michael

>> I want insert a Stake between

That is the principal mistake. You can't and shouldn't rely on a presumed location of a row in the table.

RBS

 

[Mahares]

I want insert a Stake between SV 120 and SV 1000

You had asked the same exact question two months ago in the below thread and you were given plausible answers::

Insert Into SQLite

Hi I am nearly finished porting the "Design" routines from VB.Net (mobile) to B4A. The Design consists of geometric parameters...i.e. Horizontal Alignment, Vertical Alignment, Crossfalls, Surface Widths, Stakeline Offsets, etc. These are parameters used to define a road, a canal, railway, etc...

www.b4x.com

We know you are a good surveyor, but if you want to be a good programmer, you have to either trust the answers you are given, or if they are not satisfactory, you should have continued to challenge them in that thread until you got satisfaction. The least you could have done is refer to the old thread.

 

[Terradrones]

Sorry, I sometimes forget what I asked in the past.