How to create new table?

toniM
toniM Member Posts: 11
edited 2005-09-26 in NAV/Navision Classic Client
How to create runtime new table in Navision?

Comments

  • HalMdy
    HalMdy Member Posts: 429
    What do you mean by "runtime" ? During execution of some code ?

    You can't, sorry ... [-(

    You can work on a temporally table, wich is a "copy" (in terms of structure) of an existing table, meaby that could help you ... Why do you need to create a table during runtime ? Oher solutions may exist ...
  • John
    John Member Posts: 43
    Creating a table you can
    Insert in the follwint tables:

    Name DataType Subtype Length
    ObjectRec Record Object
    FieldRec Record Field

    Using that table in the proces, you can't.
    The new object needs to be compiled.
  • Waldo
    Waldo Member Posts: 3,412
    You could transfer the blob field from one record to another, but then you're still not creating a custom, but just copying tables... .

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • fb
    fb Member Posts: 246
    Hmm... Both C/ODBC and C/Front have table creation capabilities...

    You could use automation... (Use ADO to drive C/ODBC; or use the C/Front OCX interface directly.)

    Neither solution is very pretty, and there are major limits -- you can't set properties or validation code in either. Why not just use C/SIDE?
  • InterFish
    InterFish Member Posts: 5
    John wrote:
    Creating a table you can
    Insert in the follwint tables:

    Name DataType Subtype Length
    ObjectRec Record Object
    FieldRec Record Field

    Using that table in the proces, you can't.
    The new object needs to be compiled.

    Hi John,

    inserting into the object table, i succeed. But when i try to add some fields after that, the system returns an error 'table ..... is empty.' Creating the fields first doesn't work either, so what can I do?

    Greetz

    'Fish
    IT-Co+De Dirk Fischer
    Member of OpenBC

Categories