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

[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 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 '%%' || TABLA1.campo2 
like '%%'

How I do in Axapta this query???
Thanks you very much

 



[Non-text portions of this message have been removed]

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

[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 Like
To: development-axapta@yahoogroups.com
Date: Thursday, July 3, 2008, 1:01 AM






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 '%%' || TABLA1.campo2 
like '%%'

How I do in Axapta this query???
Thanks you very much

 














  

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

[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\))',
fieldstr(CustTable,Name),name, fieldstr(CustTable,InvoiceAccount),account);

qbr.value(range);
Cheers,

David S

On Thu, Jul 3, 2008 at 6:01 PM, jasuarezh [EMAIL PROTECTED] wrote:

   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 '%%' || TABLA1.campo2
 like '%%'

 How I do in Axapta this query???
 Thanks you very much

  



[Non-text portions of this message have been removed]

[development-axapta] Run DAX 4.0 Sp1 Client on DAX 4.0 SP2 AOS

[david santoso]

Hi All,

I have installed DAX 4.0 SP 2 for Application, AOS and also Client on
Server.

I install  run DAX 4.0 with SP1 Client ( actually i forgot to install SP2
Client), i have run with DAX for 1 week and nothing goes wrong.

Is that ok DAX 4.0 with SP 1 Client connect to AOS DAX 4.0 with SP 2 ?

Did the changes only apply on AOS  application server only ?

Any information  suggestion will be helpful.

Cheers,

David S


[Non-text portions of this message have been removed]

[development-axapta] PDF with embedded font does not work

[James Flavell]

Hi
 
I am trying to print using AX's PDF with embedded font option but it seems
once the file is generated and I open the file on a different PC (where the
special fonts are not installed) then the font is not shown correctly
 
I thought embedded font means whatever fonts I use in the document will also
be kept in the document
I am correct in my understanding of what embedded font means or did I
misunderstand something?
 
This is AX4.0 SP2
 
Thanks
James
 
 


[Non-text portions of this message have been removed]