Re: [Axapta-Knowledge-Village] Data Encrption
Well, it's possible... Easiest way would be to encrypt the presentation of data (edit and display methods anywhere) instead of encrypt data into DDBB. Or if you choose the Harders one,... You should then implement some proper algorythm (the encryption method of Dictionary won't fill all your needs, in special lenght of field to be stored), and use it in write() to encrypt data and uncrypt data in display or edir methods in form, but you must assure the data is absolutly consistently encrypted along all tables in DDBB (doubt to table and data interrelations & interdependencies). So, be extremely careful!! And this won't control the DOupdates or DOinserts methods... danger, danger... And OK, you would protect data in forms and DDBB, but some programmer can access easily to the algorythm, and public algorythms of encryption are very expensive in terms of computing-time. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS "abdulabsi" <[EMAIL PROTECTED]> Enviado por: Axapta-Knowledge-Village@yahoogroups.com 18/07/2005 13:08 Por favor, responda a Axapta-Knowledge-Village@yahoogroups.com Para Axapta-Knowledge-Village@yahoogroups.com cc Asunto [Axapta-Knowledge-Village] Data Encrption Dear All, One question regarding Data encryption in Axapta.I am not sure if it is possible to implment the following scenario in Axapta. 1-One User entered new records in one form say CustTable. 2-he pressed a button Say"Encrpyt Data befor sending to the DB."... 3-Data is encrypted and stored in the DB 4-when Others came to view it,They should enter the Decrytpion key to be able to view it correctly.Otherwize,garbage should be viewed. Is this doable throw Axapta, or SQL please Advise if you have any idea in this regards Worm Regards, Absi 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/ Sharing the knowledge on Axapta. 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] Localmacro help please
Interesting, indeed!!
Raúl Llorente Peña
Análisis, Desarrollo e Implementación en
Microsoft Bussiness Solutions-Axapta
OPEN SOLUTIONS
"DouglasT" <[EMAIL PROTECTED]>
Enviado por: Axapta-Knowledge-Village@yahoogroups.com
11/07/2005 11:04
Por favor, responda a
Axapta-Knowledge-Village@yahoogroups.com
Para
cc
Asunto
Re: [Axapta-Knowledge-Village] Localmacro
help please
this is the so called "48 feature" it
doesn't have anything to do directly
with localmacros or containers.
you'll get the same internal compiler overflow "hey what are you doing"
using update_recordset command with more than 48 fields to set.
in this case you have NO chance beside "duplicating" the update_recordset
call setting the next fields.
btw: does anyone have reported this already (and have got an usable answer)
?
regards
Douglas
- Original Message -
From: "Sonny Wibawa Adi" <[EMAIL PROTECTED]>
To:
Sent: Friday, July 08, 2005 11:09 AM
Subject: Re: [Axapta-Knowledge-Village] Localmacro help please
> Hi, Hennie Potgieter,
>
>
> Axapta has a stack memory limitation for total
> elements in a container. You may solve this problem by
> reducing the total elements in a container by dividing
> them into containers.
> I tried to create a container and as I know, the
> maximum element is 48.
>
> You can change the macro in classDeclaration, pack and
> unpack method:
>
> //classdeclaration
> class MyReport extends RunBaseReport
> {
> #localmacro.CurrentList1
> a1,
> a2,
> //... 48 elements
> a48
> #endmacro
> #localmacro.CurrentList2
> b1,
> b2,
> //... 48 elements
> b48
> #endmacro
> #localmacro.CurrentList3
> c1,
> c2,
> //... 48 elements
> c48
> #endmacro
> }
>
> public container pack()
> {
> return [#CurrentVersion,
> [#CurrentList1],
> [#CurrentList2],
> [#CurrentList3],
> super()];
> }
>
> public boolean unpack(container packedClass)
> {
> int version
=
> runbase::getVersion(packedClass);
> Container con;
> Container con1;
> Container con2;
> Container con3;
>
> switch (version)
> {
> case #CurrentVersion:
> [version,con1,con2,con3,con]
=
> packedClass;
> [#CurrentList1] = con1;
> [#CurrentList2] = con2;
> [#CurrentList3] = con3;
> return super(con);
> default :
> return false;
> }
>
> return false;
> }
>
> Good luck!
>
> Regards,
>
> Sonny Wibawa Adi, MBCSP, MCAD.NET, MCSD.NET, MCP
>
>
> --- Hennie Potgieter <[EMAIL PROTECTED]> wrote:
>
>> Hi all,
>>
>> When a localmacro list object is defined in the
>> classDeclaration, only a
>> certain number of variables are allowed. The pack
>> and unpack methods
>> gives the following compiler error: "Overflow in an
>> internal compiler
>> stack."
>>
>> #LOCALMACRO.ParmList
>> parmId,
>> .
>> .
>> //variable list of 108 variables
>> #ENDMACRO
>>
>> Is this an Axapta problem? Should more than 1
>> localmacro list object be
>> used? How would more than 1 localmacro list object
>> be implemented?
>>
>> -*
>> Hennie Potgieter
>> Senior Business Analyst
>> UTi SUN Couriers Division
>> Centurion, South Africa
>> Cell: 0829208315
>> mailto:
>> [EMAIL PROTECTED]
>>
>>
>>
>
>
> __
> 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 Links
>
>
>
>
>
>
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/
Sharing the knowledge on Axapta.
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] Localmacro help please
Well, some long time ago I tried to put some code in Macros. I've tested that from some point, the code is "ignored". Just try to create a localmacro with a throath of print 1; print 2; etc... print 1000 You'll see that calling this macro doesn't print all lines... Perhaps this is the cause of your overflow. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS "Hennie Potgieter" <[EMAIL PROTECTED]> Enviado por: Axapta-Knowledge-Village@yahoogroups.com 08/07/2005 10:13 Por favor, responda a Axapta-Knowledge-Village@yahoogroups.com Para cc Asunto [Axapta-Knowledge-Village] Localmacro help please Hi all, When a localmacro list object is defined in the classDeclaration, only a certain number of variables are allowed. The pack and unpack methods gives the following compiler error: "Overflow in an internal compiler stack." #LOCALMACRO.ParmList parmId, . . //variable list of 108 variables #ENDMACRO Is this an Axapta problem? Should more than 1 localmacro list object be used? How would more than 1 localmacro list object be implemented? -* Hennie Potgieter Senior Business Analyst UTi SUN Couriers Division Centurion, South Africa Cell: 0829208315 mailto: [EMAIL PROTECTED] Sharing the knowledge on Axapta. 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. 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] Ax 2.1 with SQL2000 wnd Windows 2003
I Agree Malcolm. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS "Malcolm Burtt" <[EMAIL PROTECTED]> Enviado por: Axapta-Knowledge-Village@yahoogroups.com 24/06/2005 09:35 Por favor, responda a Axapta-Knowledge-Village@yahoogroups.com Para cc Asunto RE: [Axapta-Knowledge-Village] Ax 2.1 with SQL2000 wnd Windows 2003 Hi James Our first experience of Axapta was with version 2.1 running on SQL 2000, so I know that works. I don't recall having to do anything special to make it work (probably just as well as we were SQL Server & Axapta newbies at the time). We have always run inside terminal services and don't get any problems with that either. You will need to install Axapta through the Add/Remove programs function in Windows (or execute the command "Change user /install" before installing and then "Change user /execute" afterwards) or it won't load correctly. I would install 2.1 as described above from the installation CD (including applying any services packs using the same approach) then replace the Appl directory with your existing one. Hope that helps. Regards Malcolm Burtt Global IT Group "Business Solutions designed for YOUR business processes" Global IT Group is the trading name of Touchstone Global Business Solutions Ltd. and is part of the Touchstone Group PLC. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED]On Behalf Of James Flavell Sent: 24 June 2005 00:42 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Ax 2.1 with SQL2000 wnd Windows 2003 Hi I hope some out there are able to help with a rather old setup... I have a customer who is running Ax2.1 and they are very happy with it, therefore they do not want to have to go through all the trouble of upgrading etc but they want to run on SQL2000 (due to IT audit security concerns etc). Does anyone know if it is possible to run Ax2.1 with SQL2000? I know it will not work straight out of the box as I recall for Ax2.5 there was some configuration on SQL you had to do (something about Axapta and SQL reserved words clashing so you had to turn off some features in SQL...or something like that...) Anyone have an actual site/experience with this configuration? Also they want to run on Windows 2003 via terminal services, to move the application to such a machine what is the best approach? 1) install a standard ax2.1 and then delete the folders and replace with the actual application? OR 2) just copy the files to new server (I think this has possible system files not registered problems right) Is there any know issues with Windows 2003 termainl services and axapta? Hoping some one can help Thanks James Sharing the knowledge on Axapta. 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 the Yahoo! Terms of Service. 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 the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Number Sequence in Number Group form
AFAIK number sequence is usually the id of the number sequence that will be used to generate a unique ID... take a look over numbersequencetable. This code is used by the numseq (and similar) classes to know which numbersequence to use. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Why sentence try/catch is invisible for COM sessions in 2.5?
Well, let's suppose your code works...
If I try to catch any error thrown in
Axapta (this, is, NOT thrown by me!!). it doesn't matter whatever error/exception
it is, I'm not able to catch it in a COM session (but in human session,
I can do so).
RaÃl Llorente PeÃa
AnÃlisis, Desarrollo e ImplementaciÃn en
Microsoft Bussiness Solutions-Axapta
OPEN SOLUTIONS
"Bayliss, Barry"
<[EMAIL PROTECTED]>
Enviado por: Axapta-Knowledge-Village@yahoogroups.com
15/04/2005 01:31
Por favor, responda a
Axapta-Knowledge-Village@yahoogroups.com
Para
cc
Asunto
RE: [Axapta-Knowledge-Village] Why sentence
try/catch is invisible for COM sessions in 2.5?
Try using
Throw exception::error instead
of throw error(âââ).
From: Raul Llorente PeÃa/OPENSOLUTIONS
[mailto:[EMAIL PROTECTED]
Sent: Thursday, 14 April 2005 8:25 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Why sentence try/catch is invisible
for COM sessions in 2.5?
In 2.5, sentences blocks try/catch aren't
managed by Axapta when session is a COM one.
Let's see this example code (doesn't matter
wherever you put it to be executed);
TableErrors tableErrors; //A new table
created, with only a string field called error.
try
{
throw error('Error!!');
}
catch (Exception::error)
{
info('The error has been
catched');
tableerrors.error = 'one';
tableErrors.insert();
}
If this code is executed in an 'human'
session, the user will see "Error!! The error has been catched",
and then, when examining the table TableErrors, user will see that a new
record has beeb created, with value 'one'.
But, when code is executed via COM (a COM
session), the error is thrown but not managed, this is, no record in tableErrors
will appear at all.
This is, it appears as if try/catch sentences
were invisible to COM sessions. Why? Is there any workaround for this issue?
This is normal in 3.0, too?
RaÃl Llorente PeÃa
AnÃlisis, Desarrollo e ImplementaciÃn en
Microsoft Bussiness Solutions-Axapta
OPEN SOLUTIONS
Sharing the knowledge on Axapta.
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 the Yahoo!
Terms of Service.
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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] What does 'ReIndex" function exactly do
Yeah, I agree Varden Morris. RaÃl Llorente PeÃa AnÃlisis, Desarrollo e ImplementaciÃn en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS Varden Morris <[EMAIL PROTECTED]> 11/03/2005 13:30 Por favor, responda a Axapta-Knowledge-Village@yahoogroups.com Para Axapta-Knowledge-Village@yahoogroups.com cc Asunto RE: [Axapta-Knowledge-Village] What does 'ReIndex" function exactly do Yes, Axapta drops the index and rebuild it by sending the necessary commands to the backend database to execute these actions. Once you have created an index in Axapta and it is active the definition will be created in the backend database and you can reindex the database directly without going thru Axapta. Just have it in mind that you create database object for Axapta within Axapta and Axpata sends the necessary backend database commands to the database do execute the action. You should not make any modification to the database definition directly in the backend database because this will lead to inconsistency in the definition between Axapta and the backend database. If you make a modification to a table from the backend database by adding a field or index this should not cause any problem in Axapta but Axapta will not know that these objects exit and will not be able to use them. If you then add the field to the table from Axapta Axapta will alter the table and remove the field if it exists and then and the field with the definition requested from Axapta. If you remove a field or index from Axapta this will cause problems in Axapta when Axapta attempts to use them. If you add a table directly to the backend database and then try to add it from Axapta the backend database will throw and error which Axapta will then throw to the user stating that the table already exits in the database. Rebuilding the index from the backend does not change the index definition but recreates the index data from the definition that is done by the database and not Axapta. Axapta just sends the necessary command to the backend database to execute this action. Harry Deshpande <[EMAIL PROTECTED]> wrote: Hi To add some information (I am not an expert in SQL so I donât know what are the complete implications) but Reindexing from Axapta drops the indexes completely and then re-create them. However, SQL server will just correct the indexes (as per what I have been told). 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 worldâs 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: Varden Morris [mailto:[EMAIL PROTECTED] Sent: Friday, 11 March 2005 9:14 a.m. To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] What does 'ReIndex" function exactly do Hi Padmaja You are correct, index is use to search a table in a more efficient way. ReIndex is use to rebuild the indexes on tables. An index may be damaged or become inefficient after several deleting, updating and adding of records to a table. Rebuilding will solve these problems. I have a personal experience with a table where my Axapta
[Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?
How can I find what RecId will be the next to be used, before inserting a record and without accessing the table of RecIds (SystemSequences)? Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] SQL - AXDB Log - Full
That action is available only in SQL 2000, not 7.0!!! You will have to detach and attach it (after deleting log file manually), from query analyzer. Search in Internet. The key procedures to do this are sp_detach_db and sp_detach_db. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Where are Data Methods like Page and PagesTotal Defined?
These methods are defined in the base classes that are inherited by the final report classes. So in report you don't see them, buy they are present. And be careful with PagesTotal, in screen usually shows 0 or nothing, but when printed it shows the correct number of pages. Regards. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Images in reports
Are you sure you can only save in WMF format, when demo version allows to do it into BMP files?? re-check the ActiveX interface... Yes, Image class in Axapta allows to manage images in clipboard. You can save into or retrieve from it. The other possibilities should be considered as last resources. The two ones are the most suitable ones. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] warning Message
Check that the folder is accessible from the client you are running; Check disk space and permissions, too. Raúl Llorente Peña Anáisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Filter dimension via cross reference
If you try SELECT * FROM LedgerTrans where ledgerTrans.dimension == 'test' it will search 'test' on the first dimension, that is, department. Note that Dimension is an ARRAY!! Instead of that, try something like SELECT * FROM LedgerTrans where ledgerTrans.dimension[3] == 'Test' Raúl Llorente Peña Anáisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Urgent : Exporting Trial Balance sheet in Excel Format
Please, print it into HTML file format, and then open it with Excel. Excel should not have problem opening this file, then you can save it in xls (excel standard) format. If you wanna a more direct action, have a look over some excel classes in Axapta, search a bit and you'll find them (some time must be wasted until you learn about them, however...) Good Luck Raúl Llorente Peña Anáisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Howto from a newbie to this group
Hi there, First, hello everybody. I've just found this group, I hope it will help me a little in this Axaptian deep ocean... 3 questions to start : 1- Is there anybody french (or french-speaking) in this group ? As far as I know, there is at least two guys of those (I am not, sorry; my french is too bad to say so) 2- I want to make a "select count(*)" from an overview (in any form, but let's take the custtable form). Just to get the number of records my request gave me. How can I code this ? best and easier method is SELECT count(recid) FROM Table; Now Table.recid is the number of records. Note that rest of fields are cleared!! 3- Furthermore, if I want to get back the parameters of a request (fields + criteria) from a "search" or a "filter" command, how can I do that ? (let's say I have to click on a home-made-report button, which list me the content of the overview list in a form. If I click on the autoreport button, it works, but it's ugly...) Depends of ir it is from a form or a report; I assume a form. A form have several datasources;choose the one you want. Take the QueryRun of that Datasource, the Query of that QueryRun (if not QueryRun is found, take directly the Query), and look all datasourcetables ans ranges of it. Putting some complete example code would take me too time, you know... Many, many thanks in advance for your answers, SteF from Bordeaux,France. If custom office agrees, i send a bottle of wine to the first guy who respond to me ! :) not bad idea... could be a gin bottle, instead?? hehe!! Regards from a neighbourg... from Spain!! Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] OFF TOPIC - JOBS
Hey hey that's Enterprise Portal and Commerce Gateway!! However, with a correct planning, you can try to work in several sorts... Terminal server (connection speed will determine the ease of development greatly), Application replication & sending only development layers and label files, importing labels and projects using the same ID... Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] OFF TOPIC - JOBS
If you find anybody... think on remote working via Internet... Axapta has a module for doing so, it's called web deployment. There are other methods, of course... Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Axapta Crashing
Where do you try to access Business Relations from? Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] ActiveX DLL problem in Axapta 2.5
Have a look about Unicode in Technet, there are references about it. Despite I can't remember it very well, I think there are some references in the installation CD. Have a look over them!! Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Axapta Crashing
I suggest you to debug it step-by-step using the debugger from the point you enter the error from. Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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: Device Context
Some days ago I had a similar problem with some libraries of WS_FTP Pro program. I resolved it resetting my PC, unistalling it, resetting, installing it again. I hope this helps. It appears to be a Win problem rather than an Axapta's one. Sorry. This was my original message : i'm trying to call the report "tutorial_GraphicsCustBalanceList". Therefore i should register the "cfx2032.dll". But that doesn't work. I got the following error - message (translated) : "cfx2032.dll was loaded, but the DllRegisterServer Entry Point was not found . This file cound not be registered." Any help would be nice. Thanx in advance Olaf You suggested to try it with "CMD" from the DOS - Box Olaf Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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: Device Context
Hummm - pity. Could you resend your previous email detalling the problem? I erased it Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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: Device Context
Try registering manually that dll via regsrv32 in the CMD (ms-dos) prompt. Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Device Context
Version 3,0, It is composed by a Class and a Report. Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Device Context
I think the better option is the second (or at least it's what I know how to do). Put Image in disk, then load it from the report. Be careful with color and format schemas. About executing dll's functions, have a look over function winapi::shellexecute (make a debug, Axapta internally calls a DLL to do that function). Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] How to print 3 copies of a report ?
The best is to call the Report three times, passing the value you want (name, o anything you want) at each time. Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] How to print a box static frame in a body section ?
Let's see, you wanna a box with all lines and headings in, but with the header out of it? you can create an page header with linebelow; remember to add an empty text (if a section is empty it's not executed). The same to a page footer, but with the lineabove. The rest of the sections between the two mentioned earlier, should have activated lineleft and lineright. That's the easiest way, I mind... Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Oracle error when re-indexing
Have you tried to solve it via the SQL Tools from Administration in Axapta? Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Adding a new dimension
If you have correctly added the dimension, you should first fill the table Dimensions with the values you want for your new dimension. Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Regarding one invoice matches multiple sales orders
AFAIK, no. Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Axapta licensing
If enviroments are different, with different databases, you shouldn't have any problem in heving each one of them with 4 AOS. And that error is strange, I can't say about it Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Barcode In Axapta
The basis is to use some Windows Barcode TrueType. But the text of the barcodes must be codified in a way depending of the barcode type you want to use. In Axapta there are some reports that prints barcodes, and have a look on the EANBarcode classes (or somethig similar, as I can remember) Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Journals
I did something similar in 2.5 SP3 MP; Apparently without problems when posting the new journals created. I created a new ledgerjournal type and inserted it into ledgerjournaltable form, when hit "Lines" button, it gave into a simplified form of the general ledger journal trans (sorry, now I Can't remember the name). Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Setup WinFax???
Some time ago I tried during 3 days to set some fax sending from Axapta. I searched methods, (free) ActiveX controls in Internet... and finally desisted. If you get it, tell me about it!!! Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] element and this
Element referres to the whole original object, and this referres to the object that is a subobject of a greater object, where you are. An example: In a report, if you catch the, let's say, Init method, and there you put "element.", you will see the same methods & properties as if you put "this.". You see them equal because your ambit is still the whole object (the report). Now go to a report section from the design, and catch a method or executesection(). If you put now "element." you will the same methods as before (global ambit), but if you put "this." you will see methods and properties proper of the section (locall ambit is the section). And so on. In forms, in the principal methods, element and this are equivalent, but in a method of a button or control, this refers to the button or control itself, while element refers to the whole object (that is, the form) OK? Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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: Rotate text or Picture
Not if you use a fonttype; But if you use some external ActiveX control to do so, most of the Codebar ActiveX Controls have a option to send the result to a image; You can take the outpur image, rotate it with the class Image facilities and give it as input to the adecuate image control in report. Be careful, however, with the resolutions and size of the image, some scanners are awfully sensible to minimal image detail errors Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Setcursor() purpose
Similar to tmptablevar.SetTmpData(othertablevar) in forms or classes. Fill your temporal table somewhere and pass this to report; Define the temptable as datasource on rep query; then overwrite fetch(): this.QueryRun().SetCursor(myFilledTMPTable) super() this will instruct the defined always EMPTY systemcursor temptable in report to use the same data as your filled temptab. Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Barcode
It appears as easy as just a display
method as:
display **as the method of ItemId that
gives the vaule od itemid (barcode) you want** mybarcode()
{
Barcode.Clear();
Barcode.string(true,
yourtext); //very probably you will have to encode values, that depends
of each barcode
**here the code of the the
method of ItemId that gives the vaule od itemid (barcode) you want**
}
Create a similar stringedit in the report similar to the
original, with the valueMethod "mybarcode". Pay special attention
to letter font and font size.
I've taken a look to report WMSBillOfLading in 3.0 SP3,
but I don't find the codesource you posted, so I had to supposse you wanted
to do...
Raúl Llorente Peña
Técnico de Desarrollo e implementación en
Microsoft Bussiness Solutions-Axapta
OPEN SOLUTIONS
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] Rotate text or Picture
It's not possible to rotate text; But you can rotate pictures in Axapta, have a look into the form Tutorial_Images. Once you've learnt how to handle images in Axapta, just change the image in the report before printing it... there's no option in reports to rotate images, so you will have to do it yourself. Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Barcode
I don´t understand you. Do you mean to add a new barcode fontype, or just to add a new barcode in the same bar code (and fonttype) but different text?? Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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] Date Format
Check the language of the configuration; if ok, check the language of the client of the report, the invoices and so on are printed in the language of the client, not the user's one. Raúl Llorente Peña Técnico de Desarrollo e implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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.
