Can I not use a variable in a substring on a declare statement? The following code doesn't compile.
PHP Code:
Exec Sql
Declare MainCursor Cursor For
Select myfield1 From myfile
Where Substring(myfield2, :Indx ,1) = 'Y';
Comment