Sorry, my axapta is version 3.0 with sp1.And I just can't execute
even "select count(*) from inventtable;"! I can't execute statement
like "SELECT itemid,itemname FROM InventTable where
inventtable.itemid = 'WL-2500';" either(standard appl.).
I don't know why.Seems I can use only "select * from tablename;" I
don't think it is the version or SP problem.
--- In [email protected], "Agus Riyadi"
<[EMAIL PROTECTED]> wrote:
>
>
> You can, the syntax is slightly different with x++ and we can not
> make a join here.
> To select specific fields, just type the field name instead of *.
> The where clause need tablename.fieldname.
> You can also type aggregate statements here.
>
> regards,
>
> agus
> [EMAIL PROTECTED]
>
>
> --- In [email protected], "maipian_chen"
> <[EMAIL PROTECTED]> wrote:
> >
> >
> > Seems only "select * from tablename " is usable.How about other
> > statements? Thanks.
| 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.
