RE: [development-axapta] Calling Stored Procedures from axapta
Hi Jako,
If you use the class, Statement
http://dev-wss/Technical/Forms/DispForm.aspx?ID=107RootFolder=%2fTechn
ical%2fMicrosoft%20Business%20Solutions%2fTechnical%20Information%20%2d%
20versions%2f2%2e5Source=http%3a%2f%2fdev%2dwss%2fTechnical%2fMicrosoft
%20Business%20Solutions%2fTechnical%20Information%20%2d%20versions%2f2%2
e5 , then you can do everything which you normally would do from eg.
Query Analyzer.
Example from Appl.doc:
Connection Con = new Connection();
Statement Stmt = Con.createStatement();
ResultSet R = Stmt.executeQuery('SELECT VALUE FROM
SQLSYSTEMVARIABLES');
while ( R.next() )
{
print R.getString(1);
}
Regards,
Karsten Wollesen Clausen
Thy Data Center Development A/S
From: Jako Boon [mailto:[EMAIL PROTECTED]
Sent: 2. februar 2005 16:09
To: Yahoo Axapta
Subject: [development-axapta] Calling Stored Procedures from axapta
Hi,
Is it at all possible to call a MSQL Stored procedure with parameters in
Axapta through X++ code? If so is there some preferred syntax that I can
use.
Thanks
Jako Boon
iSoft Technologies (Pty) Ltd
(You can contact iSoft @ +27 12 3454720)
--
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.7.5 - Release Date: 2005/01/26
[Non-text portions of this message have been removed]
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
be
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service http://docs.yahoo.com/info/terms/ .
[Non-text portions of this message have been removed]
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
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: [development-axapta] Com Connector
HI, If you are running Axapta 3.0 you can setup which Axapta configuration the com connector should use under Administration\Setup\Internet\Web Sites\Setup. If you are running Axapta 2.5 - then you have to modify the way the COM connector is started - this can be done by adding some additional information in the i_axaptaFunctions script (specify Axapta configuration file all places where Axapta Logon is called) Regards, Karsten Thy Data Center Development A/S -Original Message- From: Rocco Giumelli [mailto:[EMAIL PROTECTED] Sent: 24 January 2005 04:57 PM To: '[EMAIL PROTECTED] Com'; '[EMAIL PROTECTED] Com' Subject: [development-axapta] Com Connector I am having trouble establishing two seperate Com Connections one for my Live and one for Play System for Enterprise Portal Web Access. When I register the Play Config File and go into my Live system the test on the buisness connector says it is the Play system and vica versa. I am missing the trick. Under Licences it has registered 2 Com Clients. Rocco Giumelli [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] One report with data from all companies
Hi, One way of doing this would be to build a temporary table containing all the records from the different companies and then base the report on the temporary table. Regards, Karsten Wollesen Clausen Thy Data Center Development A/S From: hbrommer [mailto:[EMAIL PROTECTED] Sent: 10. januar 2005 14:19 To: development-axapta@yahoogroups.com Subject: [development-axapta] One report with data from all companies Hi all, I would like to run a report in one company, containing data from several other companies as well. Does anyone have a clue how this can be done? Thanks in advance, Henk-Jan Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] FW: User configuration utility settings changes
Hi Girish, I have a suggestion which might work for you. 1) create a short-cut to Ax32.exe () 2) use the -regimport=Axapta configurationfile to identify the common Axapta configuration the users should use 3) use the -user=%username% to overwrite default-user 4) use the -company=copany id Example: -regimport=C:\ Axapta30Sp3\Axapta30sp3_3Tier.xpo -regconfig=axapta30sp3_3Tier -user=%username% -company=XXX If you use this set-up - then the users only need to setup username and company-id on the short-cut. Regards, Karsten Wollesen Clausen Thy Data Center Development A/S From: Girish Bhatkal [mailto:[EMAIL PROTECTED] Sent: 15. november 2004 13:38 To: Axapta developers Subject: [development-axapta] FW: User configuration utility settings changes Hi Guys, Does anyone knows the reason for the below condition of resetting of the configuration utility setting. It happened again twice last week. I would appreciate any possible reasons for this. Thanks. Cheers, Girish _ From: Girish Bhatkal [mailto:[EMAIL PROTECTED] Sent: 11 November 2004 11:26 To: Axapta developers ([EMAIL PROTECTED]) Subject: User configuration utility settings changes Hi All, At our client site , all the users connect to Axapta using the Terminal server. The users after log on in the Terminal server using their domain userid and password,. Had set on the Axapta configuration utility their UserId and Company. When ever they enter the terminal server , next time, and login the axapta the default user id set on the configuration is defaulted . This is fine. Sometime suddenly (it happened around 4-5 times in the last 2 months) the users complained that their settings have been changed. I talked to the system administrator and they said they did not change settings. Everyusers settings had been changed and all the users had their default userid to a particular user's UserId and his default company. The users then had to go back and change their configuration settings but I wanted to understand how this could happen. Can anyone tell me what could be the reason or how can one change the settings of all the individual user (nearly 50 users). If any one of you had faced this problem and could find the solution please do let me know. Thanks, Cheers, Girish [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=129fj9var/M=298184.5584357.6650215.3001176/ D=groups/S=1705006764:HM/EXP=1100608407/A=2426682/R=0/SIG=11edksnhv/*htt p:/www.netflix.com/Default?mqso=60185402 http://us.adserver.yahoo.com/l?M=298184.5584357.6650215.3001176/D=group s/S=:HM/A=2426682/rand=460792936 Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 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: [development-axapta] FW: User configuration utility settings changes
Hi Girish, The trick is to load the shared Axapta configuration file every time the user start the short-cut. This will also prevent an older user-profile to overwrite the users Axapta-configuration settings when you log-on to the server. Best regards, Karsten Wollesen Clausen Thy Data Center Development A/S From: Girish Bhatkal [mailto:[EMAIL PROTECTED] Sent: 15. november 2004 14:12 To: [EMAIL PROTECTED] Subject: RE: [development-axapta] FW: User configuration utility settings changes Hi Karsten, I had got every user open their configuration utility (after login in the terminal server using their domain userid) and then asked them to enter their userid in the Userid and company id in the company. Now when they login it takes their person set user id and company. When they start again the next day they find their user id and company which was set earlier still saved and they just have to click the short of the application (Ax32.exe). But suddenly we find that all the users's settings (which they had changed to have their userid and company id) has been again changed back to a configuration which was imported at first. I wanted to understand how this can be done so that I can make the changes to avoid the resetting of the user's configuration. They are all connected using 2 tier configuration (axapta v 3 SP2) Thanks. Cheers, Girish _ From: Karsten Wollesen [mailto:[EMAIL PROTECTED] Sent: 15 November 2004 12:47 To: [EMAIL PROTECTED] Subject: RE: [development-axapta] FW: User configuration utility settings changes Hi Girish, I have a suggestion which might work for you. 1) create a short-cut to Ax32.exe () 2) use the -regimport=Axapta configurationfile to identify the common Axapta configuration the users should use 3) use the -user=%username% to overwrite default-user 4) use the -company=copany id Example: -regimport=C:\ Axapta30Sp3\Axapta30sp3_3Tier.xpo -regconfig=axapta30sp3_3Tier -user=%username% -company=XXX If you use this set-up - then the users only need to setup username and company-id on the short-cut. Regards, Karsten Wollesen Clausen Thy Data Center Development A/S From: Girish Bhatkal [mailto:[EMAIL PROTECTED] Sent: 15. november 2004 13:38 To: Axapta developers Subject: [development-axapta] FW: User configuration utility settings changes Hi Guys, Does anyone knows the reason for the below condition of resetting of the configuration utility setting. It happened again twice last week. I would appreciate any possible reasons for this. Thanks. Cheers, Girish _ From: Girish Bhatkal [mailto:[EMAIL PROTECTED] Sent: 11 November 2004 11:26 To: Axapta developers ([EMAIL PROTECTED]) Subject: User configuration utility settings changes Hi All, At our client site , all the users connect to Axapta using the Terminal server. The users after log on in the Terminal server using their domain userid and password,. Had set on the Axapta configuration utility their UserId and Company. When ever they enter the terminal server , next time, and login the axapta the default user id set on the configuration is defaulted . This is fine. Sometime suddenly (it happened around 4-5 times in the last 2 months) the users complained that their settings have been changed. I talked to the system administrator and they said they did not change settings. Everyusers settings had been changed and all the users had their default userid to a particular user's UserId and his default company. The users then had to go back and change their configuration settings but I wanted to understand how this could happen. Can anyone tell me what could be the reason or how can one change the settings of all the individual user (nearly 50 users). If any one of you had faced this problem and could find the solution please do let me know. Thanks, Cheers, Girish [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=129fj9var/M=298184.5584357.6650215.3001176/ D=groups/S=1705006764:HM/EXP=1100608407/A=2426682/R=0/SIG=11edksnhv/*htt p:/www.netflix.com/Default?mqso=60185402 http://us.adserver.yahoo.com/l?M=298184.5584357.6650215.3001176/D=group s/S=:HM/A=2426682/rand=460792936 Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=129m584ut/M=298184.5584357.6650215.3001176/ D=gr oups/S=1705006764:HM/EXP=1100609515/A=2426683/R=0/SIG=11eeoolb0/*http:/w ww.n etflix.com
RE: [development-axapta] Printing Multiple Misc Charges on a Sales Order
Hi,
You need to something like this.
Str retStr = ;
;
While select * from markuptrans
Where ..
{
If (retStr != )
retStr += \n;
retStr += markupTrans.txt;
}
Return retStr;
Regards,
Karsten Wollesen Clausen
Thy Data Center Development A/S
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 12. november 2004 14:43
To: [EMAIL PROTECTED]
Subject: [development-axapta] Printing Multiple Misc Charges on a Sales
Order
Hi Everybody,
I need help on the following:
I have created a method to print the miscellaneous charges from table
MarkupTrans onto the SalesInvoiceUS report but I am only getting 1 line
printed even if there are several rows of charges in the table. The
method
I am using is printed below. What do I need to do to get all the
applicable
charges printed or can this even be done using a method.
display MarkupTransTxt60 mMarkupTransTxt()
{
MarkupTrans markupTrans;
;
select txt from markupTrans where markupTrans.Voucher ==
this.LedgerVoucher;
return markupTrans.Txt;
}
Thanks,
Bob
Bob Brinker
Oakdene Group, Inc.
2625 Butterfield Rd. (Suite 212E)
Oak Brook, IL 60523-1261
(630)368-1046 x/230
(630)368-1050 (Fax)
[EMAIL PROTECTED]
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
http://us.ard.yahoo.com/SIG=129tg80b8/M=298184.5584357.6650215.3001176/
D=groups/S=1705006764:HM/EXP=1100349914/A=2426682/R=0/SIG=11edksnhv/*htt
p:/www.netflix.com/Default?mqso=60185402
http://us.adserver.yahoo.com/l?M=298184.5584357.6650215.3001176/D=group
s/S=:HM/A=2426682/rand=578728564
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
be
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service http://docs.yahoo.com/info/terms/ .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
Get unlimited calls to U.S./Canada
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
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: [development-axapta] Are Page and PagesTotal Global data Methods
Hi Bob, These methods are defined on the class ReportRun Regards, Karsten Wollesen Clausen Thy Data Center Development A/S From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22. oktober 2004 13:32 To: [EMAIL PROTECTED] Subject: [development-axapta] Are Page and PagesTotal Global data Methods Hi All, There are some Data Methods, in reports for example like Page and PagesTotal, that do not seem to be defined within the report. Are these Data Methods defined somewhere and what are the other ones or am I missing something? Thanks in Advance and with Sincerely Appreciation for the on-going help I have received, Bob Bob Brinker Oakdene Group, Inc. 2625 Butterfield Rd. (Suite 212E) Oak Brook, IL 60523-1261 (630)368-1046 x/230 (630)368-1050 (Fax) [EMAIL PROTECTED] Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=129555h8u/M=294855.5468653.6549235.3001176/ D=groups/S=1705006764:HM/EXP=1098531319/A=2376776/R=0/SIG=11ldm1jvc/*htt p:/promotions.yahoo.com/ydomains2004/index.html http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group s/S=:HM/A=2376776/rand=754276619 Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] be * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Urgent: Where is TemporaryFormName
Hi, You can do this by defining the AutoLookup-fieldgroup on the VendTable table! Then the auto-lookup will look like this VendAccountfield-1.. field-x Best regards, Karsten Wollesen Clausen Thy Data Center Development A/S http://development.thydatacenter.dk/ [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] External databases
Hi, Check the documentation of the class, OdbcConnection, it contains a good example of interacting with another database using ODBC-setup Best regards, Karsten Wollesen Clausen Thy Data Center Development A/S http://development.thydatacenter.dk/ [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
SV: [development-axapta] more than 3 dimensions - go to main table doesn't work
Hi Claudia, You have to setup relations for dimension 4-6 on the extended data type Dimension. Regards, Karsten -Oprindelig meddelelse- Fra: Claudia Göries [mailto:[EMAIL PROTECTED] Sendt: 4. februar 2004 11:17 Til: [EMAIL PROTECTED] Emne: [development-axapta] more than 3 dimensions - go to main table doesn't work Hi together, I've integrated dimension 4-6 in Axapta 3.0 SP2. In form dimension I can create records for dimension 4-6, In form inventTable I can select them from lookup, but I don't can go to the main table (dimension 1-3 work fine). Any hint for me ? Thanks in advance ! Claudia Yahoo! Groups Links · To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ · 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! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
