Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How Do I Create a MEMO Field Using the SQL CREATE

    How Do I Create a MEMO Field Using the SQL CREATE TABLE?

    I am trying to make tables with Memo fields using the SQL CREATE TABLE statement; what do i use as the key word? I know to use TEXT for text fields (up to 255 chars), but i cannot find anywhere how to create Memo fields;

    Do i need to use ADO? What is the How-To?

    Thank you!

    --llyal

    CREATE TABLE tblFriends
    (FriendID INTEGER NOT NULL,
    LastName TEXT(50) NOT NULL,
    FirstName TEXT(50) NOT NULL,
    Phone TEXT(10),
    Email TEXT(50),
    Notes MEMO?(???));

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How Do I Create a MEMO Field Using the SQL CREATE

    You're trying too hard. Just use MEMO and close the parens. The size of the memo field is a predefined maximum, so you don't pass it any size parameter.
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How Do I Create a MEMO Field Using the SQL CREATE

    The use of the MEMO in CREATE TABLE causes error; I have learned that one is to use LONGTEXT to create a memo field with CREATE TABLE; I wish i knew how the person who helped me found this information!

    --llyal

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How Do I Create a MEMO Field Using the SQL CREATE

    It may be version specific. I had no problems using the MEMO datatype in a DDL CREATE TABLE statement to create a memo field in new table. I'm running Access 2000, which may make the difference. Oh, and I'm also running Jet 4.0 SP5, which probably does make a difference.
    Charlotte

Posting Permissions

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