Re: [Axapta-Knowledge-Village] Data Encrption

2005-07-19 Thread Raul Llorente Peña/OPENSOLUTIONS
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

Re: [Axapta-Knowledge-Village] Localmacro help please

2005-07-11 Thread Raul Llorente Peña/OPENSOLUTIONS
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

Re: [Axapta-Knowledge-Village] Localmacro help please

2005-07-08 Thread Raul Llorente Peña/OPENSOLUTIONS
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

RE: [Axapta-Knowledge-Village] Ax 2.1 with SQL2000 wnd Windows 2003

2005-06-24 Thread Raul Llorente Peña/OPENSOLUTIONS
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

Re: [Axapta-Knowledge-Village] Number Sequence in Number Group form

2005-06-23 Thread Raul Llorente Peña/OPENSOLUTIONS
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

Re: [Axapta-Knowledge-Village] DictTable fieldname UNKNOWN?

2005-05-16 Thread Raul Llorente Peña/OPENSOLUTIONS
Try this!! (you put a wrong parameter!!)// CODE EXAMPLEstatic void Job1(Args _args){ dictTable dt; int numberOfFields; int fieldId; int i; str table; ; table = 'inventtable'; dt = new dictTable(tablename2id(table)); numberOfFields = dt.fieldCnt(); for (i = 1; i =

Re: [Axapta-Knowledge-Village] calendar pop-up

2005-05-12 Thread Raul Llorente Peña/OPENSOLUTIONS
Take a look over the EDT Transdate. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS shelschake [EMAIL PROTECTED] Enviado por: Axapta-Knowledge-Village@yahoogroups.com 12/05/2005 17:04 Por favor, responda a

Re: [Axapta-Knowledge-Village] Urgent!!! how to set the mail body through prinjobSettings class

2005-05-11 Thread Raul Llorente Peña/OPENSOLUTIONS
Just add some optional parameter to the method that puts the body text... and put that parameter backwards in the method calls chain.This appears to be the easiest way... But, I suggest then to compile all classes in order to avoid surprises.Raúl Llorente Peña Análisis, Desarrollo e

Re: [Axapta-Knowledge-Village] Re-freshing/ Changing Join types

2005-05-10 Thread Raul Llorente Peña/OPENSOLUTIONS
Tried x_ds.research() or x_ds.ExecuteQuery()?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

Re: RE: [Axapta-Knowledge-Village] Re-freshing/ Changing Join types

2005-05-10 Thread Raul Llorente Peña/OPENSOLUTIONS
Well, take a look on the Query Query Run datasources properties generated by the form datasources. It's a bit complex to explain, but it can help much to you.Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS Sharing the knowledge

RE: RE: [Axapta-Knowledge-Village] - Import Wizard Help

