This is a far-out guess, but check the definition of your views. Do a "select all from sys_views where #3 contains 'number' " and see if you have any views that contain that column, and the column doesn't exist.
I can't see how it would affect running a form, but I know that all views are evaluated when you do a gateway command and I've seen those view errors there. Karen -----Original Message----- From: Doug Hamilton <[email protected]> To: karentellef <[email protected]> Sent: Tue, Sep 15, 2015 9:07 pm Subject: [RBASE-L] - Column-not-found anomaly Hi all - I get an error when trying to run a form named CUSTOMER (main table CUSTOMER): R> edit using CUSTOMER The form displays with data and the following dialog: -ERROR- Column NUMBER not found (2369) The error actually appears twice, then I am in the form. Then when I tab to different fields, I get: -ERROR- Syntax is incorrect for the command SELECT (2045) The form has only one table (CUSTOMER), with no EEPS in the form or on the table; no Stored Procedures or triggers in the db. CUSTOMER table has a PK with a PK unique rule: CustNumber IS NOT NULL AND CustNumber NOT IN ( SELECT CustNumber FROM CUSTOMER #T1 WHERE #T1.CustNumber = CUSTOMER.CustNumber) There are no columns named NUMBER in the db, the closest one is CustNumber. The form runs ok when run from Form Designer. I've unloaded and deleted the form, reloaded the db, loaded the form and reloaded the db to no avail. R:Base 9.5-32, Aug 6. Any clues for the blues? Thanks much, Doug
