Friday, February 4, 2011

Re: [firebird-support] Re: Incompatible column/host variable data type.

 


>
> 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

__._,_.___
Recent Activity:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.


Find useful articles and helpful tips on living with Fibromyalgia. Visit the Fibromyalgia Zone today!

.

__,_._,___

No comments: