Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memos in a listbox
Message
De
02/09/2005 11:51:46
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
02/09/2005 11:38:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
01046257
Message ID:
01046262
Vues:
33
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform