Android Question field name into B4XTable

[Gianni M]

Hi,
in some posts and examples there is a follow example:

tbl.sql1.ExecNonQuery2("DELETE FROM data WHERE rowid = ?", Array (RowId))

my app make column with:

Dim a1 As B4XTableColumn = tbl.AddColumn("id", tbl.COLUMN_TYPE_TEXT)
a1.Width = 20dip

in my app "rowid" not exists, and i use

tbl.sql1.ExecNonQuery2("DELETE FROM data WHERE c0 = ?", Array (RowId))

into table "data" there are column named "c0, c1, c2, c3, ......."
how to set column name into table "data" ?

 

[Mariano Ismael Castro]

tbl.sql1.ExecNonQuery2("DELETE FROM data WHERE rowid = ?", Array (RowId))

(This can't be right, but I could be wrong)


I have added these columns as an example
[CODE lang="b4x" title="Add Columns"]Dim id As B4XTableColumn = tbl.AddColumn("id", tbl.COLUMN_TYPE_TEXT) 'equals to c0
Dim column1 As B4XTableColumn = tbl.AddColumn("column1", tbl.COLUMN_TYPE_TEXT) 'equals to c1
Dim column2 As B4XTableColumn = tbl.AddColumn("column2", tbl.COLUMN_TYPE_TEXT) 'equals to c2

'RowId is the identifier of each row, you can think of it as the primary key[/CODE]

Could something use this to delete values from a column
[CODE lang="b4x" title="Delete from column 1"]Dim column1 As B4XTableColumn = tbl.AddColumn("column1", tbl.COLUMN_TYPE_TEXT) 'equals to c1
Dim sqlId As String = column1.SQLID
tbl.sql1.ExecNonQuery2($"DELETE FROM data WHERE ${sqlId} = ?"$, Array ("value from column 1"))[/CODE]

 

[aeric]

Don't confuse B4XTable in-memory table with your database table.

The in-memory table use column names c0, c1, c2, ...

 

[Mariano Ismael Castro]

Yo soyg