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
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
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
Robert
> 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
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
-------------
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?