Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | App - FluidShell |
| Version | 14.0 |
This is how SQLite works. Please see the "sqlite3 test" attachment, which uses the sqlite3 command-line window to submit the INSERT statement and complains about the syntax error.
Which sqlite3 binaries do you use that takes the INSERT statement with multiple rows? Do you turn on any special setting?
From http://www.sqlite.org/lang_insert.html
The INSERT statement comes in three basic forms.
The first form (with the "VALUES" keyword) creates a single new row in an existing table.
According to the release history of SQLite, the INSERT syntax was enhanced to allow multiple rows to be inserted via the VALUES clause in release 3.7.11.
However, the SQLiteJDBC code that we are using is from release 3.7.8 (try "select sqlite_version()" in an ADS Query Window connected to a SQLite database). Therefore, it doesn't support the new INSERT syntax.
According to the release history of SQLite, the INSERT syntax was enhanced to allow multiple rows to be inserted via the VALUES clause in release 3.7.11.
However, the SQLiteJDBC code that we are using is from release 3.7.8 (try "select sqlite_version()" in an ADS Query Window connected to a SQLite database). Therefore, it doesn't support the new INSERT syntax.
In a future release, we'll see if there is a newer version of SQLite driver available.
In a future release, we'll see if there is a newer version of SQLite driver available.
Issue #7977 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
This is how SQLite works. Please see the "sqlite3 test" attachment, which uses the sqlite3 command-line window to submit the INSERT statement and complains about the syntax error.
Which sqlite3 binaries do you use that takes the INSERT statement with multiple rows? Do you turn on any special setting?
From http://www.sqlite.org/lang_insert.html