Quote:
Originally Posted by JocAnis
Did you try same query with MySql? How i remember some functions are not possible to query with sqlite, like Auto_increment, so maybe thats the issue
|
Yes, as you said Auto_increment is not possible in sqlite, however, AUTOINCREMENT yes, as I demonstrated in the sqlite db browser program the syntax is correct, I am thinking that the sqlite version of amxx may not be as current and does not support "ROW_NUMBER () OVER ()"
Which leads me to think about how to count the querie lines by returning them in a column, what a boring situation...
__________________