You certainly can, you just need to figure out the differences
between "X++ SQL" and "normal SQL".
Please check out the Developers Guide inside Axapta, and look through
some of the standard application code for examples.
For your two specific problems, try:
1. select count(RecId) from InventTable;
2. SELECT itemid, itemname FROM InventTable where
inventtable.itemid == "WL-2500";
Andrew Jones
--- In [email protected], "maipian_chen"
<[EMAIL PROTECTED]> wrote:
>
>
> 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.
