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:00:00
 
 
À
27/11/2013 14:44:58
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:
01588846
Vues:
44
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!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform