Illusion25
Newbie
Joined: 29 May 2018
Posts: 4
|
 Posted: Sun May 19, 2019 12:21 am
SQLDB - zScript command line parsing problem
|
I have a simple sqlite 3 database with table Players and column Name
The problem I have if i paste this alias to command line:
#ALIAS {test} {
row=%sql(GroupDB, "SELECT * FROM Players")
#WHILE (!@row.Eof()) {#SHOW Name: @row.Item("Name");#CALL @row.Next}
}
In Package Editor the test alias show like this:
row=%sql(GroupDB, "SELECT * FROM Players")
#WHILE (!@row.Eof(85)) {#SHOW Name: @row.Item(85);#CALL @row.Next}
Note the value 85 in Eof and row.Item (sometimes i got a value of 100)
Any solution for this ?
Thank you in advance |
|
