Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL SELECT Error
Message
From
19/10/2005 12:27:27
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01060329
Message ID:
01060332
Views:
12
Hi Kevin,
You might try putting a NOFILTER on the select statement that builds Menuinfo, just before you get to this line. VFP is sneaky sometimes, and instead of making a whole new cursor file for the the select statement, it just opens the table again with a filter.

HTH
Beth

>Getting the message:
>
>'MENUINFO' must be created with SELECT...INTO TABLE.
>
>on this line:
>
>
>SELECT RecordId, MenuId, ItemType;
>  FROM MenuInfo;
>  WHERE ParentId == oObject.sRecordId;
>  INTO ARRAY aRecords
>
>
>This works fine on 2 development PC's, but on a third development PC, it throws
>this error.
>
>Anyone know what's wrong?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform