Board index » off-topic » Re: ClientDataSet assumes EmptyStr for "blank" dbEdits

Re: ClientDataSet assumes EmptyStr for "blank" dbEdits


2006-02-15 10:12:51 PM
off-topic19
Anderson Farias wrote:
Quote
I've noticed (on D7) that whenever you edit a string field (using
something like a TDBEdit linked to the CDS) setting it to "blank" the
CDS set the field value to emptyString ('') istead of NULL as other
dataSets do.

Why is that? Is that any way to fix this behavior??
1) It is *not* the case that "other datasets" necessarily set strings
NULL; the BDE datasets, for example, do not. IBX, OTOH, is different,
and behaves as you describe. So it's really up to the implementor;
there is no consistency.
2) For a variety of workarounds, look at the newsgroup archives:
www.google.com/search
--
Craig Stuntz [TeamB] ?Vertex Systems Corp. ?Columbus, OH
Delphi/InterBase Weblog : blogs.teamb.com/craigstuntz
Please read and follow Borland's rules for the user of their
server: support.borland.com/entry.jspa
 
 

Re:Re: ClientDataSet assumes EmptyStr for "blank" dbEdits

Hi,
I've noticed (on D7) that whenever you edit a string field (using something
like a TDBEdit linked to the CDS) setting it to "blank" the CDS set the
field value to emptyString ('') istead of NULL as other dataSets do.
Why is that? Is that any way to *fix* this behavior??
Thanks for any help,
Regards,
Anderson
 

Re:Re: ClientDataSet assumes EmptyStr for "blank" dbEdits

1) It is *not* the case that "other datasets" necessarily set strings
Quote
NULL; the BDE datasets, for example, do not. IBX, OTOH, is different,
and behaves as you describe. So it's really up to the implementor;
there is no consistency.
Thanks for clarifying :-)
Quote
2) For a variety of workarounds, look at the newsgroup archives:

www.google.com/search
This behavior is getting me on some problems. I'll look for the workarounds
you pointed me out. Many thanks Craig.
Regards,
Anderson
 

{smallsort}