B4J Question SQLite Clear Row Data

aaronk · Jan 6, 2016

Hi,

I have a SQLite database which has a table with many rows and columns.

Each row has many columns (100 columns) all with different names.

Other than deleting the complete row and then recreating that row is there a SQL query I can use to clear the data for 1 row only but keeping the first column data and deleting the remaining column data ?

For Example:
Based on my example below, how would I clear row 1 but keep 123 (since that will unique) for this row?

eurojam · Jan 6, 2016

you can get all columnnames like this:

B4X:

    Dim cur As ResultSet
    cur = aSQL.ExecQuery("PRAGMA table_info(mytable);")
    Do While cur.NextRow
      Log(cur.GetString("name"))
    Loop

then you can build your update statement in the loop or put the field names in the a map and use dbutils with

B4X:

' updates multiple fields in a record
' in the Fields map the keys are the column names
Public Sub UpdateRecord2(SQL As SQL, TableName As String, Fields As Map, WhereFieldEquals As Map)

aaronk · Jan 6, 2016

eurojam said:
you can get all columnnames like this:

B4X:

Dim cur As ResultSet cur = aSQL.ExecQuery("PRAGMA table_info(mytable);") Do While cur.NextRow Log(cur.GetString("name")) Loop

then you can build your update statement in the loop or put the field names in the a map and use dbutils with

B4X:

' updates multiple fields in a record ' in the Fields map the keys are the column names Public Sub UpdateRecord2(SQL As SQL, TableName As String, Fields As Map, WhereFieldEquals As Map)

Sounds like a good idea on how to do it. thanks for your good idea.

B4J Question SQLite Clear Row Data

aaronk

Well-Known Member

eurojam

Well-Known Member

aaronk

Well-Known Member

Similar Threads

B4J Question SQLite Clear Row Data

aaronk

Well-Known Member

eurojam

Well-Known Member

aaronk

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency