Utility Of RecId

schabot
schabot Member Posts: 2
edited 2004-05-25 in Dynamics AX
Is it possible to load data into standard axapta table (ie:InventTable, CRM Tables,...) directly in sql server (with a procedure or else) ?
May i manually generate the recid in the table or is it necessary to do that inside Axapta application to keep data integrity ?

Application should be re-indexed after recid being modified ?

Thanks in advance.
Regards.

Comments

  • CaHor
    CaHor Member Posts: 3
    You may use a COM call to get the required recid!
  • AndyPeng
    AndyPeng Member Posts: 10
    Hi,
    I think It is possible,but dangerous, all recid is stored in table SysSearchRef, but if you change it directly, I am not comment to do so.
    I comment you to import your data for excel. I imported more than 10000 records from excel when I implemented our axapta system. it is perfect!!!
    Andy.Peng
    Best Regard!
  • Mariusz_Kopacki
    Mariusz_Kopacki Member Posts: 2
    Next RecId value is stored in SystemSequences table - on a per company basis. Just use appropriate, incremented values during the SQL import.

Categories