Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo field in combo box
Message
From
26/07/2000 17:04:03
 
 
To
26/07/2000 16:54:56
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00396895
Message ID:
00397326
Views:
13
at the command window (i am using VFP6), if i sql custid,custname,comments into array atemp, i can see that atemp(3) contains the memofield data. i change the rowsourcetype to 5 but still can't transfer the its data to column3 of the grid. column3 contains a editbox already. the memofield contains the given tour itinerary by the provider. i need to transfer this info to the grid column so that the user can edit the itinerary for packaging to inward bound tourists. is there anything else i could try? tks

Select into a cursor instead, then you can access the cursor's memo field directly, since the record pointer in the RowSource cursor moves accordingly as an item is selected in the combobox. e.g.,
SELECT custid, custname, comments, LEFT(comments,100) As combocomments ;
 FROM table ;
 INTO CURSOR cu_rowsource
Combo.RowSourceType = 6 && fields
Combo.RowSource = "cu_rowsource.custid, custname, combocomments"

** Combo.Valid(), e.g.
** to get memo field
thisform.Edit1.Value = cu_rowsource.comments
Insanity: Doing the same thing over and over and expecting different results.
Previous
Reply
Map
View

Click here to load this message in the networking platform