Subject | ParamEdit |
---|---|
Author | Gediminas |
Post date | 2003-10-28T16:52:19Z |
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
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