How To

ODBCSQLAX 2009BasicCodeLoginPropertyOdbcConnectionStatementResultSetSqlStatementExecutePermission

Selecting and Updating Records from an External Database

By Nathan Clouse / Wed 08,2011

Getting data through ODBC is fairly easy but updating it can be a little tricky. Here we will cover how to update data through ODBC.

AX 2009BasicCodeAX 2012LookupJumpRefMenuFunction

Form Control Lookup without a Data Source

By Nathan Clouse / Tue 08,2011

Discover how to create a lookup manually when the control isn't bound to a datasource field.

ODBCSQLAX 2009BasicCodeAX 2012StatementResultSetSqlStatementExecutePermissionDictTableConnection

Selecting Records from an External Database

By Nathan Clouse / Mon 08,2011

A code sample on how to select data directly from a database.

ODBCSQLStored ProcedureAX 2009BasicCodeAX 2012StatementResultSetSqlStatementExecutePermissionUserConnectionSqlSystem

Execute a SQL Stored Procedure

By Nathan Clouse / Mon 08,2011

This covers how to connect to an external ODBC data source and execute a stored procedure.

AX 2009BasicCodeUnit

How to do a Unit Conversion

By Nathan Clouse / Sun 08,2011

The UnitConvert table has the method for doing unit conversions on the fly.

Zero PaddingAX 2009BasicGlobalAX 2012

Zero Padding Numbers

By Nathan Clouse / Sun 08,2011

AX provides us with an easy way to pad strings with extra characters.

AX 2009BasicGlobalCodeAX 2012Date Timedate2str

Get a TimeStamp That Can Be Used For File Output

By Nathan Clouse / Sun 08,2011

If you are writing files out of AX for some reason, it would be a good idea to use a timestamp mechanism of some sort. This example goes over how to do that.

AX 2009BasicGlobalCodeAX 2012Date Timedate2str

Get a "Pretty" Printed Date Time

By Nathan Clouse / Sun 08,2011

This covers how to format a date and time to get it into a particular format. In this instance, we are formatting it for use on a report.

InfologAX 2009BasicCodeAX 2012InfoLog

Capturing Entries from the Infolog

By Nathan Clouse / Sun 08,2011

You can capture lines from the infolog to use elsewhere if you so desire. This is a brief example of how to do it.

AX 2009Inventory ManagementCodeInventOnHandOn Hand Inventory

Using the InventOnHand Class

By Nathan Clouse / Sun 08,2011

In 2009, The InventOnHand class can tell you a lot about what is currently on hand by inventory dimension. This is a brief example of how to use it.