Ed Leafe schrieb: > On Apr 12, 2009, at 5:13 AM, Sibylle Koczian wrote: > >> at the start of the application I get this error: >> >> (-206, 'isc_dsql_prepare: \n Dynamic SQL Error\n SQL error code = >> -206\n Column unknown\n EMPLOYEE_PROJECT.PROJ_ID\n At line 8, >> column 9') >> SQL: SELECT first 1000 >> epr."EMP_NO", >> epr."PROJ_ID", >> employee."FIRST_NAME", >> employee."LAST_NAME" >> from employee_project as epr >> inner join employee on epr."EMP_NO" = employee."EMP_NO" >> where employee_project."PROJ_ID" = 'VBASE' >> >> But all the table and column names are correct. If I don't use an >> alias >> for table employee_project, the error message disappears and the data >> are shown correctly. What's wrong with my use of the alias? > > How are you adding the 'where' clause? That has the table name and > not the alias. >
Exactly, and the where clause is added by the SQLBuilder method. I just added a ticket (1228) to the tracker. Regards Sibylle -- Sibylle Koczian _______________________________________________ Post Messages to: Dabo-users@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/49e33e15.4090...@t-online.de