vdarthur的部落格

This dwarfish nonfictional prose is written, supported on new features of the product, as well as considering Microsoft Dynamics GP customization tools combining: Dex, eConnect, SQL Stored Procs, Extender. Currently we guess that you are victimization Microsoft Dynamics GP magazine 9.0, in a moment we should wish Microsoft Dynamics GP 10.0 to be released

o Microsoft Dexterity. It is also oft associated with alleged Dynamics GP basis written language programing. MBS VAR, who has entree to cause belief (DYNAMICS.DIC dictionary next to dex sanscript scripts up to date). Dexterity has no ends in accessing and modifying GP resources, such as as tables, forms, reports, scrolling windows, assemblage types, etc. Obviously, when you get specified a almighty tool, you should predict that it will have as pluses as capably as minuses. Dexterity is not publicly point oriented linguistic communication - you will obligation to programme old-good-days procedures, functions and dex cursors.

o Dexterity improvements. Beginning with copy 7.0 - you may run COM objects. Historically when SQL Server 6.5 was introduced Dex enabled business hold on procedures, more dislike improvements allowed developers nickname SQL scripts from dex.

o Dexterity and eConnect. Contrary to Dexterity, eConnect allows you to rub GP objects: Customer, Vendor, Sales Order, Purchase Order, Employee, etc. - and so has weather of object-oriented planning. We advocate you to characterize scenario, when Dexterity is used for new method classmates and consequently from these new forms you phone up eConnect via eConnect XML Web Services surface. This manner allows you to turn out broadloom GP consumer/workstation merged made-to-order logic

o Extender. eOne Extender is extraordinarily elastic module, allowing you to "send back" dex intricacy and mould GP forms, tables, some poster logic, positive add Dex sunscript belief to these new constructions. We would advocate Microsoft Visual Studio arousing mind-set present - when you are finished next to tables prototyping in Extender, humour think about Visual Studio DLL hang over to toil with recently created tables and phone call eConnect methods to fix GP objects

o SQL Scripting. In new Microsoft ERP products, specified as Axapta or Microsoft CRM - conduct SQL scripting is typically not subsidized. GP was traditionally investing SQL coding, so you are make the acquaintance of to construct SQL integrations, on the other hand you should have whichever conversancy with Microsoft Great Plains Dexterity architecture: DEX_ROW_ID, for model. Dexterity has alleged atomic scripts - hold on procs, allowing Dex shell, engrossed in C planning talking to read SQL tables by dex indexes, these keep procs have prefix zdp_*