Android Question Alter a SQLite Table by Adding a Column Not at the End of the List

Mahares · Oct 12, 2013

According to the SQLite documentation: 'The new column is always appended to the end of the list of existing columns.'
Is there any way to change the placement of a column within a table after it is appended without having to create a new table, append to it the records from the source table, then delete the source table and rename the destination table?
I thought it may be beneficial at times when you have a delimited text file without a header that needs to be appended to an altered table but the text file columns have a set order.
Thank you

Itila Tumer · Feb 21, 2014

I really thank you for your time , thank you very much .

klaus · Feb 21, 2014

I had a look at your project.
The Burthday column is in the database and is displayed when you show the Edit activity.
Clicking on an item raises an error.
Why did you change the value in this line in the Sub WebView1_OverrideUrl routine in the Edit module ?

B4X:

values = Regex.Split("[.]", Url.SubString(8))

It must be :

B4X:

values = Regex.Split("[.]", Url.SubString(7))

like in the original project in the User's Guide, and it works !
The same in the WebView module !

I saw in your layouts that you have several different screen resolutions !?
You should be coherent in the layouts.
What devices are you targetting ?

Android Question Alter a SQLite Table by Adding a Column Not at the End of the List

Mahares

Expert

Itila Tumer

Active Member

klaus

Expert

Android Question Alter a SQLite Table by Adding a Column Not at the End of the List

Mahares

Expert

Itila Tumer

Active Member

klaus

Expert

Privacy & Transparency

Privacy & Transparency