-
Notifications
You must be signed in to change notification settings - Fork 107
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
iOS: Error: selectSQL prepare failed #9
Comments
@tobiasmuecksch First thanks for using the plugin. Which release of the plugin are you using?.
this should work. |
@jepiqueau Thank you for your response. I'm using version |
@jepiqueau I have created a demo repository for you.
|
@tobiasmuecksch
it can only be executed by the execute method
with
this should be better if your statement were correct but it is wrong SQL Statement look first at the design of your database you intend to create a table "myTable" and you make a query on table "conversation" which is not existing i have provided an app starter https://github.com/jepiqueau/angular-sqlite-app-starter you should be looking at it finally i made the following changes and it works async testSqlite() {
const statement = `
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "myTable" (
id TEXT PRIMARY KEY NOT NULL,
Type TEXT,
Title TEXT
);
PRAGMA user_version = 1;
COMMIT TRANSACTION;`;
await this.sql.init();
const result = await this.sql.execute({statements:statement});
console.log('RESULT', result);
const selectStatement = 'SELECT * FROM myTable';
const result1 = await this.sql.query({statement: selectStatement, values: []});
console.log('SELECT result (should be empty)', result1);
const insertStatement = `INSERT INTO myTable (id,Title) VALUES (?,?);`;
const result2 = await this.sql.run({statement: insertStatement, values: ['1234', 'Titel für 1234']});
const result3 = await this.sql.run({statement: insertStatement, values: ['4321', 'Titel für 4321']});
console.log('RESULTS', result2, result3);
// As you didn't enter the field "Type", you have to do a query
// only on non "NULL" fields current limitation that i am working on
const query1 = "SELECT id,Title from myTable"
const result4 = await this.sql.query({statement: query1, values: []});
console.log('SELECT 2 RESULTS (should have two results)', result4);
} and in the sqlite.service async run(query: capSQLiteOptions): Promise<capSQLiteResult> {
await this.waitForReady();
console.debug('SQL RUN:', query);
return await this.sqlite.run(query);
}
You also understand now that the transformQuery method will never work |
You are right, that's a copy-paste fault, because I copy-pasted the code from my main project. Thank you very much for your help. I will try that and then close the issue. |
@tobiasmuecksch Ok you are welcome |
I will have a look to deal with sqlite NULL value in the next release, to day i am currently working on storing base64 image strings as Blob in sqlite3 which is not as easy |
Good to know. So I'd have to set empty strings instead? |
Hello,
I'm trying to execute a
SELECT
sql statement as described in the readme.But the result looks like this:
This is the relevant excerpt of my code:
I am trying this on my iPhone 10 device.
Am I doing something wrong or is there a bug?
The text was updated successfully, but these errors were encountered: