EDatabaseError possible Delphi bug???

From: Piedro Mazolo (pmazolo_at_hotmail.com)
Date: 06/26/04 

Date: Sat, 26 Jun 2004 13:01:20 +0200

Hi!

I am getting a really strange EDataBaseError..."Cannot access filed xxx as
integer."

in the Access database:

zzz boolean
yyy boolean
xxx boolean

the error comes when I try

ADODATASET.Edit;
test:=ADODATASET.FieldByName('xxx').Asboolean;
ADODATASET.FieldByName('xxx').Asboolean:=True; // --> EDataBaseError

the really strange thing is that I can READ xxx asboolean, and yyy and zzz I
can even WRITE without getting this error!!!

Is this me doing something wrong, a Delphi bug, or could the program in
someway corrupt itself...? The database looks OK and works fine in Access...

I am using D7 and Access 2000.

Rgds
/P.M.

Relevant Pages

  • Re: EDatabaseError possible Delphi bug???
    ... That should have read "Cannot access field 'xxx' as integer." ... > I am getting a really strange EDataBaseError..."Cannot access filed xxx as ... > in the Access database: ... > zzz boolean ...
    (borland.public.delphi.database.ado)
  • Re: EDatabaseError possible Delphi bug???
    ... I've used AsBoolean with ADO access successfully doing just what you have ... > I am getting a really strange EDataBaseError..."Cannot access filed xxx as ... > in the Access database: ... > zzz boolean ...
    (borland.public.delphi.database.ado)
  • Re: [PATCH] mtrr use type bool
    ... This seems a bit strange, using a boolean as an integer. ... if (increment) ... many places had/have some sort of a = b? ...
    (Linux-Kernel)
  • Re: Mass delete files and directories
    ... Strangely, all VB samples I can find have that field as Long, so I'm honestly not sure why I have it as Boolean myself! ... Size-wise it makes no difference, ... A short test program to all four testers produced a Copy, Move, and Delete on three machines, and three failures on the one machine. ... I am beginning to wonder if maybe the OS on his machine might be something like Win2K or W98 with a strange version of the "shell32" library. ...
    (microsoft.public.vb.general.discussion)
  • Re: Passing arguments to function - (The fundamentals are confusing me)
    ... Sharing an arbitrary boolean, without any context, is rather strange -- perhaps it would be best to include both the boolean and associated context in a single, larger object. ...
    (comp.lang.python)