Yes, I made a mistake.But I can only say two point:
1, I learn Axapta for just half a year ,and I don't learn it very
well.
2. The "standard sql style"statement "Select * from inventtable"
under axapta table led me to a wrong way. And I didn't recognize that
before.
:)
--- In [email protected], "Preston A. Larimer"
<[EMAIL PROTECTED]> wrote:
>
> You have to understand that SQL statement in x++ are not true ANSI
SQL, nor
> are they Transact-SQL, Axapta has it's own syntax s. Here is a
couple of
> examples
>
>
>
> sql
>
> Select * from inventTable
>
> x++
>
> Select inventTable
>
>
>
>
>
> Sql
>
> Select count(*) from inventTable;
>
> x++
>
> select count(recID) from inventTable;
>
> print inventtable.recID;
>
> pause;
>
> When ever you do an aggregate function like count, the result is
stored in
> the field you executed the aggregate on
>
>
>
> Sql
>
> Select itemID, ItemName from InventTable
>
> Where inventTable.itemID = 'WL-2500'
>
> x++
>
> Select itemID, ItemName from InventTable
>
> Where inventTable.itemID == 'WL-2500';
>
>
>
>
>
>
>
>
>
>
>
>
>
> _____
>
> From: maipian_chen [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 22, 2004 6:53 AM
> To: [email protected]
> Subject: [development-axapta] Re: Why can't I execute the SQL
statement
> under axapta's table?
>
>
>
>
>
> 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
>
>
>
> ADVERTISEMENT
>
>
<http://us.ard.yahoo.com/SIG=129c7tn71/M=298184.5639630.6699735.300117
6/D=gr
>
oups/S=1705006764:HM/EXP=1103803174/A=2434971/R=0/SIG=11eeoolb0/*http:
/www.n
> etflix.com/Default?mqso=60185400> click here
>
>
>
> <http://us.adserver.yahoo.com/l?
M=298184.5639630.6699735.3001176/D=groups/S=
> :HM/A=2434971/rand=263554021>
>
>
>
> _____
>
> 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]
> <mailto:[EMAIL PROTECTED]
subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo!
> <http://docs.yahoo.com/info/terms/> Terms of Service.
>
>
>
> [Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor |
| Get unlimited calls to U.S./Canada |
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.
