topic-39922

Posts: 842

Joined: Mon Oct 10, 2005 01:29 PM

xBrowse and lMergeVert
Posted: Tue Feb 02, 2021 02:22 PM

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

Maurizio
www.nipeservice.com

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: xBrowse and lMergeVert
Posted: Tue Feb 02, 2021 05:18 PM

Code (fw): Select all Collapse

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

Regards

G. N. Rao.

Hyderabad, India

Maurizio

Posts: 842

Joined: Mon Oct 10, 2005 01:29 PM

Re: xBrowse and lMergeVert
Posted: Wed Feb 03, 2021 09:36 AM

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

Maurizio

Maurizio
www.nipeservice.com

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: xBrowse and lMergeVert
Posted: Wed Feb 03, 2021 09:45 AM

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?

Regards

G. N. Rao.

Hyderabad, India

Maurizio

Posts: 842

Joined: Mon Oct 10, 2005 01:29 PM

Re: xBrowse and lMergeVert
Posted: Wed Feb 03, 2021 10:28 AM

I use ADO
Maurizio

Maurizio
www.nipeservice.com

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: xBrowse and lMergeVert
Posted: Wed Feb 03, 2021 11:47 AM

Maurizio wrote: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.

Regards

G. N. Rao.

Hyderabad, India

Maurizio

Posts: 842

Joined: Mon Oct 10, 2005 01:29 PM

Re: xBrowse and lMergeVert
Posted: Fri Feb 05, 2021 08:27 AM

I use Mysql
Maurizio

Maurizio
www.nipeservice.com

FiveTech Support Forums

Continue the discussion