SQLite, how to select data?

[mitchellsimoens]

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

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?

[mitchellsimoens]

Ok, so I wondered around and figure out I can do this instead of typing in the SQL statement:

myStore.proxy.table.insert({
	fieldName: value,
	fieldName1: value1,
	fieldName2: value2,
	fieldName3: value3,
	fieldName4: value4,
	fieldName5: value5,
	fieldName6: value6
});