[development-axapta] ODBC connection using file DSN

Hi! Does anyone know if it is possible to create an ODBC connection in Axapta using a file DSN? And if so, how do I refer to this datasource using LoginProperty.setDSN()? Regards Bjørn [Non-text portions of this message have been removed] Yahoo! Groups Links To visit

SV: [development-axapta] Select Top 10 in Axapta ?

Hi! I don't think that is possible, but you may do something like this: InventTable inventTable; Counter counter; ; while select inventTable { counter++; if (counter = 20) break; } Regards bjørn _ Fra: Anton Tjiptadi [mailto:[EMAIL PROTECTED] Sendt: 30. mars 2005 04:31

SV: [development-axapta] Changecompany

Hi! Using the company Id when using changecompany is enough, but be aware that you have to clear all table instances before using then within the changecompany-block. SalesLine salesLine; ; changecompany ('rds') { salesLine = null; select firstonly salesLine; . . . . }

SV: [development-axapta] ResultSet - getDate cases Ax crash

Hi! I am facing a problem concerning the ResultSet-class. Running the following job in 2-tier gives me the desired result, whereas running the same job using a 3-tier client makes Axapta crash. It is the print resultSet.getDate(1); that fails. And only the getDate-call. Substituting

SV: [development-axapta] Add a new field to a table from X++ code

Hi! Does anyone know how to add a new field to a table using the Treenode-class? I want to do something like this: First locate the fields-path in the AOT for a given table; treenode = treeNode::findNode(#TablesPath + '\\' + dicttable.name() + \\Fields); Then I want to add a field like

RE: [development-axapta] Axapta Function

Hi! You can do something like this: int t; anytype a; ; t = typeof(a); switch (t) { case Types::ENUM: break; case Types::REAL: break; case Types::DATE: break; case Types::STRING, Types::RSTRING, Types::VARSTRING: } Regards Bjørn -Original Message- From:

RE: [development-axapta] Query logic OR

e(fieldnum(custtable, recid)); range = strfmt('((%1 == \"%2\") || (%3 == \"%4\"))',fieldstr(CustTable,Name),name,fieldstr(CustTable,InvoiceAccount),account); qbr.value(range);}Regards MichaelFrom: Bjørn Gudbrand Idstad [EMAIL PROTECTED]Reply-To: [EMAIL P

[development-axapta] AlwaysOnTop-property on forms

Title: Message Hi! I am using Axapta 2.5 Marketpack SP3 and want to create a formthat stays on top of all forms until the user closes the it. I have tries setting the AlwaysOnTop-property to yes, but the forms doesn't stay on top. Does anyone know how to use the AlwaysOnTop-property on

RE: [development-axapta] Re: Bjørn Gudbrand, Windows service instead of batch jobs

o you have an idea what to do when an error occurs on database connection? How can we catch that situation and take precautions to restart the Axapta client when connection with the database is established? Thank you very much. Volkan. --- In [EMAIL PROTECTED], Bjørn Gudbr

RE: [development-axapta] Data Dictionary

Title: Message Hi! I have a problem with the filter-functionality using the SmmBusRelTable-form (CRM). IfI open the form and then want to fiter the data,I press ctrl+F3 and open the filter-dialog. Now I add an additional datasource to the Business relations table, e.g. CustTable, add a

RE: [development-axapta] Windows service instead of batch jobs

Title: Message Hi! You can add a Scheduled task (Start-All programs-Accessories-System Tools-Scheduled Tasks). Add the ax32.exe file from you client bin-directory. Set the desired time that you want your application to run e.g when the computer startes. Enter a username and a password.

RE: [development-axapta] Help with DialogField controls

Hi! You return multiple filetypes like this: static container filenameLookupFilterCon() { return [SemiColon-Seperated Text (csv), '*.csv', TAB-separated, *.tab, Comma separated, *.com]; } - Bjrn -Original Message- From: Paul Robson [mailto:[EMAIL PROTECTED] Sent: Thursday,

RE: [development-axapta] Help with DialogField controls

Hello! You dialog-class must extend RunBase or RunBaseBatch. Overload the dialog-method adn add code similar to this: Object dialog() { DialogRunbase dialog = super(); ; dialog.caption(Save something in file); dialogFilenameWrite = dialog.addField(typeId(FilenameSave), Save

[development-axapta] FW: Extended datatypes

Hello! Does anyone know an easy way of finding all extended datatypes that extends from a given type? Let's say I want to find all types that extends from ExternalAccount... Regards Bjrn Yahoo! Groups Sponsor ADVERTISEMENT click here Your use of Yahoo! Groups is subject to the Yahoo!

RE: [development-axapta] Problem with Adress table

Hi! You can run this job: static void DeleteLayer(Args _args) { Utilidelements u; ClassId classId; ; classId = tableNum(Address); delete_from u where u.id == classId u.utilLevel == UtilEntryLevel::bus; pause; } - Bjrn -Original Message- From:

RE: [development-axapta] Regards changing a data field in a grid

Hi! After the record is updated, run executeQuery or reread on the datasource. If you use executeQuery, the current record looses focus, so it may be an idea to use findRecord to re-select the record. - Bjrn -Original Message- From: Mikael Dalgrd [mailto:[EMAIL PROTECTED] Sent: Monday,

RE: [development-axapta] Error message about table 'common'

Hi! Common is the base-table from which all tables inherits basic fields and functionality. You have probably added a table as a form datasource, and perhaps later on renamed or deleted that table. The table ID may have change if you have exported the table, deleted it from the AOT and then

RE: [development-axapta] Problem with args's class

Hi! You can't access variables declared in classDeclaration in static-methods, i.e construct and main. In a static method you need to create an instance of the class that you want to use, and then use that classes methods. If you wabt to use variables from e.g a form, these variables has to be

RE: FW: [development-axapta] Upgrade-Assistent without Compiling all

Hi! The information that you are looking for is stored in table SYSCONFIG. You have to insert a record with configtype 4 and id 6. Value is the string returned from ApplicationVersion::buildNo(); You can find some information on this in class SysApplicationSetup, method CheckDataModel() But