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

2013-08-30 Thread Sven Barth
On 30.08.2013 15:42, silvioprog wrote: 2013/8/29 Michael Van Canneyt mailto:mich...@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.E

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

2013-08-30 Thread silvioprog
2013/8/30 Michael Van Canneyt > On Fri, 30 Aug 2013, silvioprog wrote: > > 2013/8/29 Michael Van Canneyt >> On Thu, 29 Aug 2013, silvioprog wrote: >> >> >> Other interesting feature is the property EmptyAsNull: >> >> http://docwiki.embarcadero.**com/VCL/XE/en/IBCus

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

2013-08-30 Thread Michael Van Canneyt
On Fri, 30 Aug 2013, silvioprog wrote: 2013/8/29 Michael Van Canneyt On Thu, 29 Aug 2013, silvioprog wrote: Other interesting feature is the property EmptyAsNull: http://docwiki.embarcadero.com/VCL/XE/en/IBCustomDataSet.TIBStringField.EmptyAsNull

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

2013-08-30 Thread silvioprog
2013/8/29 Michael Van Canneyt > On Thu, 29 Aug 2013, silvioprog wrote: > > >> Other interesting feature is the property EmptyAsNull: >> >> http://docwiki.embarcadero.**com/VCL/XE/en/IBCustomDataSet.** >> TIBStringField.EmptyAsNull

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

2013-08-30 Thread Mark Morgan Lloyd
Michael Van Canneyt wrote: Not everywhere. In Oracle empty strings are Null (which is why we have special code for this situation in our business application). That's a deviation from the standard. NULL means "we don't know", empty means "we know it is empty" Actually, it means "we don't k

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

2013-08-29 Thread Michael Van Canneyt
On Fri, 30 Aug 2013, Sven Barth wrote: Am 29.08.2013 23:04 schrieb "Michael Van Canneyt" : > > > > On Thu, 29 Aug 2013, silvioprog wrote: > >> >> Other interesting feature is the property EmptyAsNull: >> >> http://docwiki.embarcadero.com/VCL/XE/en/IBCustomDataSet.TIBStringField.EmptyAsNull >

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

2013-08-29 Thread Sven Barth
Am 29.08.2013 23:04 schrieb "Michael Van Canneyt" : > > > > 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

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

2013-08-29 Thread Michael Van Canneyt
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

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

2013-08-29 Thread silvioprog
2013/8/29 silvioprog > 2013/8/29 Michael Van Canneyt > >> On Thu, 29 Aug 2013, silvioprog wrote: >> >> Hello, >>> I'm trying to do something with a dataset, but I think that isn't >>> possible. >>> >>> Assuming I have the following table: >>> >>> create table users ( >>> id serial not null pri

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

2013-08-29 Thread silvioprog
2013/8/29 Michael Van Canneyt > On Thu, 29 Aug 2013, silvioprog wrote: > > Hello, >> I'm trying to do something with a dataset, but I think that isn't >> possible. >> >> Assuming I have the following table: >> >> create table users ( >> id serial not null primary key, >> email varchar(100), >>

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

2013-08-29 Thread Michael Van Canneyt
On Thu, 29 Aug 2013, silvioprog wrote: Hello, I'm trying to do something with a dataset, but I think that isn't possible. Assuming I have the following table: create table users ( id serial not null primary key, email varchar(100), nickname varchar(20) not null ); And the following records:

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

2013-08-29 Thread silvioprog
Hello, I'm trying to do something with a dataset, but I think that isn't possible. Assuming I have the following table: create table users ( id serial not null primary key, email varchar(100), nickname varchar(20) not null ); And the following records: id | email | nickname 1 | us...@domain.c