uses Method SysQuery::value() to convert the _expression_
correctly ....
br
karsten
--- In [EMAIL PROTECTED], "Karsten Krabbes"
<[EMAIL PROTECTED]> wrote:
> Hi Wolfgang,
> try to check what string/query is really applied to the database.
> Maybe you need some extra backslash to qualify the _expression_.
>
> br
> karsten
>
> --- In [EMAIL PROTECTED], "Wolfgang Gross"
> <[EMAIL PROTECTED]> wrote:
> > Hi stefan,
> >
> >
> >
> > I thought the same � but when running the query an runtime error
> ocours:
> >
> >
> >
> >
> >
> >
> >
> > Other hints�.?
> >
> > Thank's and regards
> >
> > wolfgang
> >
> >
> >
> > _____
> >
> > Von: Stefan Lundquist (Priv) [mailto:[EMAIL PROTECTED]
> > Gesendet: Donnerstag, 8. Juli 2004 19:52
> > An: [EMAIL PROTECTED]
> > Betreff: SV: [development-axapta] QueryRange expressions
> >
> >
> >
> > Hi,
> > Try this using "like":
> >
> > ((MyField1 like "R*") || (MyField2 like "T*") || (MyField3
> like "T*"))
> >
> > / Stefan
> >
> >
> > -----Ursprungligt meddelande-----
> > Fr�n: wohegro [mailto:[EMAIL PROTECTED]
> > Skickat: den 7 juli 2004 13:19
> > Till: [EMAIL PROTECTED]
> > �mne: [development-axapta] QueryRange expressions
> >
> >
> > hi all,
> >
> > does anybody have a solution for the following problem:
> > I want to build a query (on runtime) with several rangefields.
> > all rangesfields are text-fields (!).
> > I want to OR all the ranges as described in technet
> >
> > http://technet.navision.com/default.asp?
> >
> MenuFunctionName=EISNewsArticle&MenuFunctionType=Output&NEWSID=351
> >
> > all works well if the value for the ranges are defined like
> > ((MyField1 == "Rin") || (MyField2 == "Tin") || (MyField3
> > == "Tin"))
> >
> > BUT I can't make it run when using wildcards ("*" and "?") like
> > ((MyField1 == "R*") || (MyField2 == "T*") || (MyField3
> == "T*"))
> >
> > any ideas...?
> >
> > thank's in advance!
> > wolfgang
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> >
> >
> > -----------------------------------------------------------------
--
> ---------
> > --
> > Yahoo! Groups Links
> >
> > a.. To visit your group on the web, go to:
> > http://groups.yahoo.com/group/development-axapta/
> >
> > b.. To unsubscribe from this group, send an email to:
> > [EMAIL PROTECTED]
> >
> > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms
> of Service.
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Sponsor
> >
> >
> >
> > ADVERTISEMENT
> >
> >
>
<http://us.ard.yahoo.com/SIG=129vfv9bi/M=295196.4901138.6071305.30011
> 76/D=gr
> >
>
oups/S=1705006764:HM/EXP=1089402196/A=2128215/R=0/SIG=10se96mf6/*http
> :/compa
> > nion.yahoo.com> click here
> >
> >
> >
> > <http://us.adserver.yahoo.com/l?
> M=295196.4901138.6071305.3001176/D=groups/S=
> > :HM/A=2128215/rand=732679186>
> >
> >
> >
> > _____
> >
> > 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 | |
|
|
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.
