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 '%
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
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\))',
3 matches
Mail list logo