Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL SELECT Error
Message
 
To
19/10/2005 12:27:27
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01060329
Message ID:
01060334
Views:
11
MenuInfo is not created with a SQL. It's a physical table.


>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?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Previous
Reply
Map
View

Click here to load this message in the networking platform