Hi,
To solve this problem, u can use query range. example:
u have to do the following steps:
1. in class declaration u have to declare the variable
QueryBuildRange field;
2. in datasource init method assign the field to that declared variable
like this
field=this.query
().dataSourceNo(1).addRange(FieldNum(tablename,field));
3. in datasource execute query give like this
field = this.query().dataSourceNo(1).findRange(FieldNum(table,field));
field.value("val1,val2,val3");
try this one. it will display the records as u wish.
regs,
Hema. S
"Rajkumar"
<[EMAIL PROTECTED] To: [email protected]
n> cc:
Sent by: Subject: [development-axapta] Syntax for Axapta SQL statement
[EMAIL PROTECTED]
groups.com
03/23/2006 02:03 PM
Please respond to
development-axapta
Dear All,
I have an requirement like selecting records for Purch Items
for 'n' number of Purchase order. This is like Select * from PurchLine
where purchid in ('234334','345345','34534'). Could any one kindly
help me doing this equillent in Axapta SQL. This is an urgent
requirement please reply me ASAP.
Thanks in advance,
Raj
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
