Hi,

Microsoft Dynamics use C/SIDE language - derived from ADA.
C/SIDE has interface for COM and .NET components.

Complex code can use two ways:
1) LOOPS in LOOPS in LOOPS.... in LOOPS and temporary tables
2) Query - it's a special object (must be in licence) for "complex" query. The object type was added in MD (Navision) 2013.

Standard group functions (AVG(), SUM(), MAX(), MIN(), EXISTS()) can be used in table definition in field type "Calculated Field".

Code can be save, in parts called "triggers", in objects all objects - Form/Page, Report, DataPort/XMLPort, CodeUnit, Table, Query.

MartinaJ

>Hi all,
>
>I am still working with an outside development company who is proposing a solution for the VFP app that a client of mine has used for years. They are going to propose using Microsoft Dynamics. So far, this outside company does not (yet) seem to "get it" that there is a ton of code in this customer's app. I keep asking how they are planning to handle the more complex code and they keep thinking that we are dealing with simple input screens and simple output and simple SQL queries that populate simple tables Word templates.
>
>I have asked how they would handle the "complex" calcs this app needs (multiple SQL queries with post query "massage" of the data with code to give the client exactly what they want) - but no clear answers.
>
>So does anyone know if Dynamics allow the developer to tie into some custom code (C# or something) to do certain functions or data manipulation - or what are the options with it?
>
>Thanks,
>Albert