Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql Error revisited
Message
From
09/06/2008 13:54:17
Howard Brown
Howard J. Brown Consulting Services Inc.
North Kingstown, Rhode Island, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Sql Error revisited
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01322624
Message ID:
01322624
Views:
63
Code that has been running without a problem.

open database adhoc

SELECT * FROM DENIAL_service INTO CURSOR Denial

SELECT * FROM DENIAL

now generates this error when running the source code or from the command window:

DENIAL must be created with SELECT...INTO TABLE


Interestngly, I put the my same code on a newer, identically configured desktop. This one did NOT generate the error.
I'm wondering if the "first" machine has corrupted vfp code.
Any thoughts?
Regards,
Howie Brown
Next
Reply
Map
View

Click here to load this message in the networking platform