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

[Mahares]

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

 

[barx]

Not that I'm aware of, you would need to create new table with new column(s) and the transfer data from old to new. Finally delete old table.

 

[Erel]

The columns order is not really important. You can always explicitly set it in the query.

 

[Itila Tumer]

WHAT does it change then? which parameters?
SQLDBUtils- that ı use
so ı want to add new columns or change names or anything else like that BUUUT I CAN NOT


I'd like to add new BİRTHDAY column but
I couldn
pLEse HELP

 

[LucaMs]

The message says that the Birthday field is not part of the table

 

[Itila Tumer]

 

[Itila Tumer]

What should I do then ?

 

[LucaMs]

You can find on the site that this has already happened to other members.

At that moment, the query points to a different DB, in which the Person table does not contain the Birthdate field.

verification:
is to run a query that lists the names of the fields in the table ... a moment that I search it

 

[Itila Tumer]

I am beginer at DB ,so
ı research so much . Is there any example file/zip which ı can excess. if there is it ,how can ı reach them .

ı think the program cannot read the changes on the table , ı 'll try to create a new table myself :/

 

[klaus]

Did you update the new DB on the device ?

 

[Itila Tumer]

I ve never tried before , I am trying to do at this time , after ı finish ı 'll let you know . I hope it works :/

 

[LucaMs]

the query is a little complicated (I should post a whole routine) but the problem remains the same: your query interrogates a version of the DB that does not contain that field in that table.

(I have not read all the posts, now I try to do it. In the meantime, given the indication, check the db)

 

[Itila Tumer]

I download it from this blog which is given in examples. I thought if ı change columns, ,it's name , order , ı hope it does change too. on program query as well . Maybe my information is not enough yet for that. ı do not know .

 

[LucaMs]

You can change the db structure, but then you need to use this new db in you app, obvioulsy.

Have you put the new db in the Files tab of the IDE?

 

[Itila Tumer]

There is no change
It made me sad , if ı learn how to change any part of the db. MAYBE I could handle it , but ı do not know how to do on this file.

 

[LucaMs]

Can you post your project?

I don't know if you are using DBUtils, how do you copy the db file, and so on

 

[Itila Tumer]

That is it

 

[Itila Tumer]

Maybe ı don't know how to get the person.db to the project

 

[Itila Tumer]

If I handle it, I 'll look for adding a photo to db . like a normal personal card . That 's what ı want . that's all .

 

[LucaMs]

The db contains the field Birthday!

The error you posted was on the Activity_Resume Edit the module but now it is empty.

Unfortunately I can not run the project, I have the previous version of B4A.

However, when you change the structure of the db, copy it directly in the Files folder of the project, because these 3 lines of code:

If File.Exists (File.DirDefaultExternal, DBFileName) = False Then
DBFileDir = DBUtils.CopyDBFromAssets (DBFileName)
end If

found a DB in the folder and do not copy the new version you've added to the Files tab.

(Sorry, at this moment I do not have any more time )