agrupar datos en browse box

[frankymr]

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

 

[ShankarJ]

Hi!

I need to group data in a browse box to if you have 2 or more lines with the same data instead of appearing 2 times, only to see a total of units. eg I have 5 articles "a" and 1 item "b" instead of appearing:
1 a 1 unit
2 a 1 unit
3 a 1 unit
4 a 1 unit
5 a 1 unit
6 b 1 unit
appears:
1 a 5 unit
2 b 1 unit

anyone know how I can do it??

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?

No sé español, pero supongo que lo anterior es la traducción correcta Inglés (cortesía de Google Translate).

Enviadme la vista Ver reales de definición de cola y voy a tratar de explicar la solución para usted. ¿Está utilizando ABC o Legacy plantillas?

Regards

 

[frankymr]

ok, thanks
I want is that the data are not repeated in the grid and and it looks like the 3 picture

 

[ShankarJ]

Hi!

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

 

[frankymr]

I think it is ABC, but as I can confirm to you? where I can see

 

[frankymr]

yes, is abc browseclass

 

[ShankarJ]

Hi!

When you do Application -> Properties, what do see in Application Template - Clarion OR ABC?

Regards

 

[frankymr]

type abc(abc)

 

[ShankarJ]

Hi!

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

 

[frankymr]

the version is 5.5 and the can extract the browse procedure into a app but the problem is what multi-dll . can extact de window and the table of the dct, or explain to me how to change

 

[ShankarJ]

Hi!

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

 

[ShankarJ]

Hi!

Please find examples at

http://www.4shared.com/file/wcj5mpVQ/SummaryBrowse.html.

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

 

[frankymr]

thanks,I check and I say something