Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1806 SQL: Column 'CaseNo' is not found
Message
From
26/11/2013 16:18:40
 
 
To
26/11/2013 15:57:41
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:
01588702
Views:
42
The error message indicates a structure issue; it seemed prudent to focus on that.

If it were a structural issue, wouldn't it happen all the time and not just when the change in PK is cascaded to the child tables?

What were the original and changed PKs? Does it fail for only a specific change or all PK changes?

The RI routine works just fine. It is after the RI code runs that the problem occurs. And it only occurs when using local views. The problem does not occur when using remote views

Does changing the PK back to original value "fix" the problem or stay broken?

I can't do that. After the PK is changed and cascaded to the child tables everything is broken. It can't even find the column caseno in the parent view.

Are you running into an accidental keyword, wildcard or end of file?

No - this table used to be named case - I changed it to FuneralCase.

Is tracing the RI code during the update possible?

I have traced through the RI code and it runs just fine.

What is in the additional aliases?

It is empty. This form is the parent of a bunch of related child forms.

Thanks for sticking with me. How long have you used VPM?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform