Re: ORACLE 8i & DELPHI 5

Hello Fred!

Well I haven't used the 'isNull' property. Maybee it is like variables in Delphi, if they are undefined they can return any value.

You might work around the problem like this:

if (trim(DataSet.fieldbyname('MY_MONTH').AsString) <> '') ...

-Carl

In article <90qkp8$s41$1_at_s1.read.news.oleane.net>,   "cne valentin" <delprog_at_bdi-emat.terre.defense.gouv.fr> wrote:
> Hello Carl,
>
> This is a exemple of my code :
>
> if (not (DataSet.fieldbyname(MY_MONTH').isnull ) and
> not (DataSet.fieldbyname('MY_YEAR').isnull)) then
>
> DataSet.FieldByName('END_DATE').asstring :=
> LibMonth(DataSet.fieldbyname('MY_MONTH').AsInteger)+' '+
> (DataSet.fieldbyname('MY_YEAR').AsInteger);
>
> The function 'LibMonth' returns the name of the month when I give the
 number
> of the month.
>
> With an skill in Oracle, we have tried differents solutions.
>
> 1 - when we write that :
> DataSet.FieldByName('END_DATE').asstring := 'aaaaaaaaaaa';
> .... no probleme
>
> 2 - when we write that :
> DataSet.FieldByName('END_DATE').asstring :=
> DataSet.fieldbyname('MY_YEAR').AsInteger;
> ...... Error : 'Operation en virgule flottante incorrecte'
>
> that's all !
>
> I am afraid that in Delphi a null value is not understood like that.
> Sometimes it gives me 0 whereas in Oracle the value is null !!!
>
> Maybe my code is wrong ....
> Thank for your help because I must deliver my application Monday 18
 th.
>
> Thanks
> Fred.
>
> <c_joh_at_my-deja.com> a écrit dans le message : 90q9k7$469
 $1_at_nnrp1.deja.com...
> > Can you give an example of your code?
> >
> > I have never seen anything like that. Would be intresting to find
 out
> > why.
> >
> > -Carl
> >
> >
> > In article <90q441$k1n$1_at_s1.read.news.oleane.net>,
> > "cne valentin" <delprog_at_bdi-emat.terre.defense.gouv.fr> wrote:
> > > Hello
> > >
> > > I am working with Delphi 5 and Oracle 8.1.6. In my database i have
 got a
> > > filed which is Null.
> > > When i am testing this value in my programme, Delphi returns
 either
 null or
> > > 0 or something completly made as 6542454645645.213 E-312
> > >
> > > That problem is random.
> > > What can I do
> > > Thanks. Fred
> > >
> > >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 08 2000 - 13:43:06 CST