Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error 1806 SQL: Column 'CaseNo' is not found
Message
De
28/11/2013 12:38:06
 
 
À
28/11/2013 12:00:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01588611
Message ID:
01588848
Vues:
40
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform