There are a couple of things wrong:
-Don't put quotes around dates
-Use backslash separators, not forward separators
-Axapta SQL uses '&&' not 'AND'
-In your second 'where' part, you misspelled InventTransPosting.
Here is the correct query:
SELECT * FROM InventTransPosting where
InventTransPosting.Transdate >= 4\30\2005 &&
InventTransPosting.Transdate <= 5\31\2005
Regards,
Matt Benic
.Net/Axapta Analyst Developer
UTi Sun Couriers Division
Support the Xbox 360 in SA campaign
<http://forums.xbox.com/ShowPost.aspx?PostID=12592431>
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] Behalf Of Koh Meng Chiat
Sent: 21 June 2005 10:58 AM
To: [email protected]
Subject: [development-axapta] SQL Syntax in Axapta Table browser
Hello all,
The SQL statement i wrote to filter out the records
doesn't work in table browser. Could anyone shed some
lights on it??
SELECT * FROM InventTransPosting where
InventTransPosting.Transdate >="4/30/2005" and
InvenTransPosting.Transdate <="5/31/2005";
Thanks in advance.
Best Regards,
Jack
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Yahoo! Groups Links
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.
