Yes, you are right. Thanks
--- In [email protected], "ozzage"
<[EMAIL PROTECTED]> wrote:
>
>
> 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.
