![]() Then, this is how it looks like below: sqlite>. header offĪnd these commands show the details of the command ".header". Then, this is how it looks like below: sqlite> select * from user Īnd this command below unsets column names. app.Alert("Here is all Column names what Select from your table:\n" s) This is the answer how to read column names from table:įor(var ColumnNames in (0)) s = " " // "" optional, i use only in this demo Callback to show query results in debug. Use all rows what is in ExecuteSql (try any, it will works fine)ĭb.ExecuteSql( sqlstring,, OnResult, OnError ) "(id integer primary key, data text, num integer)",null, OnError )ĭb.ExecuteSql( "insert into test_table values (1,'data10',100),ĭisplayAllRows("SELECT * FROM test_table") ĭisplayAllRows("select *, id 100 as idplus, 'hahaha' as blabla fromįunction DisplayAllRows(sqlstring) // <- can you use for any table not need to Create a table (if it does not exist already).ĭb.ExecuteSql( "drop table if exists test_table" )ĭb.ExecuteSql( "CREATE TABLE IF NOT EXISTS test_table " Create a text label and add it to layout. Lay = app.CreateLayout( "linear", "VCenter,FillXY" ) Create a layout with objects vertically centered. Sql query return nothing in the second time of executing (SQlite database). ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |