RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0
Hi Daniel The following is taken from the documentation of the Statement class (\System Documentation\Classes\Statement) Description A Statement object is used for executing a static SQL statement and obtaining the results it produces. Only one ResultSet per Statement can be open at any point in time. Therefore, if the reading of one ResultSet is interleaved with the reading of another, each must have been generated by different Statements. Remarks All statement execute methods implicitly close a statement's current ResultSet if an open one exists. Example { Connection Con = new Connection(); Statement Stmt = Con.createStatement(); ResultSet R = Stmt.executeQuery('SELECT VALUE FROM SQLSYSTEMVARIABLES'); while ( R.next() ) { print R.getString(1); }} As I mentioned earlier you cannot use the Statement class if you want to execute X++ sql syntax Lennart Conrad Microsoft Business Solutions This posting is provided AS IS with no warranties, and confers no rights. From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 08:37 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi Lennart, i'm not really understand what u mean by system class statement? i get solution from other group's member to suggest using something like: xppCompiler compiler = new xppCompiler(); str sql = 'void sql{select .}' if(compiler.compile) runbuf(sql); but it seems not working perfectly when i try in job cos the compiler.compile requesting param str source. i've post this to him but no respond yet. u have any idea on this?will appreciate if u can provide an example. rgds, daniel Lennart Conrad [EMAIL PROTECTED] wrote: Hi Daniel Take a look at the system class Statement and its documentation. Note that the SQL syntax should be real SQL and not Axapta sql Lennart Conrad Microsoft Business Solutions This posting is provided AS IS with no warranties, and confers no rights. From: daniellim_yh [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 05:05 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi all, in Axapta, can i do execution to a string like this: TempTableA _Tmp_Tbl; //TempTableA is Temp table in Axapta Exprstr = delete_from _Tmp_Tbl where _Tbl.field1 == 'A'; then execute this query. i need the syntax to execute it. the reason i do like this because the string is a dynamically generated SQL string. i m using Axapta 3.0. pls help n thx in advance. rgds, daniel Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0
hi Lennart, it works for select statement, but not with delete statement. my example as follow inside job: { Connection Con = new Connection(); Statement Stmt = Con.createStatement(); ResultSet R = Stmt.executeQuery('delete FROM TableA whereCustomerCode = \'AAI\'');} thx. daniel Lennart Conrad [EMAIL PROTECTED] wrote: Hi Daniel The following is taken from the documentation of the Statement class (\System Documentation\Classes\Statement) Description A Statement object is used for executing a static SQL statement and obtaining the results it produces. Only one ResultSet per Statement can be open at any point in time. Therefore, if the reading of one ResultSet is interleaved with the reading of another, each must have been generated by different Statements. Remarks All statement execute methods implicitly close a statement's current ResultSet if an open one exists. Example{ Connection Con = new Connection(); Statement Stmt = Con.createStatement(); ResultSet R = Stmt.executeQuery('SELECT VALUE FROM SQLSYSTEMVARIABLES'); while ( R.next() ) { print R.getString(1); }} As I mentioned earlier you cannot use the Statement class if you want to execute X++ sql syntax Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights. From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 08:37To: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi Lennart, i'm not really understand what u mean by system class statement? i get solution from other group's member to suggest using something like: xppCompiler compiler = new xppCompiler(); str sql = 'void sql{select .}' if(compiler.compile) runbuf(sql); but it seems not working perfectly when i try in job cos the compiler.compile requesting param "str source". i've post this to him but no respond yet. u have any idea on this?will appreciate if u can provide an example. rgds, daniel Lennart Conrad [EMAIL PROTECTED] wrote: Hi Daniel Take a look at the system class Statement and its documentation. Note that the SQL syntax should be real SQL and not Axapta sql Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights. From: daniellim_yh [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 05:05To: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi all,in Axapta, can i do execution to a string like this:TempTableA _Tmp_Tbl; //TempTableA is Temp table in AxaptaExprstr = "delete_from _Tmp_Tbl where _Tbl.field1 == 'A'";then execute this query.i need the syntax to execute it. the reason i do like this becausethe string is a dynamically generated SQL string. i m using Axapta 3.0.pls help n thx in advance.rgds,danielSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Yahoo! Mail - Easier than ever with enhanced search. Learn more. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0
Hi Daniel If you want to execute DELETE/INSERT/UPDATE etc. you must use the executeUpdate() method instead. Lennart Conrad Microsoft Business Solutions This posting is provided AS IS with no warranties, and confers no rights. From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 10:47 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi Lennart, it works for select statement, but not with delete statement. my example as follow inside job: { Connection Con = new Connection(); Statement Stmt = Con.createStatement(); ResultSet R = Stmt.executeQuery('delete FROM TableA whereCustomerCode = \'AAI\''); } thx. daniel Lennart Conrad [EMAIL PROTECTED] wrote: Hi Daniel The following is taken from the documentation of the Statement class (\System Documentation\Classes\Statement) Description A Statement object is used for executing a static SQL statement and obtaining the results it produces. Only one ResultSet per Statement can be open at any point in time. Therefore, if the reading of one ResultSet is interleaved with the reading of another, each must have been generated by different Statements. Remarks All statement execute methods implicitly close a statement's current ResultSet if an open one exists. Example { Connection Con = new Connection(); Statement Stmt = Con.createStatement(); ResultSet R = Stmt.executeQuery('SELECT VALUE FROM SQLSYSTEMVARIABLES'); while ( R.next() ) { print R.getString(1); }} As I mentioned earlier you cannot use the Statement class if you want to execute X++ sql syntax Lennart Conrad Microsoft Business Solutions This posting is provided AS IS with no warranties, and confers no rights. From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 08:37 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi Lennart, i'm not really understand what u mean by system class statement? i get solution from other group's member to suggest using something like: xppCompiler compiler = new xppCompiler(); str sql = 'void sql{select .}' if(compiler.compile) runbuf(sql); but it seems not working perfectly when i try in job cos the compiler.compile requesting param str source. i've post this to him but no respond yet. u have any idea on this?will appreciate if u can provide an example. rgds, daniel Lennart Conrad [EMAIL PROTECTED] wrote: Hi Daniel Take a look at the system class Statement and its documentation. Note that the SQL syntax should be real SQL and not Axapta sql Lennart Conrad Microsoft Business Solutions This posting is provided AS IS with no warranties, and confers no rights. From: daniellim_yh [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 05:05 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi all, in Axapta, can i do execution to a string like this: TempTableA _Tmp_Tbl; //TempTableA is Temp table in Axapta Exprstr = delete_from _Tmp_Tbl where _Tbl.field1 == 'A'; then execute this query. i need the syntax to execute it. the reason i do like this because the string is a dynamically generated SQL string. i m using Axapta 3.0. pls help n thx in advance. rgds, daniel Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0
hi Lennart: i get it. using executeUpdate. thx very much for this. i really appreciate it. danielLennart Conrad [EMAIL PROTECTED] wrote: Hi Daniel The following is taken from the documentation of the Statement class (\System Documentation\Classes\Statement) Description A Statement object is used for executing a static SQL statement and obtaining the results it produces. Only one ResultSet per Statement can be open at any point in time. Therefore, if the reading of one ResultSet is interleaved with the reading of another, each must have been generated by different Statements. Remarks All statement execute methods implicitly close a statement's current ResultSet if an open one exists. Example{ Connection Con = new Connection(); Statement Stmt = Con.createStatement(); ResultSet R = Stmt.executeQuery('SELECT VALUE FROM SQLSYSTEMVARIABLES'); while ( R.next() ) { print R.getString(1); }} As I mentioned earlier you cannot use the Statement class if you want to execute X++ sql syntax Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights. From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 08:37To: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi Lennart, i'm not really understand what u mean by system class statement? i get solution from other group's member to suggest using something like: xppCompiler compiler = new xppCompiler(); str sql = 'void sql{select .}' if(compiler.compile) runbuf(sql); but it seems not working perfectly when i try in job cos the compiler.compile requesting param "str source". i've post this to him but no respond yet. u have any idea on this?will appreciate if u can provide an example. rgds, daniel Lennart Conrad [EMAIL PROTECTED] wrote: Hi Daniel Take a look at the system class Statement and its documentation. Note that the SQL syntax should be real SQL and not Axapta sql Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights. From: daniellim_yh [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 05:05To: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi all,in Axapta, can i do execution to a string like this:TempTableA _Tmp_Tbl; //TempTableA is Temp table in AxaptaExprstr = "delete_from _Tmp_Tbl where _Tbl.field1 == 'A'";then execute this query.i need the syntax to execute it. the reason i do like this becausethe string is a dynamically generated SQL string. i m using Axapta 3.0.pls help n thx in advance.rgds,danielSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Yahoo! Mail - Easier than ever with enhanced search. Learn more. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0
hi Lennart, how abt with param pass in?see below: { Connection Con = new Connection(); Statement Stmt = Con.createStatement();str _cust; _cust = 'ACT'; Stmt.executeUpdate('Delete FROM CSM_FG_LotNumberHoldTST_STP where CustomerCode = ' + _cust); } i test it and it didn't work. rgds, danielLennart Conrad [EMAIL PROTECTED] wrote: Hi Daniel If you want to execute DELETE/INSERT/UPDATE etc. you must use the executeUpdate() method instead. Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights. From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 10:47To: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi Lennart, it works for select statement, but not with delete statement. my example as follow inside job: { Connection Con = new Connection(); Statement Stmt = Con.createStatement(); ResultSet R = Stmt.executeQuery('delete FROM TableA whereCustomerCode = \'AAI\'');} thx. daniel Lennart Conrad [EMAIL PROTECTED] wrote: Hi Daniel The following is taken from the documentation of the Statement class (\System Documentation\Classes\Statement) Description A Statement object is used for executing a static SQL statement and obtaining the results it produces. Only one ResultSet per Statement can be open at any point in time. Therefore, if the reading of one ResultSet is interleaved with the reading of another, each must have been generated by different Statements. Remarks All statement execute methods implicitly close a statement's current ResultSet if an open one exists. Example{ Connection Con = new Connection(); Statement Stmt = Con.createStatement(); ResultSet R = Stmt.executeQuery('SELECT VALUE FROM SQLSYSTEMVARIABLES'); while ( R.next() ) { print R.getString(1); }} As I mentioned earlier you cannot use the Statement class if you want to execute X++ sql syntax Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights. From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 08:37To: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi Lennart, i'm not really understand what u mean by system class statement? i get solution from other group's member to suggest using something like: xppCompiler compiler = new xppCompiler(); str sql = 'void sql{select .}' if(compiler.compile) runbuf(sql); but it seems not working perfectly when i try in job cos the compiler.compile requesting param "str source". i've post this to him but no respond yet. u have any idea on this?will appreciate if u can provide an example. rgds, daniel Lennart Conrad [EMAIL PROTECTED] wrote: Hi Daniel Take a look at the system class Statement and its documentation. Note that the SQL syntax should be real SQL and not Axapta sql Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights. From: daniellim_yh [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 05:05To: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi all,in Axapta, can i do execution to a string like this:TempTableA _Tmp_Tbl; //TempTableA is Temp table in AxaptaExprstr = "delete_from _Tmp_Tbl where _Tbl.field1 == 'A'";then execute this query.i need the syntax to execute it. the reason i do like this becausethe string is a dynamically generated SQL string. i m using Axapta 3.0.pls help n thx in advance.rgds,danielSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Yahoo! Mail - Easier than ever with enhanced search. Learn more. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Yahoo! Mail - Find what you need with new enhanced search. Learn more. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0
hi Lennart, 1 more problem. its not working with Temp table in Axapta. i need to execute sql string that deal with temp table in axapta as well. any idea? rgds, danielLennart Conrad [EMAIL PROTECTED] wrote: Hi Daniel If you want to execute DELETE/INSERT/UPDATE etc. you must use the executeUpdate() method instead. Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights. From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 10:47To: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi Lennart, it works for select statement, but not with delete statement. my example as follow inside job: { Connection Con = new Connection(); Statement Stmt = Con.createStatement(); ResultSet R = Stmt.executeQuery('delete FROM TableA whereCustomerCode = \'AAI\'');} thx. daniel Lennart Conrad [EMAIL PROTECTED] wrote: Hi Daniel The following is taken from the documentation of the Statement class (\System Documentation\Classes\Statement) Description A Statement object is used for executing a static SQL statement and obtaining the results it produces. Only one ResultSet per Statement can be open at any point in time. Therefore, if the reading of one ResultSet is interleaved with the reading of another, each must have been generated by different Statements. Remarks All statement execute methods implicitly close a statement's current ResultSet if an open one exists. Example{ Connection Con = new Connection(); Statement Stmt = Con.createStatement(); ResultSet R = Stmt.executeQuery('SELECT VALUE FROM SQLSYSTEMVARIABLES'); while ( R.next() ) { print R.getString(1); }} As I mentioned earlier you cannot use the Statement class if you want to execute X++ sql syntax Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights. From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 08:37To: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi Lennart, i'm not really understand what u mean by system class statement? i get solution from other group's member to suggest using something like: xppCompiler compiler = new xppCompiler(); str sql = 'void sql{select .}' if(compiler.compile) runbuf(sql); but it seems not working perfectly when i try in job cos the compiler.compile requesting param "str source". i've post this to him but no respond yet. u have any idea on this?will appreciate if u can provide an example. rgds, daniel Lennart Conrad [EMAIL PROTECTED] wrote: Hi Daniel Take a look at the system class Statement and its documentation. Note that the SQL syntax should be real SQL and not Axapta sql Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights. From: daniellim_yh [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 05:05To: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi all,in Axapta, can i do execution to a string like this:TempTableA _Tmp_Tbl; //TempTableA is Temp table in AxaptaExprstr = "delete_from _Tmp_Tbl where _Tbl.field1 == 'A'";then execute this query.i need the syntax to execute it. the reason i do like this becausethe string is a dynamically generated SQL string. i m using Axapta 3.0.pls help n thx in advance.rgds,danielSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Yahoo! Mail - Easier than ever with enhanced search. Learn more. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Yahoo! Mail - Find what you need with new enhanced search. Learn more. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Small Business - Try our new resources site! Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Re: Demand Planner
Hi First of all, let me state that Im not a developer. I will try to explain why the two tables are not accessible from the AOT. When you create a table in the AOT, Axapta adds the not null columns recid to the table, which is an internal Axapta column. This is basically the problem, because the two tables are populated by the Demand Planner integration business logic. The Demand Planner business logic is written as stored procedures in the Demand Planner database and obtaining the recid through SQL could cause problems that cant be foreseen beforehand. Look at the two tables as two flat files placed in the database instead of on the file system. This is just a rough assumption. With regards to the Demand Planner code, it probably looks different than the rest of the Axapta code due to the fact it reads data from the two external tables. /Flemming From: Harry Deshpande [mailto:[EMAIL PROTECTED] Sent: 15. marts 2005 20:59 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Re: Demand Planner Hi It does not matter who is the owner of these tables, the tables are created in Axapta database so they have to follow Axapta naming convention. They have to be accessible from AOT. I am completely lost by your statement that Demand planner would not be able to populate these tables if they were created within Axapta AOT. Why not? As to the code, look at the demand planner code and look at the code in rest of Axapta. Regards harry Harry Deshpande Senior Consultant CGNZ Middle Market Solutions Website: www.cgnz.com/middlemarketsolutions Ph +64 29 289 9031 Fax +64 9 358 1018 CGNZ Limited and its predecessor organisations (Cap Gemini Ernst Young, and Ernst Young Consulting) have a proud track record of market leadership and excellent service delivery in all areas of systems delivery both for New Zealand clients and in supporting regional and global projects. CGNZ is a licensed affiliate of Cap Gemini S.A. (one of the worlds leading management consulting and IT services companies), wholly owned by NZ employee-shareholders, with over 150 IT professionals in our Auckland and Wellington offices. Middle Market Solutions specialises in the implementation of business solutions for small corporate and middle market companies. The core activity of our team is the implementation and support of Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), E-Business solutions and related technologies from Microsoft Business Solutions. Find out more about what we do at http://www.cgnz.com/middlemarketsolutions CGNZ DISCLAIMER: This email and any attachments are confidential and intended exclusively for the person to whom the email is addressed. If you are not the intended recipient, do not read, copy, disclose or use the contents in any way. Please notify us immediately by return email and destroy the email and attachments. CGNZ does not accept any liability for any changes made to this email or attachments after sending by CGNZ. You must scan this email and attachments for viruses. The opinions expressed are not necessarily those of CGNZ. CGNZ accepts no liability for any loss, damage or consequence, whether caused by our own negligence or not, resulting directly or indirectly from the use of this email and attachments. From: Flemming Birch-Rasmussen [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 March 2005 11:10 p.m. To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Re: Demand Planner The two tables that you mention is not owned by Axapta, but owned by Demand Planner and hence the names. The two tables are installed when you install the Demand Planner and this is the reason for them not being available in the AOT. It is the Demand Planner responsibility to populate these tables and the Demand Planner wouldnt be able to populate the tables correctly if they Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] form splitter
Hi, Can anyone help me?I have problem when i'm trying to use form splitter,,See, the lines tab doesn't want to go below the spliter. But if i maximized the form,it does. Anyone has experienced on this?Am i missing something to set in the properties? Thank you, Immanuel P Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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/ attachment: help.jpg
[Axapta-Knowledge-Village] Re: form splitter
put columns property of your form to 1 greetings Koen --- In Axapta-Knowledge-Village@yahoogroups.com, Immanuel [EMAIL PROTECTED] wrote: Hi, Can anyone help me?I have problem when i'm trying to use form splitter,,See, the lines tab doesn't want to go below the spliter. But if i maximized the form,it does. Anyone has experienced on this?Am i missing something to set in the properties? Thank you, Immanuel P Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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] execute a SQL string in Axapta 3.0
Please remember to filter by DATAAREAID when using the Statemant class. VardenMorris J. Wray Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I. Phone: (876) - 923 - 6141 Ext. 2226Fax: (876) - 923 -5372 Cell: (876) - 3833566Email: [EMAIL PROTECTED] [EMAIL PROTECTED]daniel lim [EMAIL PROTECTED] wrote: hi Lennart, it works for select statement, but not with delete statement. my example as follow inside job: { Connection Con = new Connection(); Statement Stmt = Con.createStatement(); ResultSet R = Stmt.executeQuery('delete FROM TableA whereCustomerCode = \'AAI\'');} thx. daniel Lennart Conrad [EMAIL PROTECTED] wrote: Hi Daniel The following is taken from the documentation of the Statement class (\System Documentation\Classes\Statement) Description A Statement object is used for executing a static SQL statement and obtaining the results it produces. Only one ResultSet per Statement can be open at any point in time. Therefore, if the reading of one ResultSet is interleaved with the reading of another, each must have been generated by different Statements. Remarks All statement execute methods implicitly close a statement's current ResultSet if an open one exists. Example{ Connection Con = new Connection(); Statement Stmt = Con.createStatement(); ResultSet R = Stmt.executeQuery('SELECT VALUE FROM SQLSYSTEMVARIABLES'); while ( R.next() ) { print R.getString(1); }} As I mentioned earlier you cannot use the Statement class if you want to execute X++ sql syntax Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights. From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 08:37To: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi Lennart, i'm not really understand what u mean by system class statement? i get solution from other group's member to suggest using something like: xppCompiler compiler = new xppCompiler(); str sql = 'void sql{select .}' if(compiler.compile) runbuf(sql); but it seems not working perfectly when i try in job cos the compiler.compile requesting param "str source". i've post this to him but no respond yet. u have any idea on this?will appreciate if u can provide an example. rgds, daniel Lennart Conrad [EMAIL PROTECTED] wrote: Hi Daniel Take a look at the system class Statement and its documentation. Note that the SQL syntax should be real SQL and not Axapta sql Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights. From: daniellim_yh [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 05:05To: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 hi all,in Axapta, can i do execution to a string like this:TempTableA _Tmp_Tbl; //TempTableA is Temp table in AxaptaExprstr = "delete_from _Tmp_Tbl where _Tbl.field1 == 'A'";then execute this query.i need the syntax to execute it. the reason i do like this becausethe string is a dynamically generated SQL string. i m using Axapta 3.0.pls help n thx in advance.rgds,danielSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Yahoo! Mail - Easier than ever with enhanced search. Learn more. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Yahoo! Mail - Find what you need with new enhanced search. Learn more. Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Do you know any Axapta consultant firm in Kazakstan or Russia
Hello Burak Yolcu, , 16 2005 ., you wrote: http://erp.lanit.ru - MBS Gold Partner -- Best regards, Max http://belugin.newmail.ru ICQ:9406811 Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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] Do you know any Axapta consultant firm in Kazakstan or Russia
Hello Burak Yolcu, , 16 2005 ., you wrote: BY Hi All, I need to meet an ERP consutnat firm that serves for BY Axapta in Kazakstan. Do you konow any partner which hass office in BY KAzakstan or near KAzakstan. may be Moskow. BY BY Thanks in advance for your attenttion. Sorry, we have office at Moscow, and other departments of LANIT have clients in Kazakhstan, but we have no Axapta implementations in Kz. -- Best regards, Max http://belugin.newmail.ru ICQ:9406811 Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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/
AW: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0
ehhhmm temporary tables are not really tables - they only exist in Axapta but not in SQL / Oracle. So you will never get any data from a temp table this way... Tobias -Ursprngliche Nachricht- Von: daniel lim [mailto:[EMAIL PROTECTED] Gesendet: Mi 16.03.2005 11:09 An: Axapta-Knowledge-Village@yahoogroups.com Cc: Betreff: RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0 Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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/ winmail.dat
RE: [Axapta-Knowledge-Village] Do you know any Axapta consultant firm in Kazakstan or Russia
Try: http://www.columbusit.com/ Rgds, Hans. -Original Message- From: Max Belugin [mailto:[EMAIL PROTECTED] Sent: Mircoles, 16 de Marzo de 2005 06:46 am To: Burak Yolcu Subject: Re: [Axapta-Knowledge-Village] Do you know any Axapta consultant firm in Kazakstan or Russia Hello Burak Yolcu, , 16 2005 ., you wrote: BY Hi All, I need to meet an ERP consutnat firm that serves for Axapta BY in Kazakstan. Do you konow any partner which hass office in BY KAzakstan or near KAzakstan. may be Moskow. BY BY Thanks in advance for your attenttion. Sorry, we have office at Moscow, and other departments of LANIT have clients in Kazakhstan, but we have no Axapta implementations in Kz. -- Best regards, Max http://belugin.newmail.ru ICQ:9406811 Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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/
[Axapta-Knowledge-Village] Eletronic Banking
Hello, Someone had´s more information aobut eletornic banking and payment step, payment specification and bank fee? Thanks in advance Rodrigo Matiazo, Cadia Consulting do Brasil MBS Partner Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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/
[Axapta-Knowledge-Village] Costing Production
Hi all: My production is diveded in 2 pools. 1) I have 5 differents subproducts, 1 of them I produce and the other 4 I buy them from different supliers. These 5 subproducts are similar, meaning they are alternative items for the final production. These 5 subproducts have 5 different ledger accounts. 2) I produce 5 differents finished products (A,B,C,D,E). When producing for example A I can use subproduct 1 or subproduct 2...etc So if using Production Groups, in the field Picking List I would need to choose one of my 9 ledger accounts. If using Item Groups it would be the same case. How can I configure this scenario??? Does anybody know?. Thanks. Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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/
[Axapta-Knowledge-Village] Fwd: Freelancing work in Axapta
Note: forwarded message attached. Do you Yahoo!? Yahoo! Small Business - Try our new resources site! Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service. ---BeginMessage--- Hello guys, i am looking for some freelancing work in Axapta. Is anybody looking to give away freelance jobs in axapta development or can somebody suggest me the similar oppurtunities. bye __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---End Message---
Re: [Axapta-Knowledge-Village] Sql Error
Hi, What Database UserId and Password u r using to login to the SQL Server? Is it Sa or standard BMSSA login? or U hv created a new DBO? SMitra On Wed, 16 Mar 2005 11:17:52 -0800, Craig Fidler [EMAIL PROTECTED] wrote: Using sql backup restore functionality From: Ozanhan Anaç [mailto:[EMAIL PROTECTED] Sent: 16 March, 2005 1:11 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Sql Error To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Sql Error How did you get the backup file to 2nd server? I had an interesting experience : When i move the backup file using compressing tools i get this error, but when i move backup file directly i didnt get this error. Please try and let me know the result Ozan From: Craig Fidler [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 16, 2005 8:34 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Sql Error Thanks but still getting the same error From: Van Den Langenbergh Gunther [mailto:[EMAIL PROTECTED] Sent: 16 March, 2005 12:17 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Sql Error try this From: Craig Fidler [mailto:[EMAIL PROTECTED] Sent: woensdag 16 maart 2005 19:14 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Sql Error Still receiving this error From: Subha Mitra [mailto:[EMAIL PROTECTED] Sent: 14 March, 2005 9:39 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Sql Error Hi, This is not a problem with Axapta but in Sql DataBase(orphaned users). Steps To Resolve Orphaned Users Problem 1. Run the following command for the orphaned user from the preceding step: Use AXDB go sp_change_users_login Auto_fix, 'bmssa' This relinks the server login bmssa with the the AXDB database user bmssa. 2. Executing the sp_change_users_login procedure with the optional Auto_Fix option may create logins with a NULL password for users without an existing corresponding login.Change the password by using SP_PASSWORD Stored procedure. SMitra On Mon, 14 Mar 2005 14:41:14 -0800, Craig Fidler [EMAIL PROTECTED] wrote: Hi, Help would be appreciated. I have a client that is running Axapta 3 with SP2 loaded. They are running SQL patched with 3.0a. What they have done is created a new database. Taken their existing database backed it up and then force restored it into the new database they have created. Now when you backup the database and try to restore it on another server, it restores however as soon as you fire of the Axapta client, Axapta returns an error with regards the SQLSYSTEMVARIABLE table. Anyone ever have a similar problem and how would I go about fixing the problem? Thanks in advance Craig The views expressed in this email are, unless otherwise stated, those of the author and not those of the BS3 Technologies Group or its management. The information in this e-mail is confidential and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data transmitted electronically and to preserve the confidentiality thereof, no liability or responsibility whatsoever is accepted if information or data is, for whatever reason corrupted or does not reach its intended destination. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service. -- Subha Mitra Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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
[Axapta-Knowledge-Village] Negative Inventory after posting Picking List ( urgent )
Hi; I have a huge problem at my customer. Customer started to complete production order and after posting picking list I have seen some inventory dimensions has negative stock. I have found the bug but I do not know how to solve it... Warehouse is ware_1 Item A has 2 konfigurations Con_1 and Con_2 . I am using batch number and I have a batch number Batch_1 When I check my on hand stock I see ** Con_1 Ware_1 Batch_11000 pcs avaliable In my picking list on production order I need 300 pcs Con_2 User who type picking list to system entered like this and posted Con_2 Ware_1 Batch_1 300 and posted with out any error. Now If I chekc my on hand stock I see 2 lines Con_1 Ware_1 Batch_1 1000 pcs avaliable Con_2 Ware_1 Batch_1 -300 pcs avaliable Has anybody faced this problem before ??? Is there any solution ? Gkhan CAN Yahoo! Groups Sponsor ~-- What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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/ winmail.dat
[Axapta-Knowledge-Village] Re: Demand Planner
Hi are populated by the Demand Planner integration business logic. The Demand Planner business logic is written as stored procedures in the Demand Planner database and obtaining the recid through SQL could cause problems that cant be foreseen beforehand. ** These problems can be taken care of. Not a big deal. There are too many problems with not including this table in AOT for eg. Class DatabaseTransDelete will not touch this table, you cannot make it virtual, i am not sure if one copies the company this table is going to get copied etc etc etc. With regards to the Demand Planner code, it probably looks different than the rest of the Axapta code due to the fact it reads data from the two external tables. ** Thats just one of the reason, the code also does not strictly ahere to the axapta programming standards. Regards Harry Ps: I think we need to stop this discussion now. You are convinced that demand planner is good, i am convinced it is ugly and I dont think either of us is going to change the position *s* __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] (unknown)
hi Exactly what error are you getting? regards harry From: Murukesu abarana [mailto:[EMAIL PROTECTED] Sent: Wednesday, 16 March 2005 4:24 p.m.To: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] (unknown) Hi,I cannot post good quantity and error quantity inreport as finished journal. and error quantity andgood quantity have difference warehouse also.let me know how i can post and is it any parametersetting anywhere?thanks,Chi__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Small Business - Try our new resources site! Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Do you know any Axapta consultant firm in Kazakstan or Russia
Try www.iteration2.com - Original Message - From: Max Belugin [EMAIL PROTECTED] To: Burak Yolcu Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Do you know any Axapta consultant firm in Kazakstan or Russia Date: Wed, 16 Mar 2005 15:45:47 +0300 Hello Burak Yolcu, , 16 2005 ., you wrote: BY Hi All, I need to meet an ERP consutnat firm that serves for BY Axapta in Kazakstan. Do you konow any partner which hass office in BY KAzakstan or near KAzakstan. may be Moskow. BY BY Thanks in advance for your attenttion. Sorry, we have office at Moscow, and other departments of LANIT have clients in Kazakhstan, but we have no Axapta implementations in Kz. -- Best regards, Max http://belugin.newmail.ru ICQ:9406811 Sharing the knowledge on Axapta. Yahoo! Groups Links -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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/
[Axapta-Knowledge-Village] Lifesciences/ HMS
Hi all, Just wanted to know if any of you have some information regarding Axapta used as a platform for any Hospital Management System or Lifescience work! Any one made such product or is working on it pls share. Is there any such work on run? Regards Priyanka Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Lifesciences/ HMS
Hi, Arelease from Microsoft specific to the Life Sciences industry will be made in end Q2 2005. Regards -Bidyut -Original Message-From: PR [mailto:[EMAIL PROTECTED]Sent: Thursday, March 17, 2005 11:06 AMTo: Axapta-Knowledge-Village@yahoogroups.com; development-axapta@yahoogroups.comSubject: [Axapta-Knowledge-Village] Lifesciences/ HMS Hi all, Just wanted to know if any of you have some information regarding Axapta used as a platform for any Hospital Management System or Lifescience work! Any one made such product or is working on it pls share. Is there any such work on run? Regards PriyankaSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Lifesciences/ HMS
Bidyut, YesI m aware that Axapta 4.0 will have lifesciences.I wanted to know if there is any implementationor any on going work in Axapta for this field ! Thanx Priyanka - Original Message - From: Chowdhury B.K To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, March 17, 2005 11:16 AM Subject: RE: [Axapta-Knowledge-Village] Lifesciences/ HMS Hi, Arelease from Microsoft specific to the Life Sciences industry will be made in end Q2 2005. Regards -Bidyut -Original Message-From: PR [mailto:[EMAIL PROTECTED]Sent: Thursday, March 17, 2005 11:06 AMTo: Axapta-Knowledge-Village@yahoogroups.com; development-axapta@yahoogroups.comSubject: [Axapta-Knowledge-Village] Lifesciences/ HMS Hi all, Just wanted to know if any of you have some information regarding Axapta used as a platform for any Hospital Management System or Lifescience work! Any one made such product or is working on it pls share. Is there any such work on run? Regards PriyankaSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Lifesciences/ HMS
Priyanka - There are partner solutions for the life sciences industry. You may avail a listing from the add-on solutions catalog available on partnersource. Alsosearch for case studies and implementation references from partnersource/ partner sites. Regards -Bidyut -Original Message-From: PR [mailto:[EMAIL PROTECTED]Sent: Thursday, March 17, 2005 11:23 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Lifesciences/ HMS Bidyut, YesI m aware that Axapta 4.0 will have lifesciences.I wanted to know if there is any implementationor any on going work in Axapta for this field ! Thanx Priyanka - Original Message - From: Chowdhury B.K To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, March 17, 2005 11:16 AM Subject: RE: [Axapta-Knowledge-Village] Lifesciences/ HMS Hi, Arelease from Microsoft specific to the Life Sciences industry will be made in end Q2 2005. Regards -Bidyut -Original Message-From: PR [mailto:[EMAIL PROTECTED]Sent: Thursday, March 17, 2005 11:06 AMTo: Axapta-Knowledge-Village@yahoogroups.com; development-axapta@yahoogroups.comSubject: [Axapta-Knowledge-Village] Lifesciences/ HMS Hi all, Just wanted to know if any of you have some information regarding Axapta used as a platform for any Hospital Management System or Lifescience work! Any one made such product or is working on it pls share. Is there any such work on run? Regards PriyankaSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Lifesciences/ HMS
yes... I have worked for that Indian project so know well of it. Tell me about NAFA and Fresenius Medical care. were they dealing with pharmacy only as Taksal or with Hospital Management as well i mean administrative portion or clinical portion if it is case of HMS. Any idea? The case studies in partnersource are mainly of molecular level Lifescience. - Priyanka - Original Message - From: Jim Jo To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, March 17, 2005 11:51 AM Subject: Re: [Axapta-Knowledge-Village] Lifesciences/ HMS Taksal in india !:-). NAFA is K.S.A and 'Fresenius Medical Care' at some locations uses Axapta. Regards Abin PR [EMAIL PROTECTED] wrote: Hi, Yes I have checked all case studies. just wanted to know if apart from that there has been any usage of Axapta in medical grounds. Just to confirm. Cheers Priyanka - Original Message - From: Chowdhury B.K To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, March 17, 2005 11:39 AM Subject: RE: [Axapta-Knowledge-Village] Lifesciences/ HMS Priyanka - There are partner solutions for the life sciences industry. You may avail a listing from the add-on solutions catalog available on partnersource. Alsosearch for case studies and implementation references from partnersource/ partner sites. Regards -Bidyut -Original Message-From: PR [mailto:[EMAIL PROTECTED]Sent: Thursday, March 17, 2005 11:23 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Lifesciences/ HMS Bidyut, YesI m aware that Axapta 4.0 will have lifesciences.I wanted to know if there is any implementationor any on going work in Axapta for this field ! Thanx Priyanka - Original Message - From: Chowdhury B.K To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, March 17, 2005 11:16 AM Subject: RE: [Axapta-Knowledge-Village] Lifesciences/ HMS Hi, Arelease from Microsoft specific to the Life Sciences industry will be made in end Q2 2005. Regards -Bidyut -Original Message-From: PR [mailto:[EMAIL PROTECTED]Sent: Thursday, March 17, 2005 11:06 AMTo: Axapta-Knowledge-Village@yahoogroups.com; development-axapta@yahoogroups.comSubject: [Axapta-Knowledge-Village] Lifesciences/ HMS Hi all, Just wanted to know if any of you have some information regarding Axapta used as a platform for any Hospital Management System or Lifescience work! Any one made such product or is working on it pls share. Is there any such work on run? Regards PriyankaSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Make Yahoo! your home page Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Lifesciences/ HMS
:) .. I very well know that you have worked on Taksal ! About NAFA .. Name Nafa is changed now .. But fyi .. Nafa uses Axapta for SD only (as far as I know). Fresenius Medical care has a number of locations. Again I am sorry,i dont have enoughinfo on how much they are using Axapta !. Check http://www.microsoft.com/danmark/ .. you may get more info ... but need to translate the site ... :) Abin PR [EMAIL PROTECTED] wrote: yes... I have worked for that Indian project so know well of it. Tell me about NAFA and Fresenius Medical care. were they dealing with pharmacy only as Taksal or with Hospital Management as well i mean administrative portion or clinical portion if it is case of HMS. Any idea? The case studies in partnersource are mainly of molecular level Lifescience. - Priyanka - Original Message - From: Jim Jo To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, March 17, 2005 11:51 AM Subject: Re: [Axapta-Knowledge-Village] Lifesciences/ HMS Taksal in india !:-). NAFA is K.S.A and 'Fresenius Medical Care' at some locations uses Axapta. Regards Abin PR [EMAIL PROTECTED] wrote: Hi, Yes I have checked all case studies. just wanted to know if apart from that there has been any usage of Axapta in medical grounds. Just to confirm. Cheers Priyanka - Original Message - From: Chowdhury B.K To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, March 17, 2005 11:39 AM Subject: RE: [Axapta-Knowledge-Village] Lifesciences/ HMS Priyanka - There are partner solutions for the life sciences industry. You may avail a listing from the add-on solutions catalog available on partnersource. Alsosearch for case studies and implementation references from partnersource/ partner sites. Regards -Bidyut -Original Message-From: PR [mailto:[EMAIL PROTECTED]Sent: Thursday, March 17, 2005 11:23 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Lifesciences/ HMS Bidyut, YesI m aware that Axapta 4.0 will have lifesciences.I wanted to know if there is any implementationor any on going work in Axapta for this field ! Thanx Priyanka - Original Message - From: Chowdhury B.K To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, March 17, 2005 11:16 AM Subject: RE: [Axapta-Knowledge-Village] Lifesciences/ HMS Hi, Arelease from Microsoft specific to the Life Sciences industry will be made in end Q2 2005. Regards -Bidyut -Original Message-From: PR [mailto:[EMAIL PROTECTED]Sent: Thursday, March 17, 2005 11:06 AMTo: Axapta-Knowledge-Village@yahoogroups.com; development-axapta@yahoogroups.comSubject: [Axapta-Knowledge-Village] Lifesciences/ HMS Hi all, Just wanted to know if any of you have some information regarding Axapta used as a platform for any Hospital Management System or Lifescience work! Any one made such product or is working on it pls share. Is there any such work on run? Regards PriyankaSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Make Yahoo! your home page Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Small Business - Try our new resources site! Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] operation from combination of enum
hi all, i have 2 enum type, 4 elements each, i wonder wat is the best way for me to do like this in axapta. if (enum1::typeA enum2::typeW) Do something1 else if (enum1::typeA enum2::typeX) Do something 2 else if (enum1::typeA enum2::typeY) do something 3 . . . . if (enum1::typeD enum2::Z) do something 16 with 2 combinations of 2 enums i will have 16 combinations, any better way of it?using enum element position to do looping may be?but as i know i cannot get enum position like container. pls provide any idea. thx in advance. rgds, daniel Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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] Lifesciences/ HMS
Yes Abin i know that u know !!! ;-) Ok thanx for the info u gave i will check it.. without translation . Bye Abin - priyanka - Original Message - From: Jim Jo To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, March 17, 2005 12:17 PM Subject: Re: [Axapta-Knowledge-Village] Lifesciences/ HMS :) .. I very well know that you have worked on Taksal ! About NAFA .. Name Nafa is changed now .. But fyi .. Nafa uses Axapta for SD only (as far as I know). Fresenius Medical care has a number of locations. Again I am sorry,i dont have enoughinfo on how much they are using Axapta !. Check http://www.microsoft.com/danmark/ .. you may get more info ... but need to translate the site ... :) Abin yes... I have worked for that Indian project so know well of it. Tell me about NAFA and Fresenius Medical care. were they dealing with pharmacy only as Taksal or with Hospital Management as well i mean administrative portion or clinical portion if it is case of HMS. Any idea? The case studies in partnersource are mainly of molecular level Lifescience. - Priyanka - Original Message - From: Jim Jo To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, March 17, 2005 11:51 AM Subject: Re: [Axapta-Knowledge-Village] Lifesciences/ HMS Taksal in india !:-). NAFA is K.S.A and 'Fresenius Medical Care' at some locations uses Axapta. Regards Abin PR wrote: Hi, Yes I have checked all case studies. just wanted to know if apart from that there has been any usage of Axapta in medical grounds. Just to confirm. Cheers Priyanka - Original Message - From: Chowdhury B.K To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, March 17, 2005 11:39 AM Subject: RE: [Axapta-Knowledge-Village] Lifesciences/ HMS Priyanka - There are partner solutions for the life sciences industry. You may avail a listing from the add-on solutions catalog available on partnersource. Alsosearch for case studies and implementation references from partnersource/ partner sites. Regards -Bidyut -Original Message-From: PR [mailto:[EMAIL PROTECTED]Sent: Thursday, March 17, 2005 11:23 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Lifesciences/ HMS Bidyut, YesI m aware that Axapta 4.0 will have lifesciences.I wanted to know if there is any implementationor any on going work in Axapta for this field ! Thanx Priyanka - Original Message - From: Chowdhury B.K To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, March 17, 2005 11:16 AM Subject: RE: [Axapta-Knowledge-Village] Lifesciences/ HMS Hi, Arelease from Microsoft specific to the Life Sciences industry will be made in end Q2 2005. Regards -Bidyut -Original Message-From: PR [mailto:[EMAIL PROTECTED]Sent: Thursday, March 17, 2005 11:06 AMTo: Axapta-Knowledge-Village@yahoogroups.com; development-axapta@yahoogroups.comSubject: [Axapta-Knowledge-Village] Lifesciences/ HMS Hi all, Just wanted to know if any of you have some information regarding Axapta used as a platform for any Hospital Management System or Lifescience work! Any one made such product or is working on it pls share. Is there any such work on run? Regards PriyankaSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Make Yahoo! your home page Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Yahoo! Small Business - Try our new resources site!
Re: [Axapta-Knowledge-Village] operation from combination of enum
Hello daniellim_yh, ÷åòâåðã, 17 ìàðòà 2005 ã., you wrote: d i have 2 enum type, 4 elements each, i wonder wat is the best way d for me to do d like this in axapta. - you can use macro with template like if(a==%1 a==%2) %3; - you can declare action pair map like: [[value1, value2, action], where action is: name of local function (use runbuf for call) or object (use Command design pattern) -- Best regards, Max http://belugin.newmail.ru ICQ:9406811 Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. 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/