Subject Re: [firebird-support] Re: Incompatible column/host variable data type.
Author martijn@pecsforall.com
>
> if the user, lets say, leave the phone field empty, I don't want to
> test it because he/she would get a warning if there's already another
> record without phone.
>

Then it is better to change the select if you do not want to test for
it. Just build the where dynamicly depending on the given information.
No telephone number? Then no telephone in the the where.

Martijn