Problem with "Create cursor.."

[FoxLearner]

Hi all
I am getting an error message "Syntax Error" when I use the create cursor command. The line where I get this error is:

Create Cursor curMyCursor from Array aMyArray

The array aMyarray exists and is available. I can see all the elements and their values in the Debugger.

Would you please tell me why I am getting this and how can I correct it?

Thanks and regards
FoxLearner

 

[rgbean]

FoxLearner,
Are you sure that the format of aMyArray matches that documented in the help section for AFIELDS(). Note the length of the array rows will vary depending on the version of VFP you are using.
VFP 3.0 - 11
VFP 5.0, 6.0, 7.0 - 16
VFP 8.0 - 18

Rick

 

[Mike Gagnon]

Foxlearner

CREATE CURSOR from an array will only work if the content of the array contains the name, type, precision, and scale for each field in the temporary table. Not actual data only structure. Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.