Not sure if this is an issue here or with sqlite-net but I figured I'd start here. I'm getting an SQLiteException trying to execute the following SQL:
SELECT lastName, firstName FROM attendee WHERE (lastName, firstName) > ('Doe', 'Jane')
There error seems to be on the first comma. The SQL executes correctly in DB Browser and if I remove one of the columns from the clause it executes correctly in code. Is this is a known limitation or am I doing something wrong?
Not sure if this is an issue here or with sqlite-net but I figured I'd start here. I'm getting an SQLiteException trying to execute the following SQL:
SELECT lastName, firstName FROM attendee WHERE (lastName, firstName) > ('Doe', 'Jane')There error seems to be on the first comma. The SQL executes correctly in DB Browser and if I remove one of the columns from the clause it executes correctly in code. Is this is a known limitation or am I doing something wrong?
Thanks!