Hi guys,
I have UPDATE sql statement with ORDER BY in my app and it stopped working
(in simulator and in android device too)
Is there any change in DB implementation which can cause such a behavior?
This is my statement:
String[] params = new String[2];
params[0] = iduser;
params[1] = fsname;
db.execute("UPDATE TSUSET SET FMSETT = FMSETT + 1 WHERE (IDUSER = ? OR
IDUSER = 'ALL') and FSNAME= ? ORDER BY CASE IDUSER WHEN 'ALL' THEN 2 ELSE 1
END LIMIT 1", params);
params are correctly entered
Previously it was working but now I'm getting error: syntax error near ORDER
Thanks
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/codenameone-discussions/b50f5b25-5cf8-4632-9229-869ca777e3e0%40googlegroups.com.
