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.
