SQL Cursors

From: kd (kd_at_discussions.microsoft.com)
Date: 06/13/04 

Date: Sun, 13 Jun 2004 06:59:01 -0700

Hi all,

I had posted this question earlier, its been 2 hrs and my post has not yet appeared in the list; so I am posting it agiain!

I want to process the query results, row-by-row and then display them. I have used cursors before with SQL server, how can I use cursors in foxpro? I have searched the help files; but could not find what I am looking for!

I want to use
SELECT fld1,fld2....FROM table1, table2 WHERE <condition> INTO CURSOR <cursor_name>
then, OPEN CURSOR and then process the results row-by-row
but, there is no OPEN CURSOR command in foxpro!

Can anybody guide me how to go about this?

Regards.
kd