Android Question field name into B4XTable

Gianni M

Well-Known Member
Licensed User
Longtime User
Hi,
in some posts and examples there is a follow example:

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

my app make column with:
B4X: 
Dim a1 As B4XTableColumn = tbl.AddColumn("id", tbl.COLUMN_TYPE_TEXT)
a1.Width = 20dip

in my app "rowid" not exists, and i use
B4X: 
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" ?
 
Solution
giannimaione said:
B4X: 
tbl.sql1.ExecNonQuery2("DELETE FROM data WHERE rowid = ?", Array (RowId))
Click to expand...
(This can't be right, but I could be wrong)


I have added these columns as an example
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

Could something use this to delete values from a column
Delete from column 1: 
Dim column1 As B4XTableColumn = tbl.AddColumn("column1", tbl.COLUMN_TYPE_TEXT) 'equals to c1   
Dim sqlId As String =    column1.SQLID...
Sort by date Sort by votes

Mariano Ismael Castro

Active Member
Licensed User
Longtime User
giannimaione said:
B4X: 
tbl.sql1.ExecNonQuery2("DELETE FROM data WHERE rowid = ?", Array (RowId))
Click to expand...
(This can't be right, but I could be wrong)


I have added these columns as an example
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

Could something use this to delete values from a column
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"))
 
Upvote 1
Solution

aeric

Expert
Licensed User
Longtime User
Don't confuse B4XTable in-memory table with your database table.

The in-memory table use column names c0, c1, c2, ...
 
Upvote 1
You must log in or register to reply here.

Similar Threads

  • Article
B4A Library [B4X] B4XTableSelections - extended selection modes for B4XTable
2
Replies
21
Views
20K
aeric
  • Locked
  • Article
Android Tutorial [B4X] Cross platform Editable B4XTable + Form Example
Replies
9
Views
23K
Erel
  • Article
Android Tutorial [B4X] B4XTable - Load data from SQL database
Replies
4
Views
26K
Erel
  • Article
Android Tutorial [B4X] B4XTable - Multiple rows selection
Replies
0
Views
12K
Erel
  • Locked
  • Article
Android Tutorial [B4X] B4XTable with custom cells layout
Replies
4
Views
26K
William Lancee
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…