Is it possible to Delete Navision Variables dynamically

selva1990
selva1990 Member Posts: 25
Hi Everyone,

I need to delete all the code,functions and variable of particular table dynamically. Is it possible in navision...i need only fields in the table.

Comments

  • kine
    kine Member Posts: 12,562
    Strange request.

    Only automatic way I see is to programmatically export the object into text file, "automatically" edit it (remove what you do not need), import it back and compile. It could be done through code or powershell for NAV 2013. But question is, if it is worth of it. Because may be there is easier manual way of doing what you need...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    In the NAV code editor (AKA Notepad 0.9) you can use CTRL+A to select all lines and use F4 to delete them. Then delete all Global Variables, Text Constants and Functions.

    5 seconds job.
  • selva1990
    selva1990 Member Posts: 25
    @Mark Brummel

    i have to do it for 217 tables, that's why am looking for some other dynamic way
  • kine
    kine Member Posts: 12,562
    217 * 5 = 1085 seconds = 18 minutes. How log are you waiting for answer and how logn will you implement it?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • DenSter
    DenSter Member Posts: 8,307
    kine wrote:
    217 * 5 = 1085 seconds = 18 minutes. How log are you waiting for answer and how logn will you implement it?
    =D> :mrgreen:
  • mdPartnerNL
    mdPartnerNL Member Posts: 802
    selva1990 wrote:
    @Mark Brummel

    i have to do it for 217 tables, that's why am looking for some other dynamic way

    Are you on an upgrade path? I have created a beyond compare script for this but it lacks documentation.

    If you really in a hurry send me a PM and I can do it for you in 5 minutes.
  • kine
    kine Member Posts: 12,562
    Or all is just question of correct keys pressed in correct order (like Ctrl+A,Delete,Ctrl+PgDn,...). You can create macro for that with tools supporting macros for any application. Than it is just question of running the macro... ;-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.