1. #1
    Sencha - Senior Forum Manager mitchellsimoens's Avatar
    Join Date
    Mar 2007
    Location
    Gainesville, FL
    Posts
    37,327
    Vote Rating
    850
    mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute

      0  

    Default SQLite, how to select data?

    SQLite, how to select data?


    I have been able to insert data into the DB using this:

    Code:
    store.proxy.conn.exec("INSERT INTO .....")
    But this doesn't return any result. First question is how do I know it was successful (or if I'm doing it right).

    Second question, how can I get a result if I want to select certain rows?

  2. #2
    Sencha - Senior Forum Manager mitchellsimoens's Avatar
    Join Date
    Mar 2007
    Location
    Gainesville, FL
    Posts
    37,327
    Vote Rating
    850
    mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute

      0  

    Default


    Ok, so I wondered around and figure out I can do this instead of typing in the SQL statement:
    Code:
    myStore.proxy.table.insert({
    	fieldName: value,
    	fieldName1: value1,
    	fieldName2: value2,
    	fieldName3: value3,
    	fieldName4: value4,
    	fieldName5: value5,
    	fieldName6: value6
    });