Hi Setiaji Problem i have is on the red line, because when i commit it i get sum of all transfers, but i want to get only trasnfers with journalnameid "DepoTrans". There is a problem that i can't solve. Thanks.
________________________________ Kimden: [email protected] bu ki�inin yerine: setiaji kurniawan G�nderilmi�: Sal 03.05.2005 10:55 Kime: [email protected] Konu: [development-axapta] RE:select from inventtrans doesn't work Hi Cenk Ince, 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 [Non-text portions of this message have been removed] 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: http://docs.yahoo.com/info/terms/
