I have experience almost same like you. May be it can
work for you.Here is my code in fetch method :
public boolean fetch()
{
boolean ret;
int _status;
/* --- variabel SQL Statement --- */
Connection _conn = new Connection();
Statement _state = _conn.createStatement();
ResultSet _result;
Notes _notes;
str _qry;
str _CurExt;
/* --- variabel SQL Statement --- */
;
_SubTotalQty = 0;
_GrandTotalQty = 0;
_status = 1;
/* --- SQL Statement --- */
_notes = "select *";
_notes += " from InventTrans";
_notes += " where dateinvent between '"+
date2str(_startdate,321,1,4,4,4,4)+ "' ";
_notes += " and '"+
date2str(_endDate,321,1,4,4,4,4)+ "' ";
_notes += " and StatusReceipt = 1 " ;
_notes += " order by ItemId";
/* --- SQL Statement --- */
element.executeControlColumnHeadings(1);
_result = _state.executeQuery(_notes);
while (_result.next())
{
_InventItemId = _result.getString(1);
_Qty = _result.getReal(4);
_DateInvent = _result.getDate(38);
if (_CurrItemId != _InventItemId)
{
element.execute(2);
element.execute(1);
_SubTotalQty = 0;
}
_SubTotalQty = _SubTotalQty + _Qty;
_CurrItemId = _InventItemId;
_GrandTotalQty = _GrandTotalQty + _Qty;
}
element.execute(2);
element.execute(3);
ret = true;
return ret;
}
-setiaji-
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
