Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1806 SQL: Column 'CaseNo' is not found
Message
From
28/11/2013 12:38:06
 
 
To
28/11/2013 12:00:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01588611
Message ID:
01588848
Views:
41
What version of VPM do you use?
I use 9.1.12a (should be the latest) and do not have a REQUERY in VPMDataHandler.OpenView().

Gerhard

> Is it actually throwing the error on VFP's requery or in VPM code?
>
>It is throwing the error on
>
>
>REQUERY('ViewName')
>
>
>inside of the VPM DataHandler's OpenView method.
>
>Seeing your name on it, I knew it was going to be interesting.
>
>LOL!!!! The only time I ever post question here is when I have tried everything and am all out of rabbits. My gut feel is that this is a problem somewhere in the VPM metadata, but I have looked at it a dozen times and it all seems to be right.
>
>The thought plickens... What was broken in the RI and could it have ANY bearing?
>
>The short answer is I don't know. I kept changing things in the CA that controls the RI and the metadata behind the CA until it finally started working. Sometimes I would rather be lucky than good :)
>
>Ii>Metadata. Is VPM rebuilding something internally from metadata using field evaluation? Grabbing a field it shouldn't because it started life as a different query?
>
>I'm thinking that it must be somewhere, I just can't find where. Thanks for trying to help and Happy Thanksgiving!
Gerhard Schmidbauer
URANUS Software GmbH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform