Mathew,
You are allowed 1 index on a cursor, near as I can tell. Try this simplified code:
>SELECT * FROM YTDDET WHERE BETW( ACCBRN, "1000","9999");
>AND !INLIST( ACCBRN,"9612") INTO CURSOR TEMP
>
>INDEX ON BDATE TAG BDATE <--- Error Here
>
This ought to be OK because it appears that you want the cursor open only once, so just open it to the alias you want to end up with.
If you want to keep it as a table, use ...INTO TABLE MyTableName
Hope this helps.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only