SQL use

Discussion in 'Questions (Windows Mobile)' started by JJM, May 30, 2007.

  1. JJM

    JJM Active Member Licensed User

    Hi,
    I don't understand the synthax of the cmd.CommandText

    I saw for example in a Erel's programm

    cmd.CommandText="SELECT name FROM sqlite_master WHERE type = 'table'"
    For me is japanese !

    Have you some examples of commands with explanations?

    Thanks a lot

    Best regards

    JJ M
     
  2. dzt

    dzt Active Member Licensed User

    cmd.commandtext takes an SQL statement. The statement of Erel,s program returns after execution all the names of tables in the SQLite database.

    A good SQL start:
    http://www.w3schools.com/sql/default.asp
     
  3. Erel

    Erel Administrator Staff Member Licensed User

  4. JJM

    JJM Active Member Licensed User

    Thank you for your help.
    JJ M
     
Loading...