Re: [development-axapta] X++ language reference

2004-03-03 Thread Danny Gaethofs
Peter,   Have a look on technet.navision.com. Download the developers guide.   You have to register, but you can find a lot of information there under documentation.   Kind regards, Danny Gaethofspeter_wodoy <[EMAIL PROTECTED]> wrote: I'd search through the Internet ... but I can't found any X++

RE: [development-axapta] MS Word Automation

2004-03-03 Thread Amar Kumar Senapati
Hi, You see the SysExcelImport class in AOT. Hope you will get some idea. I hope you want to retrieve data from some Axapta Database tables and want to display in Excel file. If u find any difficulty let me know, I will send u some code. Regards Amar -Original Message- From: peter_wo

[development-axapta] MS Word Automation

2004-03-03 Thread peter_wodoy
I'm running the Exterprise Portal (Web) in Navision Axapta. I wish to retrieve data from the database and generate a Excel file with those data in it and then return it to the user so that the user can save it. Can I know how to do this? In ASP, it can be done through automation. But in X++

[development-axapta] X++ language reference

2004-03-03 Thread peter_wodoy
I'd search through the Internet ... but I can't found any X++ references. There're a lot of difficulties for me to develope application in Navision Axampta without a proper reference. I need reference documentation that similar to PHP documentation, MSDN, Java documentation, and etc. The h

[development-axapta] Regarding runbase report class

2004-03-03 Thread Amar Kumar Senapati
Hi all,   I have created three dialog fields (one check box, 2 Date fields) for my report in my class. I used the Runbase Report class. User enters the value in these dialogs and report is outputted using these conditions. But I want when the check box is clicked, the other two dialog

RE: [development-axapta] want to understand how to create a record in the table (SQL) by writti

2004-03-03 Thread Sonny Wibawa Adi
Hi Girish Bhatkal,   Does your client buy the COM license? If yes, then you can use COM Connector in Axapta (AxCom.dll). It can call a job, call a static method, even create Axapta Object to be used in other applications, such as VB, VC++, .NET app. So, one of the solution is you can create a li

[development-axapta] Re: Axapta Report

2004-03-03 Thread plngai
hi all, I have a problem when i print the axapta report to the txt file or html file. Alighment was run out as compare to the axapta report design. can someone help me on this issue . Thanks In Advance. regard, celine Yahoo! Groups Sponsor ADVERTISEMENT Click Here

RE: [development-axapta] want to understand how to create a record in the table (SQL) by writti

2004-03-03 Thread Girish Bhatkal
Hi Jesper,      thanks for the reply. the problem in this solution is that axapta is event driven and we have to run a job to import the data from the new table (created by external software). But the requirement is that as soon as the request is entered by Filemaker axapta has to pick the

Re: [development-axapta] want to understand how to create a record in the table (SQL) by writti

2004-03-03 Thread jesper.joergensen
Hi Girish, I do not like external software writing in the Axapta tables. The reasons for that you describe yourself (problems with Recid). Whar I like to do on integrations is to create an table that Axapta cann't se. (Other User, and/or other Database). I then use the ODBC class to access th

[development-axapta] want to understand how to create a record in the table (SQL) by writting procedure in SQL

2004-03-03 Thread Girish Bhatkal
Hi Guys,    our client was earlier using a different application (File maker) before we went live with axapta. some part of the business process is still done on the earlier application which we intend to slowly move to axapta.    our client is in computer repair business and the users are stil

Re: [development-axapta] Re: 45 GB Datebase with SQL2000

2004-03-03 Thread jesper.joergensen
The SP3a should only be used with Axapta 3.0 SP2. Check the release notes. /Jesper Original Message Subject: [development-axapta] Re: 45 GB Datebase with SQL2000 (03-Mrz-2004 17:05) From:    [EMAIL PROTECTED] To:  [EMAIL PROTECTED] > I think they work still with SP2. To

