Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql Error revisited
Message
 
 
To
09/06/2008 13:54:17
Howard Brown
Howard J. Brown Consulting Services Inc.
North Kingstown, Rhode Island, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01322624
Message ID:
01322631
Views:
13
Either data is different or some SET setting is different. Did you check the article I pointed you to that explains what could be a factor?

>Code that has been running without a problem.
>
>open database ad-hoc
>
>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
>
>
>Interestingly, 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
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform