systemSequence Class

Definition

Namespace:

Dynamics.AX.Application

Assembly:

Microsoft.Dynamics.AX.Xpp.Support.dll

The systemSequence class takes manual control of the system sequence generator and delivers unique RecIds for all SQL tables.

public ref class systemSequence : Microsoft::Dynamics::Ax::Xpp::XppObjectBase

[Microsoft.Dynamics.Ax.Xpp.KernelClass]
[Microsoft.Dynamics.BusinessPlatform.SharedTypes.InternalUseOnly]
public class systemSequence : Microsoft.Dynamics.Ax.Xpp.XppObjectBase

[<Microsoft.Dynamics.Ax.Xpp.KernelClass>]
[<Microsoft.Dynamics.BusinessPlatform.SharedTypes.InternalUseOnly>]
type systemSequence = class
    inherit XppObjectBase

Public Class systemSequence
Inherits XppObjectBase

Inheritance

Microsoft.Dynamics.AX.KernelInterop.ProxyBase

XppObjectBase

systemSequence

Attributes

KernelClassAttribute Microsoft.Dynamics.BusinessPlatform.SharedTypes.InternalUseOnlyAttribute

Remarks

When records are inserted into SQL tables, a unique RecId is assigned to each record regardless of the company each record is associated with. Use extreme caution when you use this class, because data integrity could be destroyed. This class is typically used for data import or export routines, or for very large jobs. The record ID is an int64 data type value. The range in which record IDs are allocated is from 5637144576 to 2^63 (9223372036854775808). RecIds can be used up prematurely if large, unused ranges of RecIds are created. Reclaiming unused ranges of RecIds that lie between used ranges of RecIds is a very complicated process.

The following example reserves the int64max value for the CustTable table.

static public void Main(Args _args) 
{ 
    systemSequence seq; 
    seq = new SystemSequence(); 
    if (seq) 
    { 
        // Allocate 20 recordIds for CustTable table. 
        seq.reserveValues(20, tablenum(CustTable)); 
        // Suspend automatic recId allocation. 
        Seq.suspendRecIds(tablenum(CustTable)); 
        // Manually generate recIds in the range allocated. 
        // Remove the recId suspension. 
        Seq.removeRecIdSuspension(); 
      } 
}

Constructors

systemSequence()

systemSequence(IntPtr)

Fields

kernelClass

(Inherited from XppObjectBase)

Methods

__shouldCallNew(Type)
addXppProxyReference(Type, Object)	(Inherited from XppObjectBase)
Call(String, Object[], Type[], Object[])	(Inherited from XppObjectBase)
cancelTimeOut(Int32)	(Inherited from XppObjectBase)
createKernelClass(Object[], Type[], Object[])	(Inherited from XppObjectBase)
equal(XppObjectBase)	(Inherited from XppObjectBase)
finalize()	(Inherited from XppObjectBase)
flushValues(Int32)	Flushes the reserved recIds from the System Sequence cache for a given table
GetIntPtr()
GetKernelInstanceUniqueId()	(Inherited from XppObjectBase)
getTimeOutTimerHandle()	(Inherited from XppObjectBase)
getXppProxyReference(Type)	(Inherited from XppObjectBase)
handle()
IsManagedValid()
kernelhandle()
KernelInstanceDisposed()	(Inherited from XppObjectBase)
MakeReflectionCall(String, Object[])	(Inherited from XppObjectBase)
newmethod()	Initializes a new instance of the systemSequence class.
notify()	(Inherited from XppObjectBase)
notifyAll()	(Inherited from XppObjectBase)
objectOnServer()	Obsolete. (Inherited from XppObjectBase)
removeRecIdSuspension()
removeRecIdSuspension(Int32)
removeTransIdSuspension()
removeTransIdSuspension(Int32)
reserveTransids(Int64)
reserveTransids(Int64, Int32)
reserveValues(Int64, Int32)	Preallocates a range of recIds that can be allocated to new records when the automatic assignment of recIds has been suspended.
setTimeOut(String, Int32)	Obsolete. (Inherited from XppObjectBase)
setTimeOut(String, Int32, Boolean)	Obsolete. (Inherited from XppObjectBase)
suspendRecIds(Int32)
suspendTransIds(Int32)
usageCount()	(Inherited from XppObjectBase)
VerifyKernelClass()	(Inherited from XppObjectBase)
wait()	(Inherited from XppObjectBase)
Xml()	(Inherited from XppObjectBase)
Xml(Int32)	(Inherited from XppObjectBase)