If I issue the following line of code:

SELECT * FROM myTable INTO CURSOR myCursor

I can then issue a:

SELECT myCursor

to process these records. If I want to build a more complex select statement and store it in a string, then how do I execute it?

Using the above example:

lcSql = "Select * FROM myTable INTO CURSOR myCursor"

What is the next thing I need to do to process lcSql to create myCursor?

Thanks in advance for any suggestions,

Mat Kennedy