[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.axapta.programming

Query Expression Syntax - using wildcards

chris

11/15/2005 9:51:00 PM

Hi,

I have been attempting to build a query in X++ using wildcards (*) in the
datasource range.

A couple of posts here seem to indicate the use of wildcards in QueryRun is
not supported, but these posts are from several years ago and may not be
applicable to version3.

Can someone confirm wildcards are not supported in QueryRun? (or even better
how one might use wildcards!)

Thanks for any help!
--
Chris
2 Answers

JeremyB

11/15/2005 10:41:00 PM

0

Chris, you can't use wildcards in query expression syntax. But you can use
them in just building a "normal" query range. ie.
qbd.addRange(fieldnum(inventtable,itemId)).value("item000*");

"Chris (Toronto)" wrote:

> Hi,
>
> I have been attempting to build a query in X++ using wildcards (*) in the
> datasource range.
>
> A couple of posts here seem to indicate the use of wildcards in QueryRun is
> not supported, but these posts are from several years ago and may not be
> applicable to version3.
>
> Can someone confirm wildcards are not supported in QueryRun? (or even better
> how one might use wildcards!)
>
> Thanks for any help!
> --
> Chris

chris

11/16/2005 1:22:00 PM

0

Thanks Jeremy... Worked great!
--
Chris


"JeremyB" wrote:

> Chris, you can't use wildcards in query expression syntax. But you can use
> them in just building a "normal" query range. ie.
> qbd.addRange(fieldnum(inventtable,itemId)).value("item000*");
>
> "Chris (Toronto)" wrote:
>
> > Hi,
> >
> > I have been attempting to build a query in X++ using wildcards (*) in the
> > datasource range.
> >
> > A couple of posts here seem to indicate the use of wildcards in QueryRun is
> > not supported, but these posts are from several years ago and may not be
> > applicable to version3.
> >
> > Can someone confirm wildcards are not supported in QueryRun? (or even better
> > how one might use wildcards!)
> >
> > Thanks for any help!
> > --
> > Chris