I'm trying to migrate a 4.2 gpre program to FB 1.0.2.

I get the following message:

/opt/interbase/bin/gpre -c -n tacap.e -d /bripack/data/live.fdb
(E) tacap.e:18: relation EMPLOYEE is ambiguous
(E) tacap.e:19: relation EMPLOYEE is ambiguous
(E) tacap.e:62: TABLE EMPLOYEE is ambiguous
(E) tacap.e:94: TABLE EMPLOYEE_TADATA is ambiguous
4 errors, no warnings

here is the relevent lines of code:

18: BASED_ON employee.clock_card clock_card;
19: BASED_ON employee.employee_u employee_u;

61: EXEC SQL SELECT employee_u INTO :employee_u FROM employee
62: WHERE clock_card = :clock_card;

94: EXEC SQL INSERT INTO employee_tadata (employee_u)
95: values (:employee_u);

_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger