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...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice