I'm using Intellij IDEA. Running the following code results in an SQL
syntax error.
The code:
private void clearAllEntries(Database db, SQLMap sqlMap) throws
IOException, InstantiationException {
SignInListEntry signInListEntry = new SignInListEntry();
List<PropertyBusinessObject> objs = sqlMap.select(signInListEntry,
signInListEntry.signInListId, true, 1000, 0);
Logger.log("Deleting " + objs.size() + " entries");
for (PropertyBusinessObject o : objs) {
sqlMap.delete(o);
}
The log message showing the DELETE statement:
DELETE FROM SignInListDetail WHERE ,entryId = ?signInListId = ?firstName
= ?lastName = ?email = ?officePhone = ?mobilePhone = ?organization = ?address1
= ?address2 = ?address3 = ?city = ?state = ?country = ?zip = ?
And the error:
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near
",": syntax error)
It's not a missing database because I can add records to the same database
using the same Database object and SQLMap. Am I doing something wrong or
is this a CN1 bug?
--
You received this message because you are subscribed to the Google Groups
"CodenameOne Discussions" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
Visit this group at https://groups.google.com/group/codenameone-discussions.
To view this discussion on the web visit
https://groups.google.com/d/msgid/codenameone-discussions/2eb68589-80c1-4767-b28b-59880d10a28d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
