Hello.
The query extracts 5 consecutive programs from the specified time for each channel in the database.
I have a SQL query in B4J to SQLite:
B4J is giving me an error:
However, this query passes in SQLiteStudio editor without any problem.
What could be the cause?
The query extracts 5 consecutive programs from the specified time for each channel in the database.
I have a SQL query in B4J to SQLite:
B4X:
'Main.bas
....
' #AdditionalJar: sqlite-jdbc-3.7.2.jar
#AdditionalJar: sqlite-jdbc-3.43.0.0.jar
...
'Module Code API
query = $"SELECT * FROM (SELECT channel, title, stop, start,
ROW_NUMBER() OVER (PARTITION BY channel ORDER BY channel) AS row_num
FROM program where stop >"${czas}") subquery WHERE row_num <= 5;"$
Dim epg0 As List= DB_EPG.SQLSelect(query,Null)B4J is giving me an error:
B4X:
2023-09-05 11:58:09 -> (Exception) java.lang.Exception: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "(": syntax error)However, this query passes in SQLiteStudio editor without any problem.
What could be the cause?