You are most welcome.
axaptagrp <[EMAIL PROTECTED]> wrote:
axaptagrp <[EMAIL PROTECTED]> wrote:
thanks Varden
thats exactly what I had to do!
Best Regards,
John Chircop.
--- In [EMAIL PROTECTED], Varden Morris
<[EMAIL PROTECTED]> wrote:
> You can use Microsoft SQL statements directly in X++. Insert the
following code in a job and test it:
>
> Connection con = new Connection();
> Statement sqlStmt = Con.createStatement();
> ResultSet SQLcustTrans;
> Notes sqlStr
> ;
> sqlStr =strFmt("select * from custTable where LTRIM
(Accountnum) = '%1' AND " +
> "Name like '%a%'", "100001");
> SQLcustTrans = sqlStmt.executeQuery(sqlSTR);
> while (SQLcustTrans.next())
> {
> print SQLcustTrans.getString(1);
> pause;
> }
>
> axaptagrp <[EMAIL PROTECTED]> wrote:
>
> Hi everybody,
>
> could anyone please tell me how is the 'DISTINCT' keyword
implemented
> in X++ SQL?
>
> I am trying to fetch distinct sets of records from the inner join
of
> 2 tables, being WMSJournalTrans and inventDim.
>
> I have tried implementing the solution via temporary tables
> and 'group by', but as yet to no avail.
>
> could anyone please help? (yes Im new to Axapta)
>
> JP Chircop
> Malta.
>
> PS: i want distinct sets of records from the following:
>
> while select * from WMSJournalTrans where
WMSJournalTrans.journalID
> == journalIDhandlejoin inventDim where WMSjournalTrans.inventDimId
==
> inventDim.inventDimID
> {
> //additional code here
> }
>
>
>
>
>
>
>
> Sharing the knowledge on Axapta.
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
>
> ---------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/Axapta-Knowledge-Village/
>
> 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 - Helps protect you from nasty viruses.
Sharing the knowledge on Axapta.
Do you Yahoo!?
The all-new My Yahoo! – What will yours do?
Sharing the knowledge on Axapta.
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
