Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Transfer DBase 7 tables to Interbase....

0 views
Skip to first unread message

Jan

unread,
Jun 13, 2000, 3:00:00 AM6/13/00
to
I want to transfer DBase 7 tables to Interbase.
The problem is that most of the tables uses 1 or more boolean - fields.
Now, Interbase don 't support boolean, but the application use this
boolean-fields
very frequent.
Is there a field-type in Interbase that I can read and write as AsBoolean in
a Delphi-application?

Thanks.....

Rob Segerink

unread,
Jun 14, 2000, 3:00:00 AM6/14/00
to
Hi Jan,

replace the boolean fields to a integer type and use
0 and 1.

greetings,

Rob Segerink

Jan wrote in message <3946a071$0$11...@bru5-newsr1.be.uu.net>...

Sébastien MERIC

unread,
Jun 14, 2000, 3:00:00 AM6/14/00
to

Jan a écrit :

> I want to transfer DBase 7 tables to Interbase.
> The problem is that most of the tables uses 1 or more boolean - fields.
> Now, Interbase don 't support boolean, but the application use this
> boolean-fields

may be you should just create some domain in your interbase db so it anderstands
boolean the same way it does for db7

>
> very frequent.
> Is there a field-type in Interbase that I can read and write as AsBoolean in
> a Delphi-application?
>
> Thanks.....

--
Sébastien MERIC
Ste Galbord,
23 rue Edouard Nieuport
92150 Suresnes
tél (+33) 1 44 14 15
fax (+33) 1 44 01 03

Nikolay Mokhnatov

unread,
Jun 14, 2000, 3:00:00 AM6/14/00
to
In article <3946a071$0$11...@bru5-newsr1.be.uu.net>,

"Jan" <bro-...@village.uunet.be> wrote:
> I want to transfer DBase 7 tables to Interbase.
> The problem is that most of the tables uses 1 or more boolean -
fields.
> Now, Interbase don 't support boolean, but the application use this
> boolean-fields
> very frequent.
> Is there a field-type in Interbase that I can read and write as
AsBoolean in
> a Delphi-application?


Try to use IB Objects. (http://www.ibobjects.com). This excellent
product may emulate boolean columns by defining "true" and "false"
values for any domain. As example, you can define domain "tbool" as
integer, and <TIBODatabase.ColumntAttributes='boolean=tbool=1,0'>.
After this declaration, fields declared by "tbool" will be created as
TBooleanField.

--
Homepage: http://www.tfsoft.f2s.com (articles, freeware, shareware,
links)
E-Mail tfs...@hotmail.ru

Sent via Deja.com http://www.deja.com/
Before you buy.

Nikolay Mokhnatov

unread,
Jun 14, 2000, 3:00:00 AM6/14/00
to
0 new messages