Subject RE: [IBO] ParamEdit
Author Ben Sollis
.ParamByName('Name').Value := EmptyStr;


-----Original Message-----
From: Gediminas [mailto:gugini@...]
Sent: 28 October 2003 16:52
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


9&media=atkins> click here


IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ <> - 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
<> .

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