Adding the item Is Null to the relations-listbox in the Advanced Query Form should help (I
think).
The problem is when you put “Is Null” in the Fieldvalue field
you get the ‘=’ in the sql-statement:
(a0108a0324a0318a0322.RenditionNumber = Is Null))) this should be RenditionNumber
Is Null
I think the data in the listbox is hardcoded in tms because the table
dbo_QueryDetails refers to the 7 choices in the listbox only with the numbers 0
through
I will be very happy if Gallery Systems solves the problem in the next
upgrade, I think for them it is rather easy to fix.
Registrar
tel. +31-(0318)-596 168, fax +31-(0318)-592 209