I have 2 column on table qyt and price. I want to display total = qtyprice on row grid, so I make SQL to calculte. Select qty,price,qtyprice as total from …
But on grid total cannot display the result…why?
In the grid you need to have a field to display it. The useual way to do this in scriptcase is by adding a field to your grid (field -> add field) and calll that total. Then in the onload event you add code like {total}={qty}*{price}; That’s it.
Grid? onRecord-Event …