Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Erik Gomez
  Where is Erik Gomez?
 Victorias City, Negros Occidental
 Erik Gomez
 To: mike castillo
  Where is mike castillo?
 Joo Seng Road, Singapore
 mike castillo
Subject: RE: SQL
Thread ID: 22259 Message ID: 22262 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Monday, April 14, 2003 6:45:15 AM         

> what is the correct syntax in:
>  Select memo as MyMemo from table1 into cursor MyTable1

> I want to add a memo field such as memo as MyMemo, like for example:
> Select Spaces(254) as Mytext from table1 into cursor MyTable1

hi mike,
I'm not sure if this is what you want. the code below will create a cursor with all fields from a table (table1) plus a new field of memo type.
Create Cursor cursMemo (fldmemo m)
Select all table1.*,cursMemo.fldmemo as myMemo;
	from table1 left join cursMemo on .t.;
	into cursor withMemo readwrite

hope this helps,
Erik Gomez
www.foxite.com - The Home of The Visual FoxPro Experts
Long Live www.foxite.com


SQL Posted by mike castillo @ 4/14/2003 2:05:36 AM
RE: SQL Posted by Erik Gomez @ 4/14/2003 6:45:15 AM