Hello guys! im trying to do a datagrid that sum the cells values and display in the final cell the total...but i dont know why i cant do this....someone could help me? Im trying to use the command SetFieldValue, but always give me the "Catastrophic Error"... thanks!!!

Rafael S.

Let's see the inner joined with all ID fields present grid SQL: (SLX must know what you are trying to edit or it croaks).

And what's the script where you are using SetFieldValue:

I've done this a ton....

Hi RJ!!

Im posting here just a test to write something in the cell (but even this i cant do..lol). 

the sql property of the datagris is:

"SELECT A1.QUOTATION_SHIPPINGID, A1.SUBACTIVITY, A1.M_00, A1.M_01, A1.M_02,A1.TOTAL FROM QUOTATION_SHIPPING A1 WHERE QUOTATION_SHIPPINGID = :BindID"

and the code is:

<p> 
Function dgQuotationShippingEdited(Sender, PrimaryKeyValue, FieldName, Value)
     'Calcula o campo frete.
     dgQuotationShipping.SetFieldValue PrimaryKeyValue, "TOTAL", "1234",null
 End Function
</p>
 
 
thanks!!
 
Rafael S.

 

SLX has a standard Sum function for DataGrid Columns..

On the DataGrid Properties, ensure 'ShowSummaryFooter' is checked, then go to the 'Columns' Property, RIght-Click on the Column Header and select 'Properties..'

This will open a dialogue that has a 'Footer' button on it - The rest should be self explanatory...

Thanks Mark, but this dont solve my problem..i have to do the sum and show the result in the last cell, called total... But thanks for the answer!

Rafael S.

In this moment, im just trying to do is write something in a cell... i have tryied many things, but always give the error.... 

thanks!!!

Rafael s.