Is the ' # ' character in the TABLENAME alias ' #T.1 ' a factor? Is the ' # ' character reserved for COLUMN NUMBER aliases?
Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Doug Hamilton Sent: Tuesday, September 15, 2015 7:06 PM To: [email protected] 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
