Friday, December 31, 2010

TO select multiple Records Using check box field in form and To change the status in field values like Openorder, invoiced, recevied

Table level
Add a field to ur table which is used as data source in ur form ,
for that field use enum type : noyes in field property:

Form level:
-
public void init()
{
super();

ttsbegin;
while select forupdate custTable where custTable.Choose == NOYes::Yes
{
custTable.Choose = NOYes::No;
custTable.update();
}
ttscommit;
}
--
--
void clicked()
{
super();

//if(CustTable.Choose)

ttsbegin;
// while select CustTable
// where CustTable.Choose == noyes::Yes
while select forupdate CustTable
where CustTable.Choose == noyes::Yes
{
CustTable.StatusSag = statussag::OpenStatus;
CustTable.Choose = noyes::No;

CustTable.Update();
}


ttscommit;
CustTable_ds.executeQuery();

}
--
void clicked()
{
super();

//if(CustTable.Choose)

ttsbegin;
while select forupdate CustTable
where CustTable.Choose == noyes::Yes
{
CustTable.StatusSag = statussag::CloseTrans;
CustTable.Choose = noyes::No;
CustTable.Update();
}


ttscommit;
CustTable_ds.executeQuery();

}

No comments:

Post a Comment

Leave your comments and solutins