🚀 go-pugleaf

I am afraid not.

-- 
-oj
http://www.rac4sql.net


"mac" <mac@hotmail.com> wrote in message
news:4MNYb.43806$1S1.11670@nwrddc01.gnilink.net...
> Thanks for your reply.
>
> Ok, suppose I have a select statement and am selecting desc which is memo
> field, can I use do while in the select statement in SQL2K to read all the
> lines in the memo field to a text variable ?
>
> Thanks.
>
>
> "oj" <nospam_ojngo@home.com> wrote in message
> news:eXpTKfa9DHA.2752@TK2MSFTNGP09.phx.gbl...
> > It would be a multi step process. You read the data into a stream and
> > bulkload it into sqlserver database. AFAIK, there isn't a direct way to
> > convert VFP memo type to SQL text type.
> >
> > --
> > -oj
> > http://www.rac4sql.net
> >
> >
> > "meh" <mac@hotmail.com> wrote in message
> > news:4XsYb.19148$5W3.6763@nwrddc02.gnilink.net...
> > > I have database in SQL2K and program in VFP.
> > > My select statement is
> > >
> > >
> > > SELECT PARTNO, DESC, QTY, PRICE
> > >
> > > I save above selection into cursor.   DESC is a memo field.  I want to
> use
> > > this selection and copy to excel file.
> > > All other fields are copying except DESC and that is memo field.
> > >
> > > How can I copy/convert DESC field to text while selecting records so I
> can
> > > import into excel file ?
> > >
> > > Thanks.
> > >
> > >
> >
> >
>
>