[fpc-pascal] How to clear the value of a field in a table using parameters?

[Sven Barth]

Am 29.08.2013 23:04 schrieb "Michael Van Canneyt" <michael at freepascal.org>:
>
>
>
> On Thu, 29 Aug 2013, silvioprog wrote:
>
>>
>> Other interesting feature is the property EmptyAsNull:
>>
>>
http://docwiki.embarcadero.com/VCL/XE/en/IBCustomDataSet.TIBStringField.EmptyAsNull
>>
>> It tests if field (ftString) is empty (f = ''), if yes, it set the field
value to null (f.Clear).
>
>
> Apparently a IBX specific extension.
>
> I don't see the value of this. empty and null are different things.

Not everywhere. In Oracle empty strings are Null (which is why we have
special code for this situation in our business application).

Regards,
Sven
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-pascal/attachments/20130830/d9a315fe/attachment.html>