Usando “Not Like”

20 Jan

Posted by: Ricardo Pichler in: X++

Usando o like normal:

1 2	select firstonly purchTable where purchTable.purchId like '09*';

Quando você quiser ter todos os outros registros (not like), no X++ você tem 3 possibilidades:

1.!LIKE :

1 2	select firstonly purchTable where !(purchTable.purchId like '09*');

2. notExists join :

1
2
3

select firstonly purchTable
    notExists join refPurchTable
    where purchTable.purchId == '09*';

3. Query-object :

Query query = new Query();
QueryRun queryRun;
; 
query.addDataSource(tableNum(PurchTable)).addRange(fieldNum(PurchTable, PurchId)).value('!09*');
queryRun = new QueryRun(query);
if(queryRun.next())
{
    purchTable = queryRun.get(tableNum(PurchTable));
    print purchTable.PurchId;
}
pause;