RE: [development-axapta] Re: Axapta QueryRange Sql

the code that interprets Queries or X++ SQL and produces the actuel SQL statement. Best Regards, Carsten F. Frandsen a-solutions From: development-axapta@yahoogroups.com on behalf of muzzyk34 Sent: Fri 6/12/2009 10:18 To: development-axapta@yahoogroups.com Subject

RE: [development-axapta] Re: How create a Day Function?

Hi, DayOfWk Syntax int DayOfWk (date date) Description Calculates the day of the week for the date specified by date. Note that Monday is regarded as day 1 of the week. Example DayOfWk(02\02\1998) returns the value '1'. Best regards Carsten F. Frandsen

RE: [development-axapta] How create a Day Function?

Hi, That function already exists in Axapta - it's called dayOfWk ... Best regards Carsten F. Frandsen From: development-axapta@yahoogroups.com on behalf of arykamal07 Sent: Wed 1/14/2009 10:24 AM To: development-axapta@yahoogroups.com Subject: [development

[development-axapta] Re: Reading from text file and updating an AX4.0 table

Hi, The best way to do it would be creating an index on Account field. Next loop thru the and use the update_recordset to bulk update each accountnumber. Best regards Carsten F. Frandsen --- In development-axapta@yahoogroups.com, Jim Dimarzio [EMAIL PROTECTED] wrote: Hello, Can anyone

RE: [development-axapta] Enum values in SQL database

Hi, It is not possible to get the enum values because they are stored in the application data files (.aod). /Carsten From: development-axapta@yahoogroups.com on behalf of Anil Ozay Sent: Wed 3/12/2008 1:44 PM To: [EMAIL PROTECTED];

RE: [development-axapta] Temporary table

Hi! You should use myTable.setTmpData instead of myTable.data ... Best regards Carsten F. Frandsen a-solutions From: development-axapta@yahoogroups.com on behalf of Tri Budianto Sent: Fri 2/15/2008 9:57 AM To: development-axapta@yahoogroups.com Subject

RE: [development-axapta] Query on temporary table

Hi, Use the method setRecord on the QueryRun to pass the temporary table to the Query. Br. Carsten F. Frandsen a-solutions From: development-axapta@yahoogroups.com on behalf of Dahlsgaard Jan Sent: Fri 2/8/2008 2:53 PM To: development-axapta

[development-axapta] Question regarding the use of RecordInsertList

