Announcement

Collapse
No announcement yet.

Grid, group by and inner joins

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Grid, group by and inner joins

    Hi, I had a grid app, with the follow sql sentence

    SELECT
    orderitens.ordeintesid,
    orderitens.orderid,
    orderitens.quantity,
    orderitens.unitprice,
    orderitens.total,
    orderitens.unitpricec,
    orderitens.totalc,
    orderitens.name_code,
    orderitens.obs,
    products.picture,
    products.price,
    products.peso
    FROM
    orderitens INNER JOIN products ON orderitens.name_code = products.name

    Grouped by orderitens.name_code

    But I want that products.picture, products.price, products.peso shows just one time, no matter the result catch more than one register grouped by orderitens.name_code

    For example

    orderitens.name_code = fd-001, returns 4 regiter, cause 4 diferents clients order that product, thats ok, but I need just show one time the picture, the price and the weight
    and then 4 of the rest fields.

    How can I do that? I can't group by picture too, cause is a blob field and shows symbols not the image if I group for this field.

    Any ideas??

    Thanks in advance

  • #2
    I'm not sure but I thought that there was a setting to suppress repeating values. But if you cannot use that you can always use the onload event to clear the data if needed. You need to use some global variables to store the data from the previous record. But if you do the problem can be solved pretty straight forward:

    (in onload)
    Code:
    if ({myvalue}==[oldvalue])
       {myvalue}='';
     }
    
    [oldvalue]={myvalue}
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Thanks, I will try with that

      Comment

      Working...
      X