Re: [development-axapta] Report prints different on different computer

2007-10-24 Thread kbi kbi
Hi I think this is not because of the client computer but the printer setting. Check their printer. THanks Khue - Original Message From: V G <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; development-axapta@yahoogroups.com Sent: Tuesday, October 23, 2007 11:59:26 PM Subject: [development

[development-axapta] Re: Oracle to SQL

2007-10-24 Thread rajiyer74
Hi There You could try to the Surestep toolkit available for partners via the Partnersource website of Microsoft. There is a ready migration path from 2.5 to 4.0. I would explore the possibilities using this as this is recommended by Microsoft. I am not sure what version of Ax your install is

SV: [development-axapta] Re: How To Find Persons who born today ? (birthdate)

2007-10-24 Thread Steffen Denize
Hi Ali If you change emplTable to contactPerson in the select statement from Rosyee you will find all persons who have birthday today, no matter how many person there are in the given table. Best regards, Steffen Fra: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne a

[development-axapta] Re: Launch an external application from Ax 4.0

2007-10-24 Thread KimlaCour
WinApi::shellExecute("http://www.amazon.com";); --- In development-axapta@yahoogroups.com, "rajiyer74" <[EMAIL PROTECTED]> wrote: > > Hi Guys > > I am relatively new to the AX world. > I have a requirement to add a link to an external application or even a > url for example and launch this ur

Re: [development-axapta] Launch an external application from Ax 4.0

2007-10-24 Thread Max Belugin
WinApi::shellExecute("http://axaptapedia.com";); infolog.urlLookup("http://axcoder.blogspot.com";); On 10/24/07, rajiyer74 <[EMAIL PROTECTED]> wrote: > Hi Guys > > I am relatively new to the AX world. > I have a requirement to add a link to an external application or even a > url for example and l

RE: [development-axapta] Launch an external application from Ax 4.0

2007-10-24 Thread Morten Aasheim
Check out WinApi::shellExecute Regards, Morten Aasheim Peritus AS From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of rajiyer74 Sent: 24. oktober 2007 19:09 To: development-axapta@yahoogroups.com Subject: [development-axapta] Launch an external application from

[development-axapta] Re: Oracle to SQL

2007-10-24 Thread KimlaCour
It can be done via DTS. Create the SQL Server database using AX. Avoid copying SqlParameters (and probably some other system tables). You have to convert all empty strings (there are no NULLs in AX) from ASCII-2 to an empty string. Be very carefull with what type of Oracle-connection you cho

[development-axapta] Launch an external application from Ax 4.0

2007-10-24 Thread rajiyer74
Hi Guys I am relatively new to the AX world. I have a requirement to add a link to an external application or even a url for example and launch this url from within Ax. At the moment this can be a fixed url,say www.amazon.com. Is there an easy way to achieve this in AX ? Thanks for your replies

[development-axapta] Re: How To Find Persons who born today ? (birthdate)

2007-10-24 Thread Ali Ýhsan Aðca
Thanks Rosyee, But I have to find persons from ContactPerson table. And there more than 200.000 records in there. And this method will not be sufficient for finding 5 or maybe max 10 person from there. Best Regards... --- In development-axapta@yahoogroups.com, Rosyee <[EMAIL PROTECTED]> wrote: > >

Re: [development-axapta] Re: How To Find Persons who born today ? (birthdate)

2007-10-24 Thread Rosyee
Hi Ali, You can use like this while Select emplTable { if( mthofyr(emplTable.BirthDate) == mthofyr(today()) && dayofmth(emplTable.BirthDate) == dayofmth(today())) { //u'll get records who born on same day as today } } Hope this is what you are

Re: [development-axapta] Re: How To Find Persons who born today ? (birthdate)

2007-10-24 Thread Max Belugin
I'd prefer to extract month and day numbers to separate fields. But you can use Connection and native queries On 10/23/07, Ali Ýhsan Aðca <[EMAIL PROTECTED]> wrote: > I thought so. But I think there must be a way to include that case in > query filter string > > Thanks... > > --- In development-

Re: [development-axapta] How To Find Persons who born today ? (birthdate)

2007-10-24 Thread kartik1 patil
i think u use systemdateget(); built in fuction it will help u better Display date curdate() { While select * from empltable where empltable.birthdate== systemdateget() { info(EmplTable.name); } } or store current date in separate variable and then try l

[development-axapta] Report prints different on different computer

2007-10-24 Thread V G
Hi I am facing a problem where in a custom report is printing fine when I print it on my computer. But when I run/print the report on client computer it is printing a little different like the lines are longer there. Thanks in advance VG [Non-text portions of this message have been removed]