Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid & memo
Message
From
11/05/2002 23:29:19
Rene Van Den Berg
Infertility Database Systems Ltd
Islington, United Kingdom
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00655452
Message ID:
00655468
Views:
22
>>Well, assuming you're filling the grid via a SQL statement (although it's probably possible to do it straight from the table as well), you would e.g. do the following for your memo field called yourmemo:
>>
>>SELECT id, name, ALLT(MLINE(yourmemo,1))+ALLT(MLINE(yourmemo,2)) as yournewmemo FROM yourtable etc....
>>
>>To make sure, you could include lots of lines of the memo field so you don't miss anything in the grid, but I assume that in practice this is not always needed.
>>
>>Hope this helps.
>>
>>Rene.
>
>The original idea was to make this field editable in the grid. I don't think, your idea will allow to edit content of the memo.

Not unless you create another data entry form where you can edit the field (but you may not want this). This does not only apply to this field, but could to others as well. I've done this with an application where I fill the grid using a SQL statement. When the user wants to edit a field, they double click. A simple data entry form appears where they can change the data. The data type if trapped before the form is launched so that the appropriate field type can be displayed on the form. When the data are saved, the record is located and the field value replaced in the table.
Previous
Reply
Map
View

Click here to load this message in the networking platform