Get Card Grid data from Calling Stored Procedure

Kinetic ERP
1

I am using Kinetic release “2024.1” and I am making customization through App. Studio where I have card grid that get the data from SQL stored procedure, this SP has parameters and i created a BPM to execute this SP.

The following code is used to execute the SP:

int QuoteNum = 0;

int OrderNum = ds .OrderHed [0].OrderNum ;

QuoteNum = Db.ExecuteStoreCommand(“select QuoteNum from Erp.OrderDtl where OrderLine = 1 and OrderNum =”+OrderNum);

if (QuoteNum == null||QuoteNum == 0||OrderNum == null||OrderNum == 0 ) return;

var dtCalc = Db.ExecuteStoreCommand(“exec Dev.Epicor_GET_ORDER_CALCS_SP “+QuoteNum+”,”+OrderNum);

var dtDeposit = Db.ExecuteStoreCommand(“exec Dev.Epicor_GET_ORDER_DEPOSITS_SP “+QuoteNum+”,”+OrderNum);

This SP returns a table but i cannot assign the data to the grid.

What is the way to add the this data to the grid

Regards

2

Nope nope nope

Use a baq.

3 Likes