B4J Question Insert new column in SQLite-DB

Daestrum

Expert

Licensed User

Longtime User

• Mar 10, 2018

• #2

The command you tried will work on MySQL DB but not on SQLite DB.

You can specify the order you want the columns returned in a SELECT query (unless you use *).

 

Upvote 0

R

rboeck

Well-Known Member

Licensed User

Longtime User

• Mar 10, 2018

• #3

I think, that the order of columns is not definable; but if this a problem for you, then you can create a view with columns in your wanted order or simple create the select statement like "Select Notte_Preis, Rabatt_Proz from..."

 

Upvote 0

S

strupp01

Active Member

Licensed User

Longtime User

• Mar 10, 2018

• #4

That I can query the columns about the name is known to me. I just wanted to get some structure in my DB. So I'll have to take it that way.
Thank you for your answers.

 

Upvote 0

PatrikCavina

Active Member

Licensed User

Longtime User

• Mar 11, 2018

• #5

You can create new table with the new column where you want and after populate it with the old data.
Watch this for explanation: https://stackoverflow.com/questions/4253804/insert-new-column-into-table-in-sqlite

 

Last edited: Mar 11, 2018

Upvote 0

MarkusR

Well-Known Member

Licensed User

Longtime User

• Mar 11, 2018

• #6

is seems also possible to move columns/fields up and down with the pc tool "DB Browser for SQLite"

 

Upvote 0