PO Inquiry
------------------------------
inqueiry using dynamic query:-
-----------------------------------------------------------------------------------------
init method:-
-----------------------------------------------------------------------------------------
public void init()
{
super();
delete_from M_purchTemp;
}
------------------------------------------------------------------------------------------
clicked method:-
-----------------------------------------------------------------------------------------
void clicked()
{
Query query;
QueryBuildDataSource qbds;
QueryBuildRange qbr;
QueryRun qr;
void clicked()
{
Query query;
QueryBuildDataSource qbds;
QueryBuildRange qbr,qbr1,qbr2;
QueryRun qr;
PurchTable purchTable;
M_purchTemp obj;
str var;
str id;
super();
delete_from m_purchTemp;
query = new query();
qbds = Query.addDataSource(tableNum(purchTable));
var = M_purchTemp_InvoiceAccount.valueStr();
id = M_purchTemp_PurchId.valueStr();
qbr = qbds.addRange(fieldNum(purchTable,invoiceAccount));
qbr1 = qbds.addRange(fieldNum(purchTable,PurchId));
qbr2 = qbds.addRange(fieldNum(purchTable,PurchStatus));
qbr.value(var);
qbr1.value(id);
qbr2.value(queryValue(any2enum(M_purchTemp_PurchStatus1.selection())));
qr=new QueryRun(query);
while(qr.next())
{
purchTable = qr.get(tableNum(PurchTable));
obj.InvoiceAccount = purchTable.InvoiceAccount;
obj.VendGroup = purchTable.VendGroup;
obj.Name = purchTable.PurchName;
obj.DocumentStatus = purchTable.DocumentStatus;
obj.PurchStatus = purchTable.PurchStatus;
obj.PurchId = purchTable.PurchId;
obj.insert();
}
M_purchTemp_ds.refresh();
M_purchTemp_ds.research();
//M_purchTemp_ds.reread();
}
------------------------------
inqueiry using dynamic query:-
-----------------------------------------------------------------------------------------
init method:-
-----------------------------------------------------------------------------------------
public void init()
{
super();
delete_from M_purchTemp;
}
------------------------------------------------------------------------------------------
clicked method:-
-----------------------------------------------------------------------------------------
void clicked()
{
Query query;
QueryBuildDataSource qbds;
QueryBuildRange qbr;
QueryRun qr;
void clicked()
{
Query query;
QueryBuildDataSource qbds;
QueryBuildRange qbr,qbr1,qbr2;
QueryRun qr;
PurchTable purchTable;
M_purchTemp obj;
str var;
str id;
super();
delete_from m_purchTemp;
query = new query();
qbds = Query.addDataSource(tableNum(purchTable));
var = M_purchTemp_InvoiceAccount.valueStr();
id = M_purchTemp_PurchId.valueStr();
qbr = qbds.addRange(fieldNum(purchTable,invoiceAccount));
qbr1 = qbds.addRange(fieldNum(purchTable,PurchId));
qbr2 = qbds.addRange(fieldNum(purchTable,PurchStatus));
qbr.value(var);
qbr1.value(id);
qbr2.value(queryValue(any2enum(M_purchTemp_PurchStatus1.selection())));
qr=new QueryRun(query);
while(qr.next())
{
purchTable = qr.get(tableNum(PurchTable));
obj.InvoiceAccount = purchTable.InvoiceAccount;
obj.VendGroup = purchTable.VendGroup;
obj.Name = purchTable.PurchName;
obj.DocumentStatus = purchTable.DocumentStatus;
obj.PurchStatus = purchTable.PurchStatus;
obj.PurchId = purchTable.PurchId;
obj.insert();
}
M_purchTemp_ds.refresh();
M_purchTemp_ds.research();
//M_purchTemp_ds.reread();
}
No comments:
Post a Comment