Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memos in a listbox
Message
From
02/09/2005 11:51:46
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
02/09/2005 11:38:30
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
01046257
Message ID:
01046262
Views:
34
>I have a listbox containing 2 columns representing 2 fields from a table. The field belonging to the value property of the listbox is a MEMO field. When I try to retrieve the value of the listbox I get the word 'MEMO' rather than the actual content of the memo field. What am I missing?
>
>Thanks for any input.

Use an SQL rowsource. ie:
with myListbox
 .RowSourceType=3
 .RowSource = "Select First_Name-(' '+Last_Name) as Name,left(notes,20) as myNotes,"+;
    "notes,emp_id from employee into cursor crsEmployee"
 .ColumnCount = 2
 .ColumnWidths = "100,300"
endwith

* Where you need memo
lcMemo = crsEmployee.notes
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform