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
