From: Alexander P. <ale...@re...> - 2009-01-13 15:54:24
|
Hauser, Karsten wrote: > I've created the issue. I don't know how to trace the execution of the statement in Firebird. Maybe you can give me an manual for doing this? > > I have only one further statement which works: > SELECT pe.NR, us.USER_LOGIN > FROM IBKPVS_SYS_USER us > LEFT JOIN PERSONAL@formica pe ON us.USER_PERS_ID_FK = pe.NR > where TRIM(us.USER_LOGIN) = 'ADMIN' > > But inserting a trim should not be the solution.. > > No, I have said about ODBC trace file. I want to look at the first query (without TRIM in the SQLPrepare) and the second query with TRIM at ODBC level. Regards, Alexander -- Alexander Potapchenko Senior developer |