2005-04-21 Thread Raul Llorente Peña/OPENSOLUTIONS
-Village@yahoogroups.com Subject: Re: RE: [Axapta-Knowledge-Village] - Import Wizard Help I agree Raul. I have Axapta 3.0 SP3 and it works all right creating Excel spreadsheets, so maybe it is your excel version. Cristina Carcelén Axapta Financial Consultant Raul Llorente Peña/OPENSOLUTIONS [EMAIL

Re: [Axapta-Knowledge-Village] Re: Report Is Empty

2005-04-21 Thread Raul Llorente Peña/OPENSOLUTIONS
Can you see the same data in forms both in 2tier as 3 tier?? (Customers, customer transactions, etc...) Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS jesse [EMAIL PROTECTED] Enviado por:

Re: [Axapta-Knowledge-Village] Financial statement

2005-04-21 Thread Raul Llorente Peña/OPENSOLUTIONS
Do you mean to change this data in the header of the report?? Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS yifath1 [EMAIL PROTECTED] Enviado por: Axapta-Knowledge-Village@yahoogroups.com 21/04/2005 11:20 Por favor,

Re: [Axapta-Knowledge-Village] Oracle and ClusterIndex?

2005-04-21 Thread Raul Llorente Peña/OPENSOLUTIONS
Good questions I'd like to know that, too. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS hwimmer [EMAIL PROTECTED] Enviado por: Axapta-Knowledge-Village@yahoogroups.com 21/04/2005 11:35 Por favor, responda a

Re: [Axapta-Knowledge-Village] - Import Wizard Help

2005-04-20 Thread Raul Llorente Peña/OPENSOLUTIONS
3.0 SP1???Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS[EMAIL PROTECTED] escribió: -Para: Axapta-Knowledge-Village@yahoogroups.comDe: "Brandon George" [EMAIL PROTECTED]Enviado por:

Re: [Axapta-Knowledge-Village] Enterprise Portal HELP!!!

2005-04-20 Thread Raul Llorente Peña/OPENSOLUTIONS
Just drag an menu item into the menu tree you want, or do so with a menu...Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS[EMAIL PROTECTED] escribió: -Para: Axapta-Knowledge-Village@yahoogroups.comDe: "Craig Fidler" [EMAIL

Re: RE: [Axapta-Knowledge-Village] - Import Wizard Help

2005-04-20 Thread Raul Llorente Peña/OPENSOLUTIONS
Asunto: RE: [Axapta-Knowledge-Village] - Import Wizard Help3.0 SP3 is what version we are on... thanks, Brandon From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Raul Llorente Peña/OPENSOLUTIONS Sent: Wednesday, April 20, 2005 11:07 AM To: Axapta-Knowled

RE: [Axapta-Knowledge-Village] Why sentence try/catch is invisible for COM sessions in 2.5?

2005-04-18 Thread Raul Llorente Peña/OPENSOLUTIONS
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). Ral Llorente Pea Anlisis,

RE: [Axapta-Knowledge-Village] How to get actual time of system... with milliseconds or similar??

2005-04-18 Thread Raul Llorente Peña/OPENSOLUTIONS
. In addition to this specification, you must also enter a command called return and specify what you want returned. Return must always be placed at the end, as this command concludes the method. Raul Llorente Peña/OPENSOLUTIONS [EMAIL PROTECTED] wrote: Hey, do you mean GetTickCount() returns

Re: [Axapta-Knowledge-Village] How to get actual time of system... with milliseconds or similar??

2005-04-14 Thread Raul Llorente Peña/OPENSOLUTIONS
I need to know the exact time of system. Timenow() gives a integer, but the precision range is in the order of seconds. I would need to get the time, in a more precise precision, in the order of milliseconds. TimeOfDay datatype is the number of seconds of the actual day... let's say 125, this

Re: RE: [Axapta-Knowledge-Village] How to get actual time of system... with milliseconds or similar??

2005-04-14 Thread Raul Llorente Peña/OPENSOLUTIONS
onsultant From: Raul Llorente Peña/OPENSOLUTIONS [mailto:[EMAIL PROTECTED] Sent: 14. april 2005 09:58 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] How to get actual time of system... with milliseconds or similar?? I need to know the exact time of system. Timen

[Axapta-Knowledge-Village] Why sentence try/catch is invisible for COM sessions in 2.5?

2005-04-14 Thread Raul Llorente Peña/OPENSOLUTIONS
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

RE: [Axapta-Knowledge-Village] How to get actual time of system... with milliseconds or similar??

2005-04-14 Thread Raul Llorente Peña/OPENSOLUTIONS
From: Raul Llorente Peña/OPENSOLUTIONS [mailto:[EMAIL PROTECTED] Sent: 14. april 2005 09:58 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] How to get actual time of system... with milliseconds or similar?? I need to know the exact time of system. Timenow() gives

Re: [Axapta-Knowledge-Village] Introduction...

2005-04-14 Thread Raul Llorente Peña/OPENSOLUTIONS
Hello All! My Name is Brandon - I am a Software Engineer from Georgia, U.S. I was invited by someone to join this group. Our company is implementing Axapta right now, and I am part of the Development / Support / Admin team for it. This is my first exposure to axapta, but I have been

Re: [Axapta-Knowledge-Village] Urgent help needed on hardware sizing for Axapta

2005-04-13 Thread Raul Llorente Peña/OPENSOLUTIONS
Check PartnerSource, there you can get the Official hardware sizing guides. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS ramyakrishnan_1023 [EMAIL PROTECTED] 13/04/2005 08:43 Por favor, responda a

Re: [Axapta-Knowledge-Village] Ledger Settlements !!!!!!!!!!!!!!!!!!!!!!!!!!

2005-04-13 Thread Raul Llorente Peña/OPENSOLUTIONS
this same exercise but instead of use de default data for Mexico I used the international default data and in this enviroment the function works properly. For both exercises, I used the same application (v.3 sp3) and the Mexico specific features. regards, Ricardo Raul Llorente Peña/OPENSOLUTIONS

Re: [Axapta-Knowledge-Village] reporting wizard

2005-04-13 Thread Raul Llorente Peña/OPENSOLUTIONS
perhaps in the user's guide of Axapta.Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS-"willem_baelde" [EMAIL PROTECTED] escribió: -Para: Axapta-Knowledge-Village@yahoogroups.comDe: "willem_baelde" [EMAIL PROTECTED]Fecha:

Re: [Axapta-Knowledge-Village] How to get actual time of system... with milliseconds or similar

2005-04-13 Thread Raul Llorente Peña/OPENSOLUTIONS
I need to know the exact time of system.Timenow() gives a integer, but the precision range is in the order of seconds. I would need to get the time, in a more precise precision, in the order of milliseconds. TimeOfDay datatype is the number of seconds of the actual day... let's say 125, this

Re: AW: [Axapta-Knowledge-Village] How to get actual time of system... with milliseconds or similar

2005-04-13 Thread Raul Llorente Peña/OPENSOLUTIONS
Time or GetLocalTime in the WinAPI class. The GetSystemTime function retrieves the current system date and time. The system time is expressed in Coordinated Universal Time (UTC). The GetLocalTime function retrieves the current local date and time. Regards Jesper Von: Raul Llorente Peña/OPENSOLU

Re: [Axapta-Knowledge-Village] Difficult in location partner source

2005-04-12 Thread Raul Llorente Peña/OPENSOLUTIONS
Select first 'Axapta', then 'Documentation', 'Blank Papers', there's most of available articles and documentation, Or something similar, as I remember. But don't expect too much. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS

Re: [Axapta-Knowledge-Village] Ledger Settlements !!!!!!!!!!!!!!!!!!!!!!!!!!

2005-04-12 Thread Raul Llorente Peña/OPENSOLUTIONS
Please, reexplain yourself, I didn't understood you very well. 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 Links To visit your group on the web, go

Re: RE: [Axapta-Knowledge-Village] Re: Change PackingSlipId

2005-04-11 Thread Raul Llorente Peña/OPENSOLUTIONS
You can change the PackingSlipId in the manner you like (from Axapta changing the table properties so you can edit the field in the table viewer; with jobs; directly with SQL...). The 'how'is not so important as 'what'. The real core is to know all tables and fields involved so you can

Re: [Axapta-Knowledge-Village] Data Replication with Axapta

2005-04-08 Thread Raul Llorente Peña/OPENSOLUTIONS
Hello to All. My company has implemented Axapta Financials in some countries. The main server is located in Miami and the local office in each country access Axapta using Citrix (a kind of remote desktop). We want to put a local axapta installation in each country. If we do that, is there

RE: RE: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?

2005-03-11 Thread Raul Llorente Peña/OPENSOLUTIONS
by Preston, what error are you receiving? Barry. From: Raul Llorente Peña/OPENSOLUTIONS [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 March 2005 7:16 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: RE: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next

RE: [Axapta-Knowledge-Village] What does 'ReIndex function exactly do

2005-03-11 Thread Raul Llorente Peña/OPENSOLUTIONS
Yeah, I agree Varden Morris. Ral Llorente Pea Anlisis, Desarrollo e Implementacin 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

RE: RE: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?

2005-03-10 Thread Raul Llorente Peña/OPENSOLUTIONS
: RE: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used? Raul, Are you able to post the code that generates the error? Barry. From: Raul Llorente Peña/OPENSOLUTIONS [mailto:[EMAIL PROTECTED] Sent: Sunday, 6 March 2005 6:54 PM To: Axapta

Re: RE: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?

2005-03-06 Thread Raul Llorente Peña/OPENSOLUTIONS
oblem. Hope it helps you. -Preston From: Raul Llorente Peña/OPENSOLUTIONS [mailto:[EMAIL PROTECTED] Sent: Friday, March 04, 2005 3:25 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used? Preston

Re: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?

2005-03-04 Thread Raul Llorente Peña/OPENSOLUTIONS
Preston, the problem isn't that records are inserted with same RecId, but Axapta doesn't allow to do so!!If I deactivated the system-hidden indexes of many tables, Axapta would allow it... until next sinchronization!! And remember, there are several tables based on refRecId field and similar,

Re: RE: [Axapta-Knowledge-Village] Advice needed to delete USR layer

2005-03-04 Thread Raul Llorente Peña/OPENSOLUTIONS
Yeah, the usr.aoi and usr.aod will always exists; If usr.aod is only 8Kb sized, it means it's empty, so don't worry about that.An issue: After deleting usr.aod, I would suggest to delete the axapd.aoi (index of objects), also. Sometimes it has happened to me that the var and deleted usr

Re: RE: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?

2005-03-03 Thread Raul Llorente Peña/OPENSOLUTIONS
Well, when I deactivate indexes the error still appears. Axapta defines for all tables an 'hidden' index, that includes recid and dataareaid. Note that error doesn't appear in determinate tables, but in apparently alleatory ones... (they're standard).Raúl Llorente Peña Análisis, Desarrollo e

Re: RE: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?

2005-02-25 Thread Raul Llorente Peña/OPENSOLUTIONS
I've got a problem. Several users via COM, using same COM session, sometimes invokes the error (Cannot insert a record in table X. The record already exists). X may be an apparently alleatory table. And I need to track so. Tool of log of database doesn't fit this...Raúl Llorente Peña

Re: Re: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?

2005-02-24 Thread Raul Llorente Peña/OPENSOLUTIONS
reach this value.regards,Danny--- In Axapta-Knowledge-Village@yahoogroups.com, Raul Llorente Peña/OPENSOLUTIONS <[EMAIL PROTECTED]>wrote: Sorry David, but your appointment is invalid. When a user log into Axapta, the Kernel takes 25 recids into cache, and adds 25 to next value. Try yourself as below (c

Re: Re: [Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?

2005-02-24 Thread Raul Llorente Peña/OPENSOLUTIONS
number of record id's at a time. So next thing you should focus on is where are these stored and how can you grap these values.Only trying to help, hope you appreciate it.regards,Danny--- In Axapta-Knowledge-Village@yahoogroups.com, Raul Llorente Peña/OPENSOLUTIONS <[EMAIL PROTECTED]>wrote:

[Axapta-Knowledge-Village] How to get cached or opened tables of a session??

2005-02-23 Thread Raul Llorente Peña/OPENSOLUTIONS
I'd like to know if it's possible (and how) to get the open tables in Axapta.The exact case is as follows:Many COM users are connected.Message "Cannot insertin table X. The record already exists" appears often. I've checked, the index of some of those tables, but are apparently OK. I want to

[Axapta-Knowledge-Village] How can I find what RecId will be the next to be used?

2005-02-23 Thread Raul Llorente Peña/OPENSOLUTIONS
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.

Re: [Axapta-Knowledge-Village] Edit problem on form

2005-02-21 Thread Raul Llorente Peña/OPENSOLUTIONS
Use an edit method on the datasource of the temporary table of the form.. 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 Links To visit your group on the web, go

Re: RE: [Axapta-Knowledge-Village] High Importance!!!! Syntax error after a Int declaration.

2005-02-18 Thread Raul Llorente Peña/OPENSOLUTIONS
This happened to me in a Customer's environment... I spent a week until I found what caused that error...A programmer had created a EDT called 'Target', and a Base Enum called 'Type'... no comment. Resetting DDBB, recompiling Application once and once again, and... etc. When compiling

Re: RE: [Axapta-Knowledge-Village] High Importance!!!! Syntax error after a Int declaration.

2005-02-18 Thread Raul Llorente Peña/OPENSOLUTIONS
The problem of prefixes comes when you want to copy funcionality from a customer to other, and have a maintenance plan on them...customer 1: Pelbet Prefix: PLB_customer 2: Ibmosher Prefix: IBM_Object: PLB_Class1, PLB_CustReport, etc...Export them, import in Ibmosher... objects called IMB_

Re: [Axapta-Knowledge-Village] Negative recid

2005-02-18 Thread Raul Llorente Peña/OPENSOLUTIONS
Don't worry about that. RecId have reached the maximum positive Int, so it begins now from the maximum negative Int.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

Re: [Axapta-Knowledge-Village] Axapta Report Questions..

2005-02-08 Thread Raul Llorente Peña/OPENSOLUTIONS
1.To create vertical lines: In the borders, I'd advide to use lineleft and lineright properties of the pertinent section; To insert in middle of document, the best is to use a Shape control, defined as vertical line.2.Yeah, in every header section, set on the lineleft and lineright

Re: RE : RE : [Axapta-Knowledge-Village] Login image

2005-02-04 Thread Raul Llorente Peña/OPENSOLUTIONS
Yeah, or try it with Restorator2004, it works fine.Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS-"Steeve Gilbert" [EMAIL PROTECTED] escribió: -Para: Axapta-Knowledge-Village@yahoogroups.comDe: "Steeve Gilbert" [EMAIL

Re: [Axapta-Knowledge-Village] Total Axapta implementation in World

2005-02-03 Thread Raul Llorente Peña/OPENSOLUTIONS
How do you want to evaluate the number of Axapta implementations in the WORLD thousands...In the India... I'm not native in there.The greater implementation in number of user we have are about 150 concurrent users via presential, and 150 via COM (from other applications -interface- or

Re: [Axapta-Knowledge-Village] Batch Process

2005-02-03 Thread Raul Llorente Peña/OPENSOLUTIONS
Urgh, a job can't be extended over a batch class; You should instead create a class that extends a 'batchable' class, and call that (p.e.) job via menufunction... or rather better, create a batch class that make the job's dirty job...Raúl Llorente Peña Análisis, Desarrollo e Implementación en

Re: RE: [Axapta-Knowledge-Village] True Story

2005-02-02 Thread Raul Llorente Peña/OPENSOLUTIONS
^_^Ha, some (not so much) lont time ago, there was a new software called 'Damgaard Axapta 2.1', and I began to get in it because I 'wanted to learn something new'... (And I worked in 2.0, too!!)... Ah, rememberings...Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft

Re: [Axapta-Knowledge-Village] standard methods for tables

2005-01-18 Thread Raul Llorente Peña/OPENSOLUTIONS
Xrecord may help you, I guess?Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS-"Take a guess" [EMAIL PROTECTED] escribió: -Para: Axapta-Knowledge-Village@yahoogroups.comDe: "Take a guess" [EMAIL PROTECTED]Fecha: 18/01/2005

Re: [Axapta-Knowledge-Village] Range in report

2005-01-18 Thread Raul Llorente Peña/OPENSOLUTIONS
You will have to pass the record as parameter to report; In the report you will have to program code that catches this record, and then modify the QueryRange of the Range you want, before executing the query. You will have a little work doing this...Raúl Llorente Peña Análisis, Desarrollo e

Re: [Axapta-Knowledge-Village] Re: SalesLine disappears

2005-01-18 Thread Raul Llorente Peña/OPENSOLUTIONS
All we were telling it to you...Not at all. ;-)Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS-"Danny Gaethofs" [EMAIL PROTECTED] escribió: -Para: Axapta-Knowledge-Village@yahoogroups.comDe: "Danny Gaethofs" [EMAIL

Re: [Axapta-Knowledge-Village] Layers and performance

2005-01-18 Thread Raul Llorente Peña/OPENSOLUTIONS
Theorically not; but you must note that the layer files are greater, somanaging them takes more memory in the client(2-tier) or server(3-tier). And, is yet more noticeably harder to the applicattion admin/programmer to manage those objects (time and error costs). So, try to have objects in

Re: [Axapta-Knowledge-Village] query for the fields of a table

2005-01-17 Thread Raul Llorente Peña/OPENSOLUTIONS
Have a look over the dictTable class:dictTable dt; int numberOfFields; int fieldId; int i; ; dt = new dictTable(tableNum(CustTable)); //name of table info(dt.name()); numberOfFields = dt.fieldCnt(); info(int2str(numberOfFields)); for (i = 1; i = numberOfFields; i++) //if you want All fields

Re: RE: [Axapta-Knowledge-Village] Re: savelast() get last()

2005-01-17 Thread Raul Llorente Peña/OPENSOLUTIONS
I agree Barry Bayliss.Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS-"Bayliss, Barry" [EMAIL PROTECTED] escribió: -Para: Axapta-Knowledge-Village@yahoogroups.comDe: "Bayliss, Barry" [EMAIL PROTECTED]Fecha: 18/01/2005

Re: [Axapta-Knowledge-Village] How to use the sequence no.

2005-01-14 Thread Raul Llorente Peña/OPENSOLUTIONS
Do you mean to create the proper RECID of a table to insert an Axaptarecord from outer application, or to create a record via COM connector in Axapta using a number from some numsequence??Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN

Re: Re: [Axapta-Knowledge-Village] How to use the sequence no.

2005-01-14 Thread Raul Llorente Peña/OPENSOLUTIONS
The easiest way to get numbersequences is the class NumberSequenceFast (or similarlly named). 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

Re: [Axapta-Knowledge-Village] Report Rulers

2005-01-13 Thread Raul Llorente Peña/OPENSOLUTIONS
Just type 'Xmm' in the proper property, where X is a integer. (Don't write the dots).Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS-Alfonso Collados Arroyo [EMAIL PROTECTED] escribió: -Para: "Axapta-Knowledge-Village

Re: [Axapta-Knowledge-Village] How many tables r updated

2005-01-13 Thread Raul Llorente Peña/OPENSOLUTIONS
At least SalesTable, SalesLine, SalesParmTable, SalesParmLine, InventDim, InventSum, InventTableLocation, LedgerTrans, CustTrans, CustTransOpen, etc are usually involved. You can follow SQL tracings (User Optionsin Tools option), or use a tool that traces changes/accesses to tables you mark

Re: [Axapta-Knowledge-Village] Certain forms run very slow.

2005-01-13 Thread Raul Llorente Peña/OPENSOLUTIONS
In three tier memory is not so important. Check where forms are executed (client/server) and the data table caching.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

Re: [Axapta-Knowledge-Village] One report with data from all companies

2005-01-10 Thread Raul Llorente Peña/OPENSOLUTIONS
Have you heard aboutchangeCompany(companyId){ //the sentences of this block will be executed with the company companyId data.}??Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS Sharing the knowledge on Axapta. Yahoo!

Re: [Axapta-Knowledge-Village] printing invoice or picking list

2005-01-10 Thread Raul Llorente Peña/OPENSOLUTIONS
This one is easy:Usually will be SalesFormLetter_Invoice or SalesFormLetter_PickingList (or Purch...). Be Careful when initializing parameters...Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS Sharing the knowledge on Axapta.

Re: Re: [Axapta-Knowledge-Village] SQL database error - equal to-operation

2005-01-10 Thread Raul Llorente Peña/OPENSOLUTIONS
Or do so via SQL Administration in Axapta;Or/and look for duplicated records in the table; If table browser doesn't show nothing strange, do it via SQL directly.Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS-Varden Morris

Re: [Axapta-Knowledge-Village] simple report question

2005-01-03 Thread Raul Llorente Peña/OPENSOLUTIONS
Take a look about methods of element.design(): GotoY100mm, gotoX100mm (this one doesnt work as expected, be aware!!), etc. And about left100mm of the controls!! Tutorial Report_positioning (or something similar) will be useful to you.The logic is:- Save the initial Y100mm.repeat X times -

Re: [Axapta-Knowledge-Village] Re: simple report question

2005-01-03 Thread Raul Llorente Peña/OPENSOLUTIONS
rewind the position on the pageelement.execute(1);if (ctr mod 5 == 0){ topPosition = topPosition + certainHeight; leftPosition = leftMargin + certainWidth;}else{ leftPosition = leftPosition + certainWidth; }element.gotoYmm100(topPosition*100);ctr = ctr + 1 }regards,Danny--- In Axapta-Knowledge-Village@yahoogroups.com

[Axapta-Knowledge-Village] Axapta COM Connector configuration parameters Oracle 9.2 Against Axapta 2.5

2005-01-03 Thread Raul Llorente Peña/OPENSOLUTIONS
Two questions:Can anyone tell me where can I find documentation about configuration parameters of the Axapta COM+ Connector?? In a customer we have, it goes pretty, but in a random time elapse (from minutes to days), it gives several types of errors. This component is being used all the time.

Re: RE : [Axapta-Knowledge-Village] Positioning Programmable section

2005-01-03 Thread Raul Llorente Peña/OPENSOLUTIONS
Haw!! Do you really think you can't print two sections on same paper section??A section is always printed one under the previous one... unless you modify the "pen position" with GotoY100mm!!Try it, you will receive a nice surprise.But, as you say, to create the controls dinamically with

Re: [Axapta-Knowledge-Village] software

2004-12-31 Thread Raul Llorente Peña/OPENSOLUTIONS
Only partners (enterprises o distributorsassociated to Microsoft BussinessSolutions Axapta) are allowed to do these downloads. If you're not working in a partner, contact some person that is working in one, so he perhaps can give you a copy.Raúl Llorente Peña Análisis, Desarrollo e

Re: [Axapta-Knowledge-Village] Pagefooter

2004-12-23 Thread Raul Llorente Peña/OPENSOLUTIONS
Urgh, that's pretty difficult...When you create the report design, Axapta reserves the space for all footers in design. Let's suppose 5 pagefooters, with a height of 10 mm. each, but you've programmed it to print only 3 of them. Well, when you print that report, even tough only 3 pagefooter

Re: [Axapta-Knowledge-Village] Macro Question

2004-12-23 Thread Raul Llorente Peña/OPENSOLUTIONS
Otto, you're defining a local macro:static void Jobx(Args _args) { #localmacro.TRA_Macro_Local1 print "Hello local world"; pause; #endmacro #TRA_Macro_Local1 } Danny wants to use a global one!! The right version would be:Macro Macro1 is listed:#define.salute1(print 'Hello World';

Re: [Axapta-Knowledge-Village] Problem with ax 2.5 to 3.0 data upgrade

2004-12-22 Thread Raul Llorente Peña/OPENSOLUTIONS
When doing an upgrade, always put the upgraded application first against an empty database, and then solve the error compilations and layerversion differences!!Once it's allcompiled OK, you can then put the new application against the real DDBB of previous version.previous BACKUP of DDBB

Re: [Axapta-Knowledge-Village] length of code per line and how to split it???

2004-12-22 Thread Raul Llorente Peña/OPENSOLUTIONS
if you write somwthing like:codecodecodecode.function(parrameter, parameter, parameter, parameter, etc );no problem. (Split sintactically the code!!)I think your problem is that you're writting literal big, enormous text strings, uh?something likeinfo ('texttexttexttexttext')or print

Re: [Axapta-Knowledge-Village] Print 3 logos in PageFooter

2004-12-22 Thread Raul Llorente Peña/OPENSOLUTIONS
Use the class Image of Axapta, with it you can take an image, and use several pretty usefulmethods over the image. Make a test report, and try it. You may have a look on form Tutorial_Images, or in reports where company logo is printed on header.Raúl Llorente Peña Análisis, Desarrollo e

Re: [Axapta-Knowledge-Village] Sorry

2004-12-21 Thread Raul Llorente Peña/OPENSOLUTIONS
I didn't know that posting job offers is forbidden in this forum... I think that posting job offer is not a bad idea at all.Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS Sharing the knowledge on Axapta. Yahoo! Groups

Re: [Axapta-Knowledge-Village] Filter the modified objects to specific date.

2004-12-20 Thread Raul Llorente Peña/OPENSOLUTIONS
You can filter objects in a Project.Create a project, rename it, and open it. Then, hit the filter button placed above, in the Project Window. There you can select (and filter) objects from the AOT. There are several options.I usually use the filter with AOT agrupation, selecting bus, bup,

Re: [Axapta-Knowledge-Village] error in Axapd.aoi?!

2004-12-20 Thread Raul Llorente Peña/OPENSOLUTIONS
check:- Readonly attributes, or permissions of the windows user over the file- disk space- Other users aren't working with that application.That file is the index of all objects of AOT and application in Axapta. When opened, Axapta sees that objects don't match the index,so it tries to create

RE: [Axapta-Knowledge-Village] SQL - AXDB Log - Full

2004-10-25 Thread Raul Llorente Peña/OPENSOLUTIONS
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

Re: [Axapta-Knowledge-Village] warning Message

2004-10-14 Thread Raul Llorente Peña/OPENSOLUTIONS
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

Re: [Axapta-Knowledge-Village] Howto from a newbie to this group

2004-08-11 Thread Raul Llorente Peña/OPENSOLUTIONS
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

Re: [Axapta-Knowledge-Village] OFF TOPIC - JOBS

2004-08-10 Thread Raul Llorente Peña/OPENSOLUTIONS
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,

Re: [Axapta-Knowledge-Village] Axapta Crashing

2004-08-05 Thread Raul Llorente Peña/OPENSOLUTIONS
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

Re: [Axapta-Knowledge-Village] Axapta Crashing

2004-08-03 Thread Raul Llorente Peña/OPENSOLUTIONS
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

Re: [Axapta-Knowledge-Village] Re: Device Context

2004-08-02 Thread Raul Llorente Peña/OPENSOLUTIONS
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

Re: [Axapta-Knowledge-Village] Device Context

2004-07-27 Thread Raul Llorente Peña/OPENSOLUTIONS
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

RE: [Axapta-Knowledge-Village] Device Context

2004-07-27 Thread Raul Llorente Peña/OPENSOLUTIONS
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

Re: [Axapta-Knowledge-Village] How to print a box static frame in a body section ?

2004-07-22 Thread Raul Llorente Peña/OPENSOLUTIONS
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

Re: [Axapta-Knowledge-Village] Oracle error when re-indexing

2004-07-20 Thread Raul Llorente Peña/OPENSOLUTIONS
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

Re: [Axapta-Knowledge-Village] element and this

2004-06-30 Thread Raul Llorente Peña/OPENSOLUTIONS
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..