How Do I Create a MEMO Field Using the SQL CREATE

Topic

New Reply

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?(???));

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote