Re: How to convert/copy memo field to text ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: mac (mac_at_hotmail.com)
Date: 02/18/04 

Date: Wed, 18 Feb 2004 18:01:36 GMT

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.
> >
> >
>
>

Relevant Pages

  • Re: multi line combo boxes
    ... I was afraid of that (I didn;t notice that it only allowd 255 characters ... >> In Access 2003 I have created a combo box that is linked to a memo ... > the selection you are only getting the first 255 characters from your memo ... > You can use DLookupto retrieve the full Memo field into another TextBox after ...
    (microsoft.public.access.forms)
  • Re: multi line combo boxes
    ... bumpmobile wrote: ... > In Access 2003 I have created a combo box that is linked to a memo ... the selection you are only getting the first 255 characters from your memo ... You can use DLookupto retrieve the full Memo field into another TextBox after ...
    (microsoft.public.access.forms)
  • Newbie question about TMemo
    ... I'd like the Memo control on my app to act like the IE Address bar.. ... change the URL) but then if you click into the selection, ... when I slap a memo on a form I can get the Control-a ... the event handler and 'a' has a key code of 65--Ord--rather than ...
    (comp.lang.pascal.delphi.misc)
  • How do I print ONLY the first page of a 10 page memo?
    ... memo. ... The only selection in the printing page options are ... This problem cannot be fixed by defining or creating ... the print style menu. ...
    (microsoft.public.outlook.general)