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.3001176/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]>
* 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 | |
|
|
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.
