agrupar datos en browse box
agrupar datos en browse box
(OP)
necesito agrupar datos en un browse box para que en el caso de que tenga 2 o mas lineas con el mismo dato en vez de aparecer 2 veces , solo aparezca una con el total de unidades. ej: tengo 5 articulos "a" y 1 articulo "b", en vez de aparecer :
1 a 1 unidad
2 a 1 unidad
3 a 1 unidad
4 a 1 unidad
5 a 1 unidad
6 b 1 unidad
que aparezca:
1 a 5 unidad
2 a 1 unidad
alguien sabe como puedo hacerlo???
1 a 1 unidad
2 a 1 unidad
3 a 1 unidad
4 a 1 unidad
5 a 1 unidad
6 b 1 unidad
que aparezca:
1 a 5 unidad
2 a 1 unidad
alguien sabe como puedo hacerlo???
RE: agrupar datos en browse box
I do not know Spanish but I assume that the above is the correct English translation (courtesy of Google Translate).
Send me the actual Browse view/queue definition and I will try to explain the solution to you. Are you using ABC or Legacy templates?
Regards
RE: agrupar datos en browse box
I want is that the data are not repeated in the grid and and it looks like the 3 picture
RE: agrupar datos en browse box
I understood what you want BUT I need to know if you are using ABC or Legacy since I have a solution ONLY for ABC.
Regards
RE: agrupar datos en browse box
RE: agrupar datos en browse box
RE: agrupar datos en browse box
When you do Application -> Properties, what do see in Application Template - Clarion OR ABC?
Regards
RE: agrupar datos en browse box
RE: agrupar datos en browse box
Instead of explaining here, can you extract the browse procedure into a simple APP and send me that APP and the DCT to go along with that & I will modify it and send it to you. The reason for this is that there are a quite a few embeds to write code in. If you do not want to send the APP/DCT, I will have to modify an existing standard example APP and send it to you.
What version of Clarion do you use? What database driver are the tables using?
My e-mail is ::
j s h a n k a r
@
e i m . a e
Regards
RE: agrupar datos en browse box
RE: agrupar datos en browse box
That poses a problem since I use Clarion 7.2 & 6.3 only.
Anyway, I will do an example using the INVOICE example database and send you a TXA. You can try and import it into C55.
Regards
RE: agrupar datos en browse box
Please find examples at http:
The APP & DCT are in Clarion 6.3 format and you CANNOT open it in C5.5. So, do the following ::
- Extract all the files (except Invoice.DCT & SummaryBrowse.APP) in the ZIP to a new Folder
- You can run the attached SummaryBrowse.EXE to see how the results are
- Create a New dictionary named Invoice.DCT in the same folder and IMPORT the attached Invoice.TXD
- Save the Dictionary & close it
- Create a New Application named SummaryBrowse.APP in the same folder using the Invoice.DCT and IMPORT the attached SummaryBrowse.TXA
- Save Application, generate, compile & run (Please note this will OVERWRITE the SummaryBrowse.EXE you extracted earlier).
Since the v6.3 & v5.5 classes are somewhat different, this may not work as expected. If so, you need to improvise on your own as I do not have v5.5 to help you.
Regards
RE: agrupar datos en browse box