Subject DB navigator problem
Author Robert martin

Just changed a screen to work with a TIBOQuery instead of a TIBOTable.
Almost all is working fine, however the refresh button on my dbnavigator
is now disabled. Any ideas why?

The IBOQuery is on a Readonly transaction. The SQL follows

SELECT .... Fields
FROM Client c
LEFT JOIN Address a ON a.AddressRef = c.AddressRef
WHERE :ShowMode = 'A' OR c.ChargeFlag = :ShowMode
ORDER BY c.ClientCode

Setting ShowMode to 'A' displays all otherwise it filters to ChargeFlag.

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496

Wild Software Ltd