Hi Kenneth,
try write SQL statement through connection as the following
Connection con = new Connection();
Statement sqlStmt = Con.createStatement();
ResultSet SQLcustTrans;
Notes sqlStr
;
sqlStr =strFmt("select * from custTrans where month(TransDate)>1");
SQLcustTrans = sqlStmt.executeQuery(sqlSTR);
while (SQLcustTrans.next())
{
print SQLcustTrans.getString(1);
}
pause;
Regards
Ahmed
kamchung322 <[EMAIL PROTECTED]> wrote:
Hi All,
Is it possibly to create a Query like "SELECT EmplId, DataName(Month,
OnDutyDate), Sum(OnDutyTimes) FROM onDutyTable Group By EmplID WHERE
DateName(Month, OnDutyDate) = 10" ?
Regards.
Kenneth.
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
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.
---------------------------------
Do you Yahoo!?
Yahoo! Mail - now with 250MB free storage. Learn more.
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
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.
