Entry

Delphi: Database: Create: Table: Data: Type: Which field types (string, ...) can you choose?

Aug 22nd, 2003 17:32
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden - 23 August 2003 - 02:04 am -----------------------

Delphi: Database: Table: Create: Data: Type: Which field types 
(string, ...) can you choose?

Steps: Overview:

 1. -Start Borland Database Desktop (via menu 'Tools')

 2. -Create a new table

 3. -Choose the datatype (press the <spacebar>)

     A = Alpha (e.g. a string 'test')

     N = Number (e.g. a real -0.1234123)

     $ = $ (Money) (e.g. 123.3333 dollar)

     S = Short (e.g. an integer value in a certain range)

     I = long Integer (e.g. an integer value in a certain range)

     # = # (BCD) (=Binary Coded Decimal)

     D = Date (e.g. '08-21-2003')

     T = Time (e.g. '07:00:53')

     @ = @ (timestamp)

     M = Memo (=a .txt file with text)

     F = Formatted memo (=a .doc rtf file with text)

     G = Graphic (=a graphics file)

     O = Ole (=a connection to another program)

     L = Logical (e.g. 0 or 1 or true or false boolean)

   +/- = autoincrement

     B = Binary (e.g. 0 or 1 or true or false)

     Y = bYtes (=a value between -127 and +127, or between 0 and 255)

---

[Internet: see also:
http://www.faqts.com/knowledge_base/view.phtml/aid/23858/fid/175]

----------------------------------------------------------------------