Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Biju Thomas
  Where is Biju Thomas?
 Kochi
 India
 Biju Thomas
 Tags
Subject: SQL & Memo Fields
Thread ID: 155413 Message ID: 155413 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: General VFP Topics
Date: Monday, December 31, 2007 8:12:15 PM         
   


Dear Friends,
Happy New Year and many many returns of the day.

When I tried to execute the following code –

Select Alltrim(TA.MA_comnt1) As f2 From TA Into Cursor comnt1

VFP 8 returns the Error Message ‘ string is too long to fit

Here
TA is a cursor

TA.MA_comnt1 is a Memo field

The cursor is populated with the command –
csql ='SELECT * from My_Table where My_Table.Ur_Id = ‘1’
=SQLEXEC(conntstring,csql,”TA”)

There will be only one record in the cursor

Please help.
With Regards,
Biju Thomas

ENTIRE THREAD

SQL & Memo Fields Posted by Biju Thomas @ 12/31/2007 8:12:15 PM
RE: SQL & Memo Fields Posted by Yuri Rubinov @ 12/31/2007 8:54:15 PM
RE: SQL & Memo Fields Posted by Biju Thomas @ 1/1/2008 5:04:12 AM
RE: SQL & Memo Fields Posted by Ken Murphy @ 1/1/2008 3:48:56 PM
RE: SQL & Memo Fields Posted by Yuri Rubinov @ 1/2/2008 1:45:24 AM