Re: Creating a table with multiple key and boolean fields in SQL
- From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
- Date: Mon, 25 Jul 2005 20:21:11 -0500
>It is something like
>CREATE TABLE MyTable (Field1 INTEGER, Field2 INTEGER, .... FieldX BOOLEAN)
>
>but "Boolean" is wrong and Integer gives me LongInt fields.
Use Logical or Bit for boolean type
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.
- References:
- Creating a table with multiple key and boolean fields in SQL
- From: Dave Blake
- Creating a table with multiple key and boolean fields in SQL
- Prev by Date: Re: Either BOF or EOF is True - MDAC 2.8 - Delphi 6 SP3 - SQL2000 - Win XP
- Next by Date: Re: Either BOF or EOF is True - MDAC 2.8 - Delphi 6 SP3 - SQL2000 - Win XP
- Previous by thread: Re: Creating a table with multiple key and boolean fields in SQL
- Next by thread: Create A Table From A FieldList?
- Index(es):