>Hi all,
>
>I have a problem wherein I need to create a cursor for a form grid and the number of fields may be different with any given call to the form.
>
>I create the cursor and then load it with fields from several tables.
>
>The problem lay in the create cursor command where I need to specify the fields. On one occasion there may need to be 15 fields, but on another occasion only 10.
>
>Does anyone have an idea on how to create a cursor with varying number of fields?
>
>Perhaps I should just use a cursor with many fields and ignore those I don't need.
>
>TIA,
>Dave
Dave, you can try to prepare character string first:
myCursor = "employee (EmpID N(5), Name C(20), Address C(30), City C(30))"
and then use the macrosubstitution.
CREATE CURSOR &mycursor
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison