xBrowse and lMergeVert

[Maurizio]

Hello Rao
I use oCol:lMergeVert and oCol:WorkMergeData() to activate at runtime lMergeVert and it works fine ,
but is it possible to disable for other conditions?

IF oBrw:oRs:Sort) == 'State'
WITH OBJECT oBrw:State
:lMergeVert := .t.
:WorkMergeData()
END
ELSE
// HOW DO YOU RESTORE WITHOUT lMergeVert ???
ENDIF

Regards
Maurizio

[nageswaragunupudi]

Code: Select all  Expand view  RUN

// cancellation of vertical merge, if already merged
if oCol:lMergeVert
   oCol:lMergeVert := .f.
   oBrw:Refresh()
endif
 

[Maurizio]

Thanks RAO
it works very well .
is it possible to have a sub total for each merge?

Maurizio

[nageswaragunupudi]

Possible, but you need to do more work.
Please search the forums for samples I posted showing subtotals with mergecols.

May I know if you are using ADO with MySql or MSSql or other database?

[Maurizio]

I use ADO
Maurizio

[nageswaragunupudi]

I use ADO
Maurizio

It is clear to me that you are using ADO. But with what database? MySQL or MSSQL or Oralce? what database?
I am asking because SQL syntax can vary a little between different databases.

[Maurizio]

I use Mysql
Maurizio