xBrowse and Mysql

[TOTOVIOTTI]

Mr Nages,
how to in xbrowse:

REDEFINE XBROWSE oBrw ID 100 DATASOURCE oQuery ;
HEADERS "Fecha","Motivo" ;
COLUMNS "FECHA",{|| myfunction(oQuery:CODIGO)} ; //where myfunction is a function external
JUSTIFY AL_CENTER,AL_LEFT ;
COLSIZES 60,200 ;
LINES CELL NOBORDER OF oDlg
oDlg:oClient:=oBrw

It can be done?

Regards
Roberto

[nageswaragunupudi]

Yes.

You can intermix codeblocks in the COLUMNS clause if you are using any recent version of FWH.


If you are using an older version where codeblocks are not allowed, I suggest this workaround.

First specify the COLUMNS CLAUSE with some column name for the second column also.

After that you assign codeblock to the oCol:bEditValue.

Example:
oBrw:aCols[ 2 ]:bEditValue := { || ........your codeblock }
Also assign :cEditPicture if required and assign :cHeader

Alternatively, you can use
ADD TO oBrw DATA (your func) HEADER .... etc

[TOTOVIOTTI]

Mr. Nages
Thank you very much!
Roberto