Re: SV: [development-axapta] Tableowner SQL

2004-03-03 Thread obaur_2004
oh, thank you very very much. You helped me very much. Thanks. --- In [EMAIL PROTECTED], Torben Bech <[EMAIL PROTECTED]> wrote: > We use this code: > > declare @name varchar(250) > declare @olduser varchar(250) > declare @newuser varchar(250) > declare @sp_str varchar(250) > > set @olduser

[development-axapta] Re: 45 GB Datebase with SQL2000

2004-03-03 Thread obaur_2004
I think they work still with SP2. To use SP3a is not off. recommended by MBS!? --- In [EMAIL PROTECTED], Marco Avena <[EMAIL PROTECTED]> wrote: > Hi, > have you already loaded any ServicePacks for SQL2000 ? > We made the experience of very fast growing DataBase after we moved to > Axapta

[development-axapta] RE: Table Performance

2004-03-03 Thread Peter Friberg
Title: SV: Table Performance Hi ÃzgÃr, Yes, you are absolutely right about the order of index fields in where clauses. I normally also write the index.   What do you mean with: what about the forms where we can't use our X++ techninques?   Greetings, Peter   -Ori

RE : [development-axapta] Re: Using Axapta Business Connector

2004-03-03 Thread Steeve Gilbert
Thanks Sonny!  I'll look at it!   Steeve…   -Message d'origine- De : Sonny Wibawa Adi [mailto:[EMAIL PROTECTED] Envoyé : 2 mars 2004 21:23 À : [EMAIL PROTECTED] Objet : RE: [development-axapta] Re: Using Axapta Business Connector   Hi all,   In case you want t

RE: [development-axapta] AP - Vendor Transaction missing from Function Open Editing screen

2004-03-03 Thread Steffan Engholm
Hi again What I can see from Your screendumps is, that the transactions don't seem to match at all (maybe I haven't seen enough?). I would have to get access to Your application and data to solve the problem. Unfortunately that's not a possibility :-). If You have the same kind of problems else

SV: [development-axapta] Rotate text on report

2004-03-03 Thread Jens
Hi Thomas We have done it by sending the escape sequence in a textfield on the reportdesign. Regards Jens -Oprindelig meddelelse- Fra: Mr Thomas Kristiansen [mailto:[EMAIL PROTECTED] Sendt: 2. marts 2004 09:15 Til: development-axapta Emne: [development-axapta] Rotate text on report

SV: [development-axapta] Tableowner SQL

2004-03-03 Thread Torben Bech
We use this code: declare @name varchar(250) declare @olduser varchar(250) declare @newuser varchar(250) declare @sp_str varchar(250) set @olduser = 'fhdbo.' -- old user (remember the "." !) set @newuser = 'dbo'   -- new user declare cursor1 cursor for   select name from sysobjects

[development-axapta] Tableowner SQL

2004-03-03 Thread obaur_2004
Does someone know how to change the tableowner in SQL back to dbo? I know how to do it with sp_changeobjectowner but with this command i have to do it for each table ==> lot of work. Thanks all! Yahoo! Groups Sponsor ADVERTISEMENT Click Here Yahoo! Groups Links

RE: [development-axapta] AP - Vendor Transaction missing from Function Open Editing screen

2004-03-03 Thread Lilian Lee
Hi Steffan, Thanks for your reply. Unfortunately, all the transactions are approved. Do you have any other clue that caused the problem. Cheers, Lilian -Original Message- From: Steffan Engholm [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 5:31 PM To: [EMAIL PROTECTED] S

Re: [development-axapta] AP - Vendor Transaction missing from Function Open Editing screen

2004-03-03 Thread Steffan Engholm
Hi Lilian There might be a simple solution to Your problem. The vendor transactions could be missing in the open transaction editing, if they aren't approved. See vendor transactions, "General" Tab, "Invoice" Group and checkBox "Approved". I'm not familiar with the approval procedures. Well, the