Interbase datatypes...

Interbase datatypes...

Post by Jan » Fri, 29 Sep 2000 08:13:15



Hi

Is there a way to create a boolean field in Interbase, and use it in Delphi
with .AsBoolean?
I now its possible to create new datatypes in Interbase, but I don 't now
how.

Tanks
        Jan

 
 
 

Interbase datatypes...

Post by Concep » Sun, 31 Dec 1899 09:00:00


Here's what I do

Make the interbase column a Word value.  Then relate to it as a borland
pascal type Wordbool.  This way the value is false when 0, but when true
could also hold a meaningful value.  This duality becomes useful in a well
designed database.

Hope this helps...

Cheers

Anthony


Quote:> Hi

> Is there a way to create a boolean field in Interbase, and use it in
Delphi
> with .AsBoolean?
> I now its possible to create new datatypes in Interbase, but I don 't now
> how.

> Tanks
>         Jan


 
 
 

Interbase datatypes...

Post by Robert Kapla » Sun, 31 Dec 1899 09:00:00


Good solution, could come in handy even if the database does support
boolean.

Robert


> Here's what I do

> Make the interbase column a Word value.  Then relate to it as a borland
> pascal type Wordbool.  This way the value is false when 0, but when true
> could also hold a meaningful value.  This duality becomes useful in a well
> designed database.

> Hope this helps...

> Cheers

> Anthony



> > Hi

> > Is there a way to create a boolean field in Interbase, and use it in
> Delphi
> > with .AsBoolean?
> > I now its possible to create new datatypes in Interbase, but I don 't
now
> > how.

> > Tanks
> >         Jan

 
 
 

1. Interbase VARCHAR datatype

What's the overhead of VARCHAR datatypes? If I define a field as
VARCHAR(10000) and store a one-character string in it, how much space
(approximately) is taken up? I'm trying to decide whether to use a BLOB
field or a large VARCHAR field for my application.

Is this the best place for Interbase questions/discussion? I couldn't see a
news group for Interbase.

Thanks.
-------------
Keith Edmunds
Reading,   UK
-------------

2. US-NJ: Monmouth-Oracle DBA

3. interbase to SQL server using DTS via Interbase ODBC driver

4. ool test

5. Reading InterBase files without InterBase ?

6. Consultant needed - mvBase and an AS400

7. Help -- Interbase Performance moving from paradox --> Interbase

8. How to drop all default constrants for a table

9. Interbase Error: Connection Reset By Interbase Server???

10. Interbase Workgroup & Interbase Local databases

11. ANN: Interbase Sukkel, THE Tool for Interbase Developers

12. Local interbase is fast, what about Interbase server?