RE: [development-axapta] Query sentence or and Like

2008-07-07 Thread Zümra Yücesoy
AM To: development-axapta@yahoogroups.com Subject: [development-axapta] Query sentence or and Like Hello, I have a problem, I need to create a query with a condition OR, in this condition have a comparison with Like. My query in SQL is: select * from TABLA1 where TABLA1.campo1 like '%

Re: [development-axapta] Query sentence or and Like

2008-07-07 Thread Tony Zeigler
Try this: Void trythis() { TABLA1 cursorTABLA1; ; select cursorTABLA1 where cursorTABLA1.comp1 like '**' || cursorTABLA1.compo2 like '**' } --- On Thu, 7/3/08, jasuarezh [EMAIL PROTECTED] wrote: From: jasuarezh [EMAIL PROTECTED] Subject: [development-axapta] Query sentence

Re: [development-axapta] Query sentence or and Like

2008-07-07 Thread david santoso
Hi, I think a lot of people have already asked this question, you should browse this forum. I give you the example code: qbr = this.query().datasourcetable(tablenum(custTable)).addrange(fieldnum(custtable, recid)); range = strfmt('((%1 == \%2\) || (%3 == \%4\))',