🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #2496

Re: Creating a memo field

#2496
From: Viatcheslav V. Vassiliev
Date: Mon, 02 Jun 2003 15:52
52 lines
2823 bytes
Memo - adLongVarWChar = 203,
Blob - adLongVarBinary = 205.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"B Wilson" <bobknows@netzero.net> �������/�������� � �������� ���������:
news:3edb5889@newsgroups.borland.com...
> For instance, adInterger has a value of 8 and adVarBinary is 204. I was
> wondering if there was a option for memo or BLOB field or is the only way
to
> add a memo to a table is with the code you are showing below?
>
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
> news:3edb2881@newsgroups.borland.com...
> > I did not understood what you mean but you can create table with  memo
> > column with SQL DDL:
> >
> > Create table [TableName] ([Col1] Memo)
> >
> > ----------------------------------------------------------------
> > Regards,
> > Viatcheslav V. Vassiliev
> > http://www.oledbdirect.com
> > The fastest way to access MS SQL Server, MS Jet (MS Access)
> > and Interbase (through OLEDB) databases.
> >
> > "B Wilson" <bobknows@netzero.net> �������/�������� � �������� ���������:
> > news:3edafcf8$1@newsgroups.borland.com...
> > > Hi,
> > >     I am creating a access database at runtime and I am unable to
create
> a
> > > memo field.  I have been unable to locate the value of memo on the
> > microsoft
> > > website.  Could someone let me know what it is or where I can find it
or
> > am
> > > I going about it the wrong way?  Thanks
> > >
> > > Bob
> > >
> > >
> >
> >
>
>
Technical Details
Message-ID: <3edb7432@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!sn-xit-09!supernews.com!news-out.visi.com!petbe.visi.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail
References: <3edafcf8$1@newsgroups.borland.com> <3edb2881@newsgroups.borland.com> <3edb5889@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,33b8e9174cd9083f
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-06-02 09:01:30 PST
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3edafcf8$1@newsgroups.borland.com> <3edb2881@newsgroups.borland.com> <3edb5889@newsgroups.borland.com>
Subject: Re: Creating a memo field
Date: Mon, 2 Jun 2003 19:52:50 +0400
Lines: 54
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 213.247.201.57
Message-ID: <3edb7432@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1054569522 213.247.201.57 (2 Jun 2003 08:58:42 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!sn-xit-09!supernews.com!news-out.visi.com!petbe.visi.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail