how to show MEMO in GRID when use COLUMNFIELDS

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
User avatar
AUGE_OHR
Posts: 2117
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany

how to show MEMO in GRID when use COLUMNFIELDS

Post by AUGE_OHR »

hi,

when have URL they might LEN > 255 so i need a MEMO instead of Type "C"
but in GRID i see only <MEMO> ... :(

how to show Context of MEMO in GRID (or BROWSE) :idea:
have fun
Jimmy
User avatar
Algernon
Posts: 58
Joined: Sat Mar 20, 2010 10:36 am
DBs Used: DBF
Location: Arucas, Gran Canaria, Canary Islands

Re: how to show MEMO in GRID when use COLUMNFIELDS

Post by Algernon »

Something like this
The two fields call [OBSERVACIONES] and [RESPUESTA] are memo fields of the Data Base in the grid above them
Attachments
MemoEnGrid.gif
MemoEnGrid.gif (1.97 MiB) Viewed 3096 times

Javier Suárez

La obra humana más bella es la de ser útil al prójimo. (Sófocles)
The most beautiful work of man is to be useful to others. (Sófocles)
User avatar
AUGE_OHR
Posts: 2117
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany

Re: how to show MEMO in GRID when use COLUMNFIELDS

Post by AUGE_OHR »

hi Mol,
mol wrote: Mon May 23, 2022 5:16 am C type fields can be longer than 255 in Harbour
how much can Type "C" have under harbour :?:

as i do used Source-Code also for Xbase++ i´m not sure if "other" can handle Type "C" > 255
have fun
Jimmy
User avatar
AUGE_OHR
Posts: 2117
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany

Re: how to show MEMO in GRID when use COLUMNFIELDS

Post by AUGE_OHR »

hi,
Algernon wrote: Tue May 24, 2022 7:53 am Something like this
The two fields call [OBSERVACIONES] and [RESPUESTA] are memo fields of the Data Base in the grid above them
Nice ,

Found out that DBU also show "<Memo>" so it seems "by Design"
have fun
Jimmy
User avatar
serge_girard
Posts: 3420
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: how to show MEMO in GRID when use COLUMNFIELDS

Post by serge_girard »

I used to show a substring of Memo fields in grid. Then on doubleclick retrieve complete memo.

S
There's nothing you can do that can't be done...
User avatar
AUGE_OHR
Posts: 2117
Joined: Sun Aug 25, 2019 3:12 pm
DBs Used: DBF, PostgreSQL, MySQL, SQLite
Location: Hamburg, Germany

Re: how to show MEMO in GRID when use COLUMNFIELDS

Post by AUGE_OHR »

hi,
serge_girard wrote: Thu May 26, 2022 7:46 am I used to show a substring of Memo fields in grid. Then on doubleclick retrieve complete memo.
Ah YES
that is what i have "think" of, Thx
have fun
Jimmy
User avatar
Algernon
Posts: 58
Joined: Sat Mar 20, 2010 10:36 am
DBs Used: DBF
Location: Arucas, Gran Canaria, Canary Islands

Re: how to show MEMO in GRID when use COLUMNFIELDS

Post by Algernon »

AUGE_OHR wrote: Wed May 25, 2022 8:06 pm hi,
Algernon wrote: Tue May 24, 2022 7:53 am Something like this
The two fields call [OBSERVACIONES] and [RESPUESTA] are memo fields of the Data Base in the grid above them
Nice ,

Found out that DBU also show "<Memo>" so it seems "by Design"
Yes, Design, I use two memo field in this Data Base and then I use ON CHANGE clause of the GRID to show the content of the memo field

Javier Suárez

La obra humana más bella es la de ser útil al prójimo. (Sófocles)
The most beautiful work of man is to be useful to others. (Sófocles)
Post Reply