Android Question Table class LoadSQLiteDB SQL with parameters

[RB Smissaert]

How do I use a SQL with parameters with LoadSQLiteDB with the Table class?
With Table class I mean the one discussed here:
https://www.b4x.com/android/forum/threads/class-flexible-table.30649/
I can only see the option to use a plain SQL string.

Or should I just run ExecQuery2 and populate the table view from the cursor?

RBS

 

[DonManfred]

one discussed here:

in which of the 40 pages of this thread?

 

[RB Smissaert]

in which of the 40 pages of this thread?

Page 1. I thought it was quite obvious.
Or page 1 of this one:
https://www.b4x.com/android/forum/threads/class-tableview-supports-tables-of-any-size.19254/

RBS

 

[RB Smissaert]

Page 1. I thought it was quite obvious.
Or page 1 of this one:
https://www.b4x.com/android/forum/threads/class-tableview-supports-tables-of-any-size.19254/

RBS

As I have the source of this class I can just alter the arguments of LoadSQLiteDB and supply a cursor intead of the
SQL string. That should do it.

RBS

 

[klaus]

How do I use a SQL with parameters with LoadSQLiteDB with the Table class?

From now on you can, have a look HERE.
Added LoadSQLiteDB3 to the Table class.

 

[RB Smissaert]

From now on you can, have a look HERE.

in which of the 41 pages of this thread?

RBS

 

[DonManfred]

in which of the 41 pages of this thread?

You should check the link! It is a direct link to a specific POST in the Thread.
Post #1. There is a new File:

TableV2_26.zip

 

[RB Smissaert]

I would add LoadSQLiteDB4 as well with a cursor argument:

Public Sub LoadSQLiteDB4(SQLite As SQL, Curs As Cursor, AutomaticWidths As Boolean)
 
 cAutomaticWidths = AutomaticWidths
 mNumberOfColumns = Curs.ColumnCount
 innerClearAll(mNumberOfColumns)

As you may have run the query already as in my particular case.

RBS

 

[RB Smissaert]

You should check the link! It is a direct link to a specific POST in the Thread.
Post #1.

How do I get a link to the specific post? Couldn't find that.

RBS

 

[udg]

How do I get a link to the specific post? Couldn't find that.

Whenever you need to get a link to a specific post (permalink), just use what is returned clicking on the #post-number on the bottom right of any post.

 

[klaus]

How do I get a link to the specific post? Couldn't find that.

There is no specific post, I updated the file in the first post of the Flexible Table thread, same link as above.
Look at the bottom of the first page and download TableV2_26.zip, that's the latest version.

I would add LoadSQLiteDB4 as well with a cursor argument:

I will not add LoadSQLiteDB4, I don't see the utility.

 

[RB Smissaert]

Whenever you need to get a link to a specific post (permalink), just use what is returned clicking on the #post-number on the bottom right of any post.

Aah, OK. Thanks for that.

RBS