SV: SV: [development-axapta] Query to 'OR' two ranges

2005-12-07 Thread Askeryd Thomas
hope they will fix that soon. Thomas. Från: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] För ozzage Skickat: den 6 december 2005 18:39 Till: development-axapta@yahoogroups.com Ämne: Re: SV: [development-axapta] Query to 'OR' two ranges Hi

RE: SV: [development-axapta] Query to 'OR' two ranges

2005-12-07 Thread Bayliss, Barry
To: development-axapta@yahoogroups.com Subject: SV: SV: [development-axapta] Query to 'OR' two ranges There ought to be a way around though. If no other way is possible you could always send the SQL-query directly to the database through a connection. I have not done it myself but seen others which have

Re: SV: [development-axapta] Query to 'OR' two ranges

2005-12-06 Thread ozzage
: development-axapta@yahoogroups.com [mailto:development- [EMAIL PROTECTED] On Behalf Of Andrew Zekveld Sent: Tuesday, 6 December 2005 12:15 AM To: development-axapta@yahoogroups.com Subject: Re: SV: [development-axapta] Query to 'OR' two ranges Thanks! I got it to work. for those who will be trying

SV: [development-axapta] Query to 'OR' two ranges

2005-12-05 Thread Askeryd Thomas
What I got in the reply worked just fine.. except from the qbdsStat.relations(true); qbdsStat.joinMode(JoinMode::ExistsJoin); which never seems to work for me. I have to use qbdsStat.addLink(FieldNum(Persons, Pnr),FieldNum(FamStatus, Pnr)); has anybody got a clue what that is all

Re: SV: [development-axapta] Query to 'OR' two ranges

2005-12-05 Thread Andrew Zekveld
Thanks! I got it to work. for those who will be trying the solution below: I couldn't get it to work with 'Person.Age' as is used in the example below. Leave out the table name if you are only working in one table, then it works. Otherwise you get a error message indicating that the

RE: SV: [development-axapta] Query to 'OR' two ranges

2005-12-05 Thread Bayliss, Barry
:[EMAIL PROTECTED] On Behalf Of Andrew Zekveld Sent: Tuesday, 6 December 2005 12:15 AM To: development-axapta@yahoogroups.com Subject: Re: SV: [development-axapta] Query to 'OR' two ranges Thanks! I got it to work. for those who will be trying the solution below: I couldn't get it to work