hi there,

when a new record will be inserted by the axapta-kernel, the value
for the systemfield RecId will be taken from the field NEXTVAL in
table SYSTEMSEQUENCES.
for your external program you can get and (!don't forget!) increment
the value from NEXTVAL.

due to the fact that this table holds records for other sequences
(t.e. TransId, Systemevents) and this for all axapta company-
accounts, you have to identify "your" record by:

DATAAREAID -->  axapta company account
NAME       -->  recId records will have SEQNO in this field
ID         -->  recId records will have -1 in this field


anyway:
I would stongly recommend to use the axapta com connector for
inserting/updating/deleting data from external applications if
possible. this will reduce potential sources of error (t.e. NULL
values, integer overflow, date/time values, ...)

nice day to all
regards
WoHeGro








Yahoo! Groups Links

Reply via email to