none
LD-Extention RRS feed

  • Question

  • What do the Operation LDDataBase.Test?

    Can i use the command ".tables" to show the tables in a database?

    The LDS-Extention is one of the bests. Can i use all commands like the sites of http://zetcode.com/db/sqlite/ ?


    Best Regards Martin


    • Edited by martmen Sunday, November 10, 2013 2:15 PM
    Sunday, November 10, 2013 2:14 PM

Answers

  • Test is just an internal test during development - not for use.

    You should be able to use all sqlite commands e.g. the one on the zetcode site I referenced.  It does not include command line commands, just the SQL.

    Quick googling shows that the following gets the existing tables in SQL database

    SELECT * FROM sqlite_master WHERE type='table'

    For example add the following as the last line of the sample:

    LDDataBase.Query(database, "SELECT * FROM sqlite_master WHERE type='table'", listView, "False")
    Sunday, November 10, 2013 3:31 PM
    Moderator