Memo and DBGrid
Posted: Thu 17 Mar 2022 13:00
Hi,
I use some DBGrid to show memos field.
If I done this :
SELECT CAST(SUBSTR(My_memo,0,255) AS VARCHAR2(255)) AS My_Memo_txt FROM My_table
It works with TUniQuery but with TVirtualQuery the only thing I have in my DBGrid is '(memo)'.
Is there anything to do with VirtualQuery, for now I use calculated field but if you have another solution.
Regards
I use some DBGrid to show memos field.
If I done this :
SELECT CAST(SUBSTR(My_memo,0,255) AS VARCHAR2(255)) AS My_Memo_txt FROM My_table
It works with TUniQuery but with TVirtualQuery the only thing I have in my DBGrid is '(memo)'.
Is there anything to do with VirtualQuery, for now I use calculated field but if you have another solution.
Regards