RE: [development-axapta] QueryRange expressions

[lho]

Another solution could be to build a temp table record set containing a representation of the ranges and then to join your table on this temp table. The sql query becomes very quickly too large for the db to handle it. Therefore, it can be an idea to do it this way.
 
temp table (containing e.g. a RefRecId field which contains recid's from the table you want to add ranges to (se below))
|- the table you want to add ranges to (link should be RefRecId - RecId)
 
 
Regards,
Lars
 

-----Original Message-----
From: Don Price [mailto:[EMAIL PROTECTED]
Sent: 9. juli 2004 15:20
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] QueryRange expressions


You could write an x++ select using like to extract all the recids that
matched your select and then set a queryrange on the recids. If you go
more than 255 I think? You would just add a second range on recid again
keeping adding recids.  You might want to set some sort of max recs.  



-----Original Message-----
From: wohegro [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 07, 2004 6:19 AM
To: [EMAIL PROTECTED]
Subject: [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? <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 Links







Yahoo! Groups Sponsor      

ADVERTISEMENT
 <http://us.ard.yahoo.com/SIG=129v993lu/M=295196.4901138.6071305.3001176/D=groups/S=1705006764:HM/EXP=1089466041/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here      
  <http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=450958663>       


  _____  

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/ <http://groups.yahoo.com/group/development-axapta/> 
  

*      To unsubscribe from this group, send an email to:
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 
  

*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . 




[Non-text portions of this message have been removed]











Yahoo! Groups Sponsor


  ADVERTISEMENT 












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.