Android Question Inserting Into SQLite

Terradrones

Active Member
Licensed User
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
 
Sort by date Sort by votes

KMatle

Expert
Licensed User
Longtime User
Terradrones said:
and then writing everything back into the database
Click to expand...

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


Terradrones said:
sorting the array
Click to expand...

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)?
 
Upvote 0
R

RB Smissaert

Well-Known Member
Licensed User
Longtime User
>>
>> 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
 
Upvote 0
M

Mahares

Expert
Licensed User
Longtime User
Terradrones said:
I want insert a Stake between SV 120 and SV 1000
Click to expand...
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.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
B4A Library xSQLCipher for Android Sqlcipher 4.5.4
Replies
17
Views
2K
RB Smissaert
R
  • Question
Android Question Value inserted to sqlite is wrong
Replies
15
Views
1K
Mahares
M
S
  • Question
Android Question Read JDBCSql as bulk and Insert to sqlite
Replies
1
Views
784
Erel
  • Question
Android Question Insert Into SQLite
Replies
2
Views
2K
emexes
E
  • Article
B4J Code Snippet [B4X] Format 10,000 (Ten Thousand) to Lakh
Replies
14
Views
3K
aeric
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…