Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>>>I use SQL select to create a cursor, then direct it to the recordsource of the grid.
>>>Unfortunately, the cursor contain memo field. I attemp to view the content of the memo field of the grid, when I double click on the grid's cell 'memo'. But nothing happen, something missing?
>>
>>You have to: either use editbox as a grid.column.currentcontrol or use commandbutton with some code in click() event.
>
>Are you doing ODBC with any other database? In that case make sure Fetchmemo cursor property is set to True
>
>Narendra
Jasper, try this:
SELECT PADR(memofieldname,100) AS memofieldname ... INTO ...
(change memofieldname with the original fieldname)
This will construct a character field from the memo field. The PADR function sets a constant width for the field.
Nelson
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement