Results 1 to 4 of 4

Thread: SQL Var types question

  1. Dec 10th, 2003, 06:16 AM #1
    Matt_T_hat
    Matt_T_hat is offline

    Thread Starter
    Fanatic Member Matt_T_hat's Avatar
    Join Date
    Dec 2001
    Location
    '76 Male Body Evil-Errors: 666
    Posts
    774

    SQL Var types question

    Here is a line of code from a function from an MS Access 2000 DB I am working on.
    VB Code:
    1. DoCmd.RunSQL "ALTER TABLE tester ADD Notes memo"
    I know I can use VarChar, Int, Currency, and probably others.

    Q1. Where can I see a full list of types I can use?
    Q2. Failing that any one know what the type is for a Yes/no (boolean) field is?
    ?
    'What's this bit for anyway?
    For Jono
    Reply With Quote Reply With Quote
  2. Dec 10th, 2003, 07:11 AM #2
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170
    Don't you have access?

    It's YES/NO from the GUI Design View, and in an SQL String that would be BOOLEAN.
    Reply With Quote Reply With Quote
  3. Dec 10th, 2003, 07:57 AM #3
    peet
    peet is offline
    -= B u g S l a y e r =- peet's Avatar
    Join Date
    Aug 2000
    Posts
    9,629
    VB Code:
    1. 'TEXT

    2.         'MEMO

    3.         'LONG

    4.         'TINYINT

    5.         'SMALLINT

    6.         'INTEGER

    7.         'REAL

    8.         'FLOAT

    9.         'DECIMAL

    10.         'DOUBLE

    11.         'COUNTER

    12.         'BIT

    13.         'YESNO

    14.         'DATE
    -= a peet post =-
    Reply With Quote Reply With Quote
  4. Dec 10th, 2003, 08:26 AM #4
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170
    hmm... maybe I had it confused?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width