Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Pennsylvania - United States
 Yuri Rubinov
 To: Biju Thomas
  Where is Biju Thomas?
 Biju Thomas
Subject: RE: SQL & Memo Fields
Thread ID: 155413 Message ID: 155418 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: General VFP Topics
Date: Monday, December 31, 2007 8:54: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

It is not clear, what do you want to get with the call like:

Select Alltrim(memo_field) as field_name .... ?

Why not just:

Select memo_field as field_name ....

Other than that, here are a few things to consider:
First of all, the field_name length is not drfinrd, then who knows what will be its actual length, and whether it will be enough to store the longest value from the table.
Secondly, with Alltrim(memo_field) one gets the character field, not memo, and the maximum length for the character field is 255.

Best Wishes,

Yuri Rubinov


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