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

2008-07-07 Thread Zümra Yücesoy
Hi, u can write in this way select table1 where ( table1.campo1 like '**'||table1.campo2 like '**' ) From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of jasuarezh Sent: Thursday, July 03, 2008 11:02

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 or and

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\))',