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


  • 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")
    • Edited by litdev Sunday, November 10, 2013 3:37 PM
    • Proposed as answer by Nonki Takahashi Monday, November 11, 2013 11:31 AM
    • Marked as answer by martmen Saturday, November 16, 2013 3:08 PM
    Sunday, November 10, 2013 3:31 PM