I am struggling to make a SQL prompt box which will execute immediate and see the results as I would in SQLite3. To visualize what I am trying to do is to use the sample OS Command Shell example in the Advanced / Shell Interactive Shell examples, but execute it in sqlite. I may enter any valid sqlite command, (system ie .dump, DDL or DML)
As always any assistance is greatly appreciated.
there are two types of interaction, I suppose:
In case of execute:
Catch error As DatabaseException
it is simple, you’ll get error message text to show/display or just display OK when there was no error.
In case of query (select…) you probably would like to see a table with columns filled with database rows. You can do normal selectSQL:
var r as rowset=app.database.SelectSQL(sql)
ListboxQuery.ColumnCount=r.ColumnCount //set the listbox to as many columns as they are returned from SelectSQL..
//then insert names of RowSet columns into Listbox headers:
for x as integer = 1 to r.ColumnCount
…and the follow filling the listbox from RowSet as usual
small update due to my error:
for x as integer =0 to r.ColumnCount-1