Hi,
How do i declare cursor and loop through the cursor in interbase database.

I am trying to Declare cursor like

DECLARE myCursor CURSOR FOR
Select OrderNo,OrderDate
from tblOrders

I am using interbase workbench and I am not able to compile this code.

It gives an error message "an error occured at token DECLARE "

So,can anybody help me in declaring and iterating through a cursor

Regards