.ParamByName('Name').Value := EmptyStr;

Ben

-----Original Message-----
From: Gediminas [mailto:gugini@...]
Sent: 28 October 2003 16:52
To: ibobjects@yahoogroups.com
Subject: [IBO] ParamEdit


How to force ParamEdit to accept an empty values? I need, that it have ''
value instead of NULL when there is no any text entered

Now empty field sends NULL to SQL query:
select "Name" from Table where "Name" starting with :Name --> empty
dataset, because :Name => NULL, but in SQL
select "Name" from Table where "Name" starting with '' equals to select
"Name" from Table

How to force empty field treat as '' ?



--/ Gediminas /--
The Truth Is Out There



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=194081.4074964.5287182.1261774/D=egroupweb/S=17050071
83:HM/A=1706996/R=0/SIG=11p5b9ris/*http://www.ediets.com/start.cfm?code=3050
9&media=atkins> click here

<http://us.adserver.yahoo.com/l?M=194081.4074964.5287182.1261774/D=egroupmai
l/S=:HM/A=1706996/rand=464501090>

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com <http://www.ibobjects.com> - your IBO community
resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]