FiveTech Software tech support forums

Wondering how can I test this program at my end.

Hi Guys, I have a xbrowse built over a mysql rowset and using lMergeVert. It´s working fine. Always I try to do an oRs:Requery() to update data. Is Happening the error bellow: Compiler version: Harbour 3.2.0dev (r2008190002)   FiveWin  Version: ...

... := LINESTYLE_BLACK olbx1:lallowrowsizing :=.f. olbx1:setcolor(rgb(0,0,0),rgb(255,255,206)) olbx1:nRowHeight := 27 oLbx1:acols[1]:lMergevert:=.t. Imagen https://drive.google.com/file/d/1BZfNI0KHL-ax-1n5aYod_eDHdac1lvnR/view?usp=drive_link Video https://drive.google.com/file/d/1G131QdddbjINqfsnZu58CVGpHSjiqoQ9/view?usp=drive_link

Al usar el lmergevert me da este problema de despliege, al darle click sobre la pantalla se corrige el error, o existe
alguna solucion

https://drive.google.com/file/d/1OgBshen8CbmOsr4kgf4GK-pr8ChVVD8a/view?usp=sharing

Al usar el lmergevert me da este problema en la pantalla, solo se corrige dandole un click, se reordena todo,,, se podra solucionar este problema https://previews.dropbox.com/p/thumb/ACAC_FGBx_nli7ejOomW_U7ivZuPWZuN4DOMjIRTs0Teiy7WbCl2pttVB9cSlii6RgcdX-1Vn8SYn-v7k0IXDos9mRRJHcfP2ce2pjEIuFSXAUlmHradkMLgYnbODpXYvpvflxMQYS-2Ot5MlDSBk0P9kAwoUS3J6WyUnJV_uHNN1m0c_IAgUXi7wb4m-TkeHKJpdFq1zT02_EyJqwv65Q_VnJOYI-lJuHdPafRjwmIWkPVdlX8omIYrC2KTMHOHswrhWd3YzPv14gm4IZnTHuEY8jRapxtGXJyxGPlS_qblp7NDtiWuzWnt5LWcvrEJnLvoOrwinoJfft21K5g1HzZ9/p.jpeg

I use Mysql
Maurizio

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.

I use ADO
Maurizio

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?

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

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. ...

... crei entender como funcionaba, y lo probe. http://forums.fivetechsupport.com/viewtopic.php?f=3&t=28543&p=159813&hilit=lmergevert#p159813 A primera vista funcionaba perfecto, pero cuando dos albaranes correlativos eran de la misma fecha, o del mismo importe, tambien ...

Estoy usando lMergeVert y no me "repinta" bien cuando cambio de OBRA entre líneas: Me explico La obra 490 tiene 3 Presupuestos La obra 492 tiene 4 Presupuestos En la Imagen 1 se ve como la Columna OBRA del segundo BROWSE ...

... https://onedrive.live.com/redir?resid=400B40E524721DF9!15516&authkey=!AAVMvSVo78mZ8Ks&v=3&ithint=photo%2cjpg Yes. Very simple oCol:lMergeVert := .t. Please see sample \fwh\samples\testmerg.prg http://imagizer.imageshack.us/v2/xq90/924/3JFUtR.png