static void selectTest(Args _args)
{
CustTable custTable;
int maxRecId ;
;
select maxOf(RecId) from custTable;
maxRecId = custTable.RecId ;
Box::info("Max recId : " + int2str(maxRecId) );
}
--- In [EMAIL PROTECTED], "helpmeobwan"
<[EMAIL PROTECTED]> wrote:
> I have connected to an access database using selectstatement. Now I
> want to connect to another table and get the lastest IDNUmber.
>
> select max(IDNumber) from myTable;
> lastIDProcessed = max(IDNumber);
>
> But axapta reports a syntax error on the select statement. I do not
> use SQL much but I think the statement is ok.
>
> Does anyone know how to do this in X++ ?
>
> J
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
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:
http://docs.yahoo.com/info/terms/
