Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1806 SQL: Column 'CaseNo' is not found
Message
From
25/11/2013 11:15:46
 
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:
01588615
Views:
71
How this PK is defined in these tables and why are you changing it? Normally you would avoid changing PK.

Personally, I would never allow anyone to change a PK. In the applications that I design, I use surrogate auto-generated PKs only. However, this is not an application that I designed. As I said in my original post, it is a Visual ProMatrix application that I am modifying. The PK is defined as C(10).

As I said, the problem only occurs when running against local views. When running against remote views, everything is peachy keen.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform