RE: [Axapta-Knowledge-Village] Re: Stored Procedure thru X++
Hi here is the code to implement stored procedure thru x++
static void storedProcedure(Args _args)
{
LogInProperty Lp = new LogInProperty();
OdbcConnection myConnection;
Statement myStatement;
ResultSet myResult;
;
LP.setServer("2020");//Set ur server
LP.setDatabase("MatrixSSI");//set ur database
Lp.setUsername("sa");//set user
Lp.setPassword("sa");//set password
try
{
myConnection = new OdbcConnection(LP);
}
catch
{
info("Check username/password.");
return;
}
myStatement = myConnection.createStatement();
myResult = myStatement.executeQuery('EXEC [your stored procedure]');
while (myResult.next())
{
print myResult.getString(1);
}
pause;
}
regards,
sreenath Reddy
Brandon George <[EMAIL PROTECTED]> wrote:
All,
Here is the blog entry for executing a Stored Procedure through X++:
http://dynamics-ax.blogspot.com/2006/01/execute-dts-package-from-x.html
thanks,
Brandon
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of chuapatrickd
Sent: Tuesday, May 09, 2006 10:37 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Stored Procedure
Hi Brandon,
I can't find it, can you just send me the direct link on the stored
procs routine ?
Thanks,
Patrick
--- In Axapta-Knowledge-Village@yahoogroups.com, "Brandon George"
<[EMAIL PROTECTED]> wrote:
>
> Check out my blog: http://dynamics-ax.blogspot.com
>
> I wrote a post on how to do this. If you can't find it let me know
and I can send you the direct link.
>
> Thanks,
> Brandon
>
> -Original Message-
> From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-
[EMAIL PROTECTED] On Behalf Of chuapatrickd
> Sent: Tuesday, May 09, 2006 8:32 PM
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: [Axapta-Knowledge-Village] Stored Procedure
>
> Hi to all,
>
> I want to call an sql stored procedure in SQL
database "FILE_SERVER1",
> the name of the stored procedure is "consolidate_invoice", is it
> possible to call this from within x++ code ?
> If it is, can anyone give me sample code ?
>
> It is advisable to do this? or is there any other suggestion.
>
> Thanks,
> Patrick Chua
>
>
>
>
>
>
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
> Yahoo! Groups Links
>
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools
-
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
Sreenath Reddy G
System Analyst,
Sonata Software Ltd.
1/4, APS Trust Building,
N. R. Colony, Bull Temple Road,
Bangalore-560019.
Mobile-+9886331041
-
Blab-away for as little as 1¢/min. Make PC-to-Phone Calls using Yahoo! Messenger with Voice.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Arabization of Axapta
Hi Khurram, If u check the previous posts in this forum there are quite a few mails about customization in Arabic... I'm not too sure about the labels but the data can definetly be stored in Arabic, provided your database is of the Arabic collation language and ur OS supports the Arabic Version. (I am talking of Axapta 3.0 sp3 and above- not worked with the previous versions) The data input can be done in Arabic as well, provided the form and the field that you are inputting into, has the font set to an Arabic font. Do let me know if you get ur luck around with the labels Regards, Sherin Girish Bhatkal <[EMAIL PROTECTED]> wrote: you can contact your local microsoft office to provide the label files ( i am not aware of labels in arabic language). If you need to change it yourself an arabic language license is available (especially for the labels which you have changed) then you need to find the each label while selecting the languages in the advanced tab , go to each label and then write the description against the label for the specific language. --- Khurram Zaki <[EMAIL PROTECTED]> wrote: - Hello everyone... I am interested in changing the labels, input text and reports in Axapta to Arabic language. Need a clue as to where to start from. Is there a way we can change all the labels to some other language. Similarly, I am looking for storing data in Arabic and later retreiving that via Crystal Reports. I would appreciate if any one of you who have worked on localization to any other language can guide me through ... I need some pointers to start the thought process :) Cheers! Have a happy day. Khurram Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - ___ NEW - Yahoo! 360 Your one place to blog, create, publish and share! http://uk.360.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] SubQuery in Axapta
Hi guys, did anyone knows how to use subquery in X++ development? for example, I have a query like this (in ANSI SQL) : select * from custpaymschedline a, custpaymsched b where a.parentrecid=b.recid and b.extrecid=-1999372754 and a.duedate= (select max(duedate) from custpaymschedline cl where cl.parentrecid=a.parentrecid) the purpose is I want to get a payment line which the due date is maxmimum, if I dont use the subquer -> select max, what I got is a number of lines with many duedate. I already run this query in SQL analyzer and worked. .. or maybe in axapta there's another approach.. ? many thansk in advance. Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] AXAPTA OLAP inquiry
Hi Fellow AXAPTA users, I am currently having issues with running an AXAPTA OLAP cube based on the purchase order tables (i.e. header and line). The following is the error message that I've received: Error executing code: The field with ID '0' does not exist in table 'PurchLine'. Stack trace: \Classes\OLAPCreateAmount\createAmounts - line 92 \Classes\OLAPCreateAmount\run - line 6 \Classes\OLAPCreateAmount\main - line 7 \Classes\OLAPTransferData\createAmount - line 6 \Classes\OLAPTransferData\processInstance - line 10 \Classes\OLAPTransferData\run - line 18 \Classes\OLAPTransferData\main - line 18 \Classes\FormFunctionButtonControl\Clicked \Classes\FormFunctionButtonControl\Clicked Is there a way to solve this? Your help would be much appreciated. Thanks. Cheers, Dave Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: SV: SV: [Axapta-Knowledge-Village] how do i get the database server names, database names
Hema,
There is a simpler way to do this, and it can be done using X++.
Here is an extract of code I use
ODBCConnection
FormConnection
(
)
{
#PCDMacro
LoginProperty loginDetails = new LoginProperty();
ODBCConnection currentconnection;
str Database, CurrentServer, CurrentApplication;
int pos;
;
// Create the connection
database = sqlsystem::databaseBackendDesc();
<. processing the database variable to get the information I require.>
LoginDetails.setDatabase(Database);
logindetails.setUsername(#loginname);
logindetails.setPassword(#logincode);
currentconnection = new ODBCConnection(logindetails);
return currentconnection;
}
As you see, you can supply:
1. The database. In this case I use the currently connected database to determine which database I will connect to.
2. The login name. In this case it is stored in a macro.
3. The password. In this case it is stored in a macro.
While this example uses an ODBC connection, there may be other connection types that can also be used.
Thomas, thanks for the code for supplied.
Barry.
p.s. Hema, by describing your requirement you made it a lot easier to address your issue.
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, 10 May 2006 3:22 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: SV: SV: [Axapta-Knowledge-Village] how do i get the database server names, database names
Hi,
thank u very much. i'll tell u my requirement. the user will enter the
servername, database name, userid and password. i have to make test connect
for the given data. if it does not connect, then throw the error.
ex:
server name - axapta server
db name - EAM
user id - Hema
password - Hema
i want to check the connection for the above data. if it fails, then throw
error. i tried. but, i dont know how to make test connection for the above.
i specify database name from the input value as server.databases("axapta
server"). it gives error (number of invalid argument"). how do i do?
u specified
database = databases.item(j);
setprefix(database.name());
but, i want to give the database name from the user input value. how do i
give?
pls. provide the solution. sorry for the trouble. Thank u.
regs,
Hema. S
"Thomas Jensen"
<[EMAIL PROTECTED]> To:
Sent by: cc:
[EMAIL PROTECTED] Subject: SV: SV: [Axapta-Knowledge-Village] how do i get the database
groups.com server names, database names
05/09/2006 06:35 PM
Please respond to
Axapta-Knowledge-Village
Hi Hema S
This job will show SQL Servers, their databases and the usernames for each
database. Obviously you will need appropriate trusted login rigths for the
server to retrrive this information. The login names can also be retrieved
from one of the DMO objects but obviously it's not possible to retrieve the
passwords for the logins for security reasons.
Regards
Thomas
static void ListSQLServers(Args _args)
{
COM com = new COM("SQLDMO.Application");
COM servers = com.ListAvailableSQLServers();
COM sqlserver;
COM databases;
COM database;
COM users;
COM user;
int i;
int j;
int k;
;
setprefix("SQL Servers");
for (i=1;i<=servers.count();i++)
{
setprefix(servers.item(i));
try
{
sqlserver = new COM("SQLDMO.SQLS
RE : [Axapta-Knowledge-Village] Is Triggers and Stored Procedures are available in Axapta.
Hi Prem, You just can't handle triggers in Axapta. Axapta won't know there's triggers and the same goes for Stored Procedures. But you can call stored procedures using UserConnection to execute SQL the "pure" SQL way. Regards, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de [EMAIL PROTECTED] Envoyé : 9 mai 2006 00:32 À : Axapta-Knowledge-Village@yahoogroups.com Objet : RE: [Axapta-Knowledge-Village] Is Triggers and Stored Procedures are available in Axapta. Hi, I know how to create Triggers and Procedures in SQL Server, but my doubt is how to handle this in Axapta.(back end SQL Server) with regards, Prem "Harry Deshpande" <[EMAIL PROTECTED]> To: Sent by: cc: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Is Triggers and Stored groups.com Procedures are available in Axapta. 08/05/2006 08:50 PM Please respond to Axapta-Knowledge-Village hi I guess you will have to post in SQL server forum regards harry From: Axapta-Knowledge-Village@yahoogroups.com on behalf of [EMAIL PROTECTED] Sent: Mon 5/8/2006 1:44 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Is Triggers and Stored Procedures are available in Axapta. Hi Friends, I want to add Triggers and Stored Procedures in back end.(SQL Server). Please help me in this regard. with regards, M.Premkumar Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] posting through X++ code
There is nothing wrong in the code which sundar had
mentioned if you need to only post and print ones,but
if you want to go back and reprint the packing slip
(from say Purchase form / inquires) it would not be
possible as no entries were made in the purchParmline
table.
alternately you can try the below code
here you might have to change a few lines depending
upon your requirement:
purchFormLetter =
PurchFormLetter::construct(DocumentStatus::PackingSlip);
purchFormLetter.createParmUpdate();
purchFormLetter.createParmTable( purchParmTable,
purchTable);
purchParmTable.Num = packingSlipId;
purchParmTable.insert();
while select purchLine
where purchLine.PurchId == purchTable.purchId
&& (purchLine.RemainPurchPhysical > 0)
{
purchParmLine.ParmId = purchParmTable.ParmId;
purchParmLine.InitFromPurchLine(purchLine);
purchParmLine.ReceiveNow =
purchLine.RemainPurchPhysical;
purchParmLine.setQty(DocumentStatus::PackingSlip,
false, true);
purchParmLine.setLineAmount();
purchParmLine.insert();
}
purchFormLetter.proforma (false);
purchFormLetter.printFormLetter(true);
purchFormLetter.specQty (PurchUpdate::All);
purchFormLetter.transDate (today());
purchFormLetter.run();
hope this helps.
cheers,
Girish
--- "Sundararajan.T - Software Engineer (Enterprise
Solutions Practice) - SIS"
<[EMAIL PROTECTED]> wrote:
-
Hi,
you can Update the Receive now quantity in Purchline
& Can post the Purchase order with the following code
purchFormLetter =
PurchFormLetter::construct(DocumentStatus::packingslip);
purchFormLetter.transDate(SystemDateGet());
purchFormLetter.update(purchTable,"abcd",
purchFormLetter.transDate(SystemDateGet()),
PurchUpDate::receivenow,AccountOrder::None,
false,
false);
Regards
Sundar
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED]
Behalf Of gopala
krishna
Sent: Wednesday, May 10, 2006 10:01 AM
To: axapta-knowledge-village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] posting through
X++ code
hi,
I want to post the purchase order thru x++.
And i should be able to post only qty 50 even if
have qty 100 in my purchase line.
which class can i use. and which method.
thanks,
Gopal.
-
Yahoo! India Answers: Share what you know. Learn
something new. Click here
Send instant messages to your online friends - NOW
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
"Sundararajan.T - Software Engineer (Enterprise
Solutions Practice) - SIS"
<[EMAIL PROTECTED]>
___
Visit us at www.sundaraminfotech.in
___
This E-mail may contain privileged information and is
intended solely for the addressee, and any disclosure
of this information is strictly prohibited, and may be
unlawful. If you have received this mail by mistake,
please inform us immediately and delete this mail.
Any information expressed in this mail does not
necessarily reflect the views of SUNDARAM INFOTECH
SOLUTIONS. As per SUNDARAM INFOTECH SOLUTIONS's
policy, unencrypted mail via Internet is not
considered secure.
___
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business
finance consultant
Business finance magazine
Business finance schools
-
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the
web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.
-
Send instant messages to your online friends http://uk.messenger.yahoo.com
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consul
RE: [Axapta-Knowledge-Village] shipment
Make sure that all warehouse locations are assigned a picking area. Also if you use pallet transports, Axapta will generate picking routes from "picking" locations and pallet transports from "Buffer" locations. Maurice Cohen Senior consultant Advanced Systems Integration Inc. 26449 Rancho Parkway South Lake Forest, CA 92630 Phone (949) 597-2170 Fax (949) 597-0720 Cell (949) 533-5966 -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Kristjan Gerndorf Sent: Wednesday, May 10, 2006 8:27 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] shipment hei As I activate a shipment Axapta should create picking routes for all orders in the shipment basis. But sometimes some of the orders in shipment base stay in status "reserved" and no picking routes are generated. Please help - at what conditions it may occur and what to do to fix it? Kristjan _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Arabization of Axapta
you can contact your local microsoft office to provide the label files ( i am not aware of labels in arabic language). If you need to change it yourself an arabic language license is available (especially for the labels which you have changed) then you need to find the each label while selecting the languages in the advanced tab , go to each label and then write the description against the label for the specific language. --- Khurram Zaki <[EMAIL PROTECTED]> wrote: - Hello everyone... I am interested in changing the labels, input text and reports in Axapta to Arabic language. Need a clue as to where to start from. Is there a way we can change all the labels to some other language. Similarly, I am looking for storing data in Arabic and later retreiving that via Crystal Reports. I would appreciate if any one of you who have worked on localization to any other language can guide me through ... I need some pointers to start the thought process :) Cheers! Have a happy day. Khurram Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - ___ NEW - Yahoo! 360 Your one place to blog, create, publish and share! http://uk.360.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] shipment
hei As I activate a shipment Axapta should create picking routes for all orders in the shipment basis. But sometimes some of the orders in shipment base stay in status "reserved" and no picking routes are generated. Please help - at what conditions it may occur and what to do to fix it? Kristjan _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] adding lines within the class method without opening the class
is there any such way to add methods in tables?..
Regards
Sundar
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] Behalf Of sreenath
reddy
Sent: Wednesday, May 10, 2006 6:53 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] adding lines within the class
method without opening the class
Hi,
use classBuild class
it will create a new class in axapta thru code.
u can try this.
static void createnewClass(Args _args)
{
ClassBuild newClassBuild;
ClassName className;
;
ClassName = "MyNewClass";
newClassBuild = new ClassBuild(ClassName);
newClassBuild.addMethod("method1", "void method1(){\n str hello;}");
newClassBuild.addMethod("method2", "void method2(){\n str helloworld;}");
newClassBuild.classNode().AOTcompile(1);
}
NOW,IF U WANT TO CHANGE METHOD U CAN JUST CHANGE THE CODE like newClassBuild.addMethod("method2", "void method2(){\n str madam;}");
now it will just overwrite the code existing in method2()..
sreenath Reddy
[EMAIL PROTECTED] wrote:
Hi,
how to add lines within the class method in a particular line without
opening the class?
Ex:
-
i have a class called 'Class1'. it has more than one method like 'Method1',
'Method2', etc.
let us assume, Method2 has 5 lines of code. i want to add some lines before
the 4th line without opening the class method. through coding (ex: from
job), i want to add. How do i do this?
from job, i can open the specified line of code in the Method2 and i can
also change the source code of the Method2. but, entire existing code is
removed and new one is added. but. i want the specified line of code will
be appended with existing one.
pls. provide the solution. Thank u.
regs,
Hema. S
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools
-
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
Sreenath Reddy G
System Analyst,
Sonata Software Ltd.
1/4, APS Trust Building,
N. R. Colony, Bull Temple Road,
Bangalore-560019.
Mobile-+9886331041
-
Yahoo! Mail goes everywhere you do. Get it on your phone.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
"Sundararajan.T - Software Engineer (Enterprise Solutions Practice) - SIS" <[EMAIL PROTECTED]>
___
Visit us at www.sundaraminfotech.in
___
This E-mail may contain privileged information and is intended solely for the addressee, and any disclosure of this information is strictly prohibited, and may be unlawful. If you have received this mail by mistake, please inform us immediately and delete this mail. Any information expressed in this mail does not necessarily reflect the views of SUNDARAM INFOTECH SOLUTIONS. As per SUNDARAM INFOTECH SOLUTIONS's policy, unencrypted mail via Internet is not considered secure.
___
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Arabization of Axapta
Hello everyone... I am interested in changing the labels, input text and reports in Axapta to Arabic language. Need a clue as to where to start from. Is there a way we can change all the labels to some other language. Similarly, I am looking for storing data in Arabic and later retreiving that via Crystal Reports. I would appreciate if any one of you who have worked on localization to any other language can guide me through ... I need some pointers to start the thought process :) Cheers! Have a happy day. Khurram Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] adding lines within the class method without opening the class
Hi,
use classBuild class
it will create a new class in axapta thru code.
u can try this.
static void createnewClass(Args _args)
{
ClassBuild newClassBuild;
ClassName className;
;
ClassName = "MyNewClass";
newClassBuild = new ClassBuild(ClassName);
newClassBuild.addMethod("method1", "void method1(){\n str hello;}");
newClassBuild.addMethod("method2", "void method2(){\n str helloworld;}");
newClassBuild.classNode().AOTcompile(1);
}
NOW,IF U WANT TO CHANGE METHOD U CAN JUST CHANGE THE CODE like newClassBuild.addMethod("method2", "void method2(){\n str madam;}");
now it will just overwrite the code existing in method2()..
sreenath Reddy
[EMAIL PROTECTED] wrote:
Hi,
how to add lines within the class method in a particular line without
opening the class?
Ex:
-
i have a class called 'Class1'. it has more than one method like 'Method1',
'Method2', etc.
let us assume, Method2 has 5 lines of code. i want to add some lines before
the 4th line without opening the class method. through coding (ex: from
job), i want to add. How do i do this?
from job, i can open the specified line of code in the Method2 and i can
also change the source code of the Method2. but, entire existing code is
removed and new one is added. but. i want the specified line of code will
be appended with existing one.
pls. provide the solution. Thank u.
regs,
Hema. S
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools
-
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
Sreenath Reddy G
System Analyst,
Sonata Software Ltd.
1/4, APS Trust Building,
N. R. Colony, Bull Temple Road,
Bangalore-560019.
Mobile-+9886331041
-
Yahoo! Mail goes everywhere you do. Get it on your phone.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] changing the date
systemdateset? 10.05.06 в 16:20 gopala krishna в своём письме писал(а): > hi guys, > in my system today is giving the date as 5/1/2004. > How can i change it. > thanks, > Gopal. > > > - > Yahoo! India Answers: Share what you know. Learn something new. Click > here > Send instant messages to your online friends - NOW > > [Non-text portions of this message have been removed] > > > > > Sharing the knowledge on Axapta. > Visit www.frappr.com/axapta for axapta friends. > Yahoo! Groups Links > > > > > -- http://belugin.info ICQ:9406811 Yahoo! Groups Sponsor ~--> Get to your groups with one click. Know instantly when new email arrives http://us.click.yahoo.com/.7bhrC/MGxNAA/yQLSAA/kGEolB/TM ~-> Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] changing the date
Change OS Date format in axapta also it will change --- gopala krishna <[EMAIL PROTECTED]> wrote: > hi guys, > in my system today is giving the date as 5/1/2004. > How can i change it. > > thanks, > Gopal. > > > - > Yahoo! India Answers: Share what you know. Learn > something new. Click here > Send instant messages to your online friends - NOW > > [Non-text portions of this message have been > removed] > > __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] changing the date
hi guys, in my system today is giving the date as 5/1/2004. How can i change it. thanks, Gopal. - Yahoo! India Answers: Share what you know. Learn something new. Click here Send instant messages to your online friends - NOW [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Re: Stored Procedure
All, Here is the blog entry for executing a Stored Procedure through X++: http://dynamics-ax.blogspot.com/2006/01/execute-dts-package-from-x.html thanks, Brandon -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of chuapatrickd Sent: Tuesday, May 09, 2006 10:37 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Stored Procedure Hi Brandon, I can't find it, can you just send me the direct link on the stored procs routine ? Thanks, Patrick --- In Axapta-Knowledge-Village@yahoogroups.com, "Brandon George" <[EMAIL PROTECTED]> wrote: > > Check out my blog: http://dynamics-ax.blogspot.com > > I wrote a post on how to do this. If you can't find it let me know and I can send you the direct link. > > Thanks, > Brandon > > -Original Message- > From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta- [EMAIL PROTECTED] On Behalf Of chuapatrickd > Sent: Tuesday, May 09, 2006 8:32 PM > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: [Axapta-Knowledge-Village] Stored Procedure > > Hi to all, > > I want to call an sql stored procedure in SQL database "FILE_SERVER1", > the name of the stored procedure is "consolidate_invoice", is it > possible to call this from within x++ code ? > If it is, can anyone give me sample code ? > > It is advisable to do this? or is there any other suggestion. > > Thanks, > Patrick Chua > > > > > > > > > > Sharing the knowledge on Axapta. > Visit www.frappr.com/axapta for axapta friends. > Yahoo! Groups Links > Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] adding lines within the class method without opening the class
Hi, how to add lines within the class method in a particular line without opening the class? Ex: - i have a class called 'Class1'. it has more than one method like 'Method1', 'Method2', etc. let us assume, Method2 has 5 lines of code. i want to add some lines before the 4th line without opening the class method. through coding (ex: from job), i want to add. How do i do this? from job, i can open the specified line of code in the Method2 and i can also change the source code of the Method2. but, entire existing code is removed and new one is added. but. i want the specified line of code will be appended with existing one. pls. provide the solution. Thank u. regs, Hema. S Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Urgent Opening Balance Uplode!!!!!
Hi, Create a template for LedgerJournalTrans table to Import Vendor Invoices, we have been doing this for years now and never had problem 1. Create a Journal Batch. AP >> Journals >> Invoices >> Invoice Journal. Note down the Journal Number. 2. Click on the Lines button and note down the voucher number assigned. Check in the journal how the Voucher number is assigned (In connection with balance, or One Voucher number, GL >> Setup >> Journal >> Journal Names) 3. Now in your spreadsheet you have to have the Journal Number which you created in Step 1, and each line should have Voucher number from Step 2. Upload the data, then view the upload information. You should be able to see the A/P invoices Hemant K somnath jana <[EMAIL PROTECTED]> wrote: Hi Shanmug !! The tips may help you, follow the steps 1. Create a temptable according to the value of customer/vendor which fields u r going to import. 2. Create a defination group for importing the data, type should be Custom and take the 'Name of table" as u create just now. 3. Import the data into that temporary table. 4. Create a command button into the journal form and write codes on its and click button 5. See the data comes to your journal. Note in this case it does not require the CSV format just .xls file. Thanks Somnath Jana shanmug P <[EMAIL PROTECTED]> wrote: Hi , I have to import the Opening Balance for the Vendors and customers, for vendors i tried in Vendor Invoice Jn, by template and CSV file. In the earlier case the template is not creating for LedgerjournalTrans in the later case its getting imported but datas are not visible in the form. It will be really useful if some one give some tips. Regards Shanmugavel. - Yahoo! India Answers: Share what you know. Learn something new. Click here Send instant messages to your online friends - NOW [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] How to know current configuration
Hi, try this
static void currentConfiguartion(Args _args)
{
AOSSessionInfo info = new AOSSessionInfo();
SqlSystem SqlSystem = new SqlSystem();
;
print xinfo::componentName();
print xinfo::configuration();
print xinfo::dbName();
print xinfo::licenseName();
print xinfo::releaseVersion();
print info.clientMode();
print SqlSystem.loginConnectString();
pause;
}
regards,
sreenath Reddy
Sreenath Reddy G
System Analyst,
Sonata Software Ltd.
1/4, APS Trust Building,
N. R. Colony, Bull Temple Road,
Bangalore-560019.
Mobile-+9886331041
-
Blab-away for as little as 1¢/min. Make PC-to-Phone Calls using Yahoo! Messenger with Voice.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Virtual company account
Can you give some more details of table collections and Financial statement set ups. Thanks, -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of axaptos Sent: Wednesday, May 10, 2006 11:22 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Virtual company account Hi gurus, I am using virtual company account for my financial statement report. but the weird thing is some report values is taking from another company's financial statement values. what should i do to fix this? Regards, John Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: SV: SV: [Axapta-Knowledge-Village] connection verification
i dont get u. pls. explain or send me code.
regs,
Hema. S
"Ashish Singh"
<[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: SV: SV: [Axapta-Knowledge-Village] connection
groups.com verification
05/10/2006 01:53 PM
Please respond to
Axapta-Knowledge-Village
Hi,
try something like this
sqlserver = new COM("SQLDMO.SQLServer*\..."*);
if(sqlserver.connect(servername,userid,password))
where \ should be replaced by \DatabaseName hope this should
work but not sure.
And let me know.
On 5/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> i can test the connection using
>
> sqlserver = new COM("SQLDMO.SQLServer");
> if(sqlserver.connect(servername,userid,password))
>
> but, if i have more than one database in the server, how do i specify the
> database in the above statement. in the above statement, only servername,
> userid and password are given. i want to specify the database name also
to
> force the system to test the connection only in the specified database.
>
>
> pls. provide the solution. Thank u.
>
> regs,
> Hema. S
>
>
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
> Yahoo! Groups Links
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance Business to Small business
course business finance finance
Business finance Business finance Business finance
consultant magazine schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Virtual company account
Hi gurus, I am using virtual company account for my financial statement report. but the weird thing is some report values is taking from another company's financial statement values. what should i do to fix this? Regards, John Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: SV: SV: [Axapta-Knowledge-Village] connection verification
Hi,
i tried. but, it is not working.
regs,
Hema. S
"Ashish Singh"
<[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: SV: SV: [Axapta-Knowledge-Village] connection
groups.com verification
05/10/2006 01:53 PM
Please respond to
Axapta-Knowledge-Village
Hi,
try something like this
sqlserver = new COM("SQLDMO.SQLServer*\..."*);
if(sqlserver.connect(servername,userid,password))
where \ should be replaced by \DatabaseName hope this should
work but not sure.
And let me know.
On 5/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> i can test the connection using
>
> sqlserver = new COM("SQLDMO.SQLServer");
> if(sqlserver.connect(servername,userid,password))
>
> but, if i have more than one database in the server, how do i specify the
> database in the above statement. in the above statement, only servername,
> userid and password are given. i want to specify the database name also
to
> force the system to test the connection only in the specified database.
>
>
> pls. provide the solution. Thank u.
>
> regs,
> Hema. S
>
>
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
> Yahoo! Groups Links
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance Business to Small business
course business finance finance
Business finance Business finance Business finance
consultant magazine schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: SV: SV: [Axapta-Knowledge-Village] connection verification
Hi Hema,
I am trying and i will let you know as soon as i am successful provided i am
not engaged in any urgent work which i am expecting.
regards,
Ashish Singh
On 5/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Hi,
>
> i tried. but, it is not working.
>
>
> regs,
> Hema. S
>
>
>
>
> "Ashish Singh"
> <[EMAIL PROTECTED]> To:
> Axapta-Knowledge-Village@yahoogroups.com
> Sent by: cc:
> [EMAIL PROTECTED] Subject: Re:
> SV: SV: [Axapta-Knowledge-Village] connection
> groups.com verification
>
>
> 05/10/2006 01:53 PM
> Please respond to
> Axapta-Knowledge-Village
>
>
>
>
>
>
> Hi,
>
> try something like this
>
> sqlserver = new COM("SQLDMO.SQLServer*\..."*);
> if(sqlserver.connect(servername,userid,password))
>
> where \ should be replaced by \DatabaseName hope this should
> work but not sure.
>
> And let me know.
>
> On 5/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> > Hi,
> >
> > i can test the connection using
> >
> > sqlserver = new COM("SQLDMO.SQLServer");
> > if(sqlserver.connect(servername,userid,password))
> >
> > but, if i have more than one database in the server, how do i specify
> the
> > database in the above statement. in the above statement, only
> servername,
> > userid and password are given. i want to specify the database name also
> to
> > force the system to test the connection only in the specified database.
> >
> >
> > pls. provide the solution. Thank u.
> >
> > regs,
> > Hema. S
> >
> >
> >
> >
> >
> > Sharing the knowledge on Axapta.
> > Visit www.frappr.com/axapta for axapta friends.
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
>
>
>
> SPONSORED LINKS
>
> Business finance Business to Small business
> course business finance finance
>
> Business finance Business finance Business finance
> consultant magazine schools
>
>
>
> YAHOO! GROUPS LINKS
>
> Visit your group "Axapta-Knowledge-Village" on the web.
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>
>
>
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
> Yahoo! Groups Links
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: SV: SV: [Axapta-Knowledge-Village] connection verification
Hi,
try something like this
sqlserver = new COM("SQLDMO.SQLServer*\..."*);
if(sqlserver.connect(servername,userid,password))
where \ should be replaced by \DatabaseName hope this should
work but not sure.
And let me know.
On 5/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> i can test the connection using
>
> sqlserver = new COM("SQLDMO.SQLServer");
> if(sqlserver.connect(servername,userid,password))
>
> but, if i have more than one database in the server, how do i specify the
> database in the above statement. in the above statement, only servername,
> userid and password are given. i want to specify the database name also to
> force the system to test the connection only in the specified database.
>
>
> pls. provide the solution. Thank u.
>
> regs,
> Hema. S
>
>
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
> Yahoo! Groups Links
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: SV: SV: [Axapta-Knowledge-Village] connection verification
Hi,
i can test the connection using
sqlserver = new COM("SQLDMO.SQLServer");
if(sqlserver.connect(servername,userid,password))
but, if i have more than one database in the server, how do i specify the
database in the above statement. in the above statement, only servername,
userid and password are given. i want to specify the database name also to
force the system to test the connection only in the specified database.
pls. provide the solution. Thank u.
regs,
Hema. S
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to: [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