to at least 100 or more before the automatic flush occurs - but can not figure out how to do that. Does any one have any suggestions on how to increase that number of records ? Thanks in advance. Best regards Carsten F. Frandsen [Non-text portions of this message have been removed

SV: [development-axapta] how to speed up my report

If you are using Axapta 3.0 I will suggest that you create a view ... I haven't done that myself but I believe that it would work Best regards Carsten F. Frandsen Fra: abdulabsi [mailto:[EMAIL PROTECTED] Sendt: to 17-02-2005 12:12 Til: [EMAIL PROTECTED

SV: [development-axapta] Dynamic form changes possible?

on this line. formRun.init(); formRun.run(); formRun.wait(); } HTH Best regards Carsten F. Frandsen Fra: James Flavell [mailto:[EMAIL PROTECTED] Sendt: ti 15-02-2005 14:42 Til: development-axapta@yahoogroups.com Emne: RE: [development-axapta] Dynamic form

SV: [development-axapta] Dynamic form changes possible?

Take a look at the class SysSetupFormRun This class is used to e.g. retrieve a user defined design for a form... Regards Carsten F. Frandsen Fra: James Flavell [mailto:[EMAIL PROTECTED] Sendt: ti 15-02-2005 01:15 Til: development-axapta

SV: [development-axapta] How to do i know in advance the next record in table is the last record

Use something like: CustTable custTable; ; next custTable; if (custTable) { ... } Regards Carsten F. Frandsen Fra: compashi1 [mailto:[EMAIL PROTECTED] Sendt: fr 11-02-2005 13:48 Til: development-axapta@yahoogroups.com Emne: [development

SV: [development-axapta] Varchar?

On Oracle it will be a LOB I have not checked how MS SQL Server is handling a (memo) type ... Regards Carsten F. Frandsen Fra: Matt Benic [mailto:[EMAIL PROTECTED] Sendt: ti 18-01-2005 15:10 Til: Axapta Dev Emne: [development-axapta] Varchar

SV: [development-axapta] Ctrl-Alt-F4 functionality?

Hi Erik! Use the jumpRef method on the form control ... Regards Carsten F. Frandsen :-) Fra: Erik Hansen [mailto:[EMAIL PROTECTED] Sendt: ma 17-01-2005 14:32 Til: development-axapta@yahoogroups.com Emne: [development-axapta] Ctrl-Alt-F4

SV: [development-axapta] Problem with ax 2.5 to 3.0 post-sync data upgrade

a special character (e.g. XXX instead of ' ) HTH Carsten F. Frandsen Fra: el8tion [mailto:[EMAIL PROTECTED] Sendt: on 12-01-2005 18:39 Til: development-axapta@yahoogroups.com Emne: [development-axapta] Problem with ax 2.5 to 3.0 post-sync data upgrade

SV: [development-axapta] treeNodeExport

Hi! I believe that you have to have the project window opened before exporting. /Carsten Fra: morx999 [mailto:[EMAIL PROTECTED] Sendt: on 17-11-2004 16:40 Til: [EMAIL PROTECTED] Emne: [development-axapta] treeNodeExport I would like export a

SV: [development-axapta] Axapta COM

setup/configure your Axapta COM Connector to log on as a known user on the network. Sincerly Carsten F. Frandsen MIKIA IT-Solutions Fra: Steeve Gilbert [mailto:[EMAIL PROTECTED] Sendt: ti 14-09-2004 20:40 Til: [EMAIL PROTECTED] Emne: [development

RE: [development-axapta] Validation on insert and update

Hi Matt! Use the validateWrite method located on the table. Return false if you do not want to update. Best regards Carsten F. Frandsen MIKIA IT-Solutions -Original Message- From: Matt Benic [mailto:[EMAIL PROTECTED] Sent: 30. juli 2004 10:33 To: Axapta Dev Subject

SV: [development-axapta] report syntax 't' for today

As far as i remember the following rules apply: In a date field both d and t will set the value to the current systemdate (method systemDateGet()). In a time field t will insert the current time (method timeNow()). Best regards Carsten F. Frandsen MIKIA IT-Solutions

SV: [development-axapta] join code in the inventSumFinancial class

Hi !!! Look in the AOT\Macros section it contains the macro InventDimJoin. The rest of the line are parameters which are used in the macro using %1, %2 ... and so on ... HTH Carsten F. Frandsen MIKIA IT-Solutions Fra: paulinavk [mailto:[EMAIL

SV: [development-axapta] Problems running Syncronize when running Upgrade checkList Ax30 SP3

to create or replace the package Axapta. Performance wise it is important to allow the upgrade to perform that job otherwise upgrade will be performing very slow. Best regards Carsten F. Frandsen MIKIA IT-Solutions Fra: Jacob Christian Døskeland [mailto

RE: [development-axapta] Bank Reconciliation Report

regards Carsten F. Frandsen System Developer Columbus IT Partner International A/S Krudtlbsvej 1 Quintus Bastion DK-1439 Copenhagen K Denmark Phone: +45 70 20 50 00 Fax:+45 70 25 07 01 email: [EMAIL PROTECTED] WWW:www.columbusit.com -Original Message- From: Amar

RE: [development-axapta] Bank Reconciliation Report

Hi! Sorry I'm all out of suggestions ! Best regards Carsten F. Frandsen System Developer Columbus IT Partner International A/S Krudtlbsvej 1 Quintus Bastion DK-1439 Copenhagen K Denmark Phone: +45 70 20 50 00 Fax:+45 70 25 07 01 email: [EMAIL PROTECTED] WWW