ADO-Konstanten für JScript #

JScript kennt keine eingebauten ADO-Konstanten. Wenn Sie mit Client.ExecuteSql oder der Client.Connection-Eigenschaft arbeiten und ADO-Konstanten benötigen, müssen diese im Script deklariert werden.

Nachfolgend sind die wichtigsten ADO-Konstanten (ActiveX Data Objects) als JScript-Deklaration aufgeführt. Eine Erklärung der einzelnen Konstantengruppen finden Sie unter ADO-Konstanten.

Cursor Type #

var adOpenUnspecified = -1;
var adOpenForwardOnly = 0;
var adOpenKeyset = 1;
var adOpenDynamic = 2;
var adOpenStatic = 3;

Lock Type #

var adLockUnspecified = -1;
var adLockReadOnly = 1;
var adLockPessimistic = 2;
var adLockOptimistic = 3;
var adLockBatchOptimistic = 4;

Execute Options #

var adOptionUnspecified = -1;
var adAsyncExecute = 0x10;
var adAsyncFetch = 0x20;
var adAsyncFetchNonBlocking = 0x40;
// Wenn kein Recordset als Rückgabe erwartet wird,
// sollte diese Option angegeben werden, da sich die
// Ausführungsgeschwindigkeit hierdurch merkbar beschleunigt.
var adExecuteNoRecords = 0x80;

Object State #

var adStateClosed = 0;
var adStateOpen = 1;
var adStateConnecting = 2;
var adStateExecuting = 4;
var adStateFetching = 8;

Cursor Location #

var adUseNone = 1;
var adUseServer = 2;
var adUseClient = 3;

Datentypen #

var adEmpty = 0;
var adTinyInt = 16;
var adSmallInt = 2;
var adInteger = 3;
var adBigInt = 20;
var adUnsignedTinyInt = 17;
var adUnsignedSmallInt = 18;
var adUnsignedInt = 19;
var adUnsignedBigInt = 21;
var adSingle = 4;
var adDouble = 5;
var adCurrency = 6;
var adDecimal = 14;
var adNumeric = 131;
var adBoolean = 11;
var adError = 10;
var adUserDefined = 132;
var adVariant = 12;
var adIDispatch = 9;
var adIUnknown = 13;
var adGUID = 72;
var adDate = 7;
var adDBDate = 133;
var adDBTime = 134;
var adDBTimeStamp = 135;
var adBSTR = 8;
var adChar = 129;
var adVarChar = 200;
var adLongVarChar = 201;
var adWChar = 130;
var adVarWChar = 202;
var adLongVarWChar = 203;
var adBinary = 128;
var adVarBinary = 204;
var adLongVarBinary = 205;

Feld-Attribute #

var adFldUnspecified = -1;
var adFldMayDefer = 0x2;
var adFldUpdatable = 0x4;
var adFldUnknownUpdatable = 0x8;
var adFldFixed = 0x10;
var adFldIsNullable = 0x20;
var adFldMayBeNull = 0x40;
var adFldLong = 0x80;
var adFldRowID = 0x100;
var adFldRowVersion = 0x200;
var adFldCacheDeferred = 0x1000;
var adFldKeyColumn = 0x8000;

Edit Mode #

var adEditNone = 0;
var adEditInProgress = 1;
var adEditAdd = 2;
var adEditDelete = 4;

Record Status #

var adRecOK = 0;
var adRecNew = 1;
var adRecModified = 2;
var adRecDeleted = 4;
var adRecUnmodified = 8;
var adRecInvalid = 16;
var adRecMultipleChanges = 64;
var adRecPendingChanges = 128;
var adRecCanceled = 256;
var adRecCantRelease = 1024;
var adRecConcurrencyViolation = 2048;
var adRecIntegrityViolation = 4096;
var adRecMaxChangesExceeded = 8192;
var adRecObjectOpen = 16384;
var adRecOutOfMemory = 32768;
var adRecPermissionDenied = 65536;
var adRecSchemaViolation = 131072;
var adRecDBDeleted = 262144;

Command Type #

var adCmdUnspecified = -1;
var adCmdUnknown = 8;
var adCmdText = 1;
var adCmdTable = 2;
var adCmdStoredProc = 4;
var adCmdFile = 256;
var adCmdTableDirect = 512;

Connect Mode #

var adModeUnknown = 0;
var adModeRead = 1;
var adModeWrite = 2;
var adModeReadWrite = 3;
var adModeShareDenyRead = 4;
var adModeShareDenyWrite = 8;
var adModeShareExclusive = 12;
var adModeShareDenyNone = 16;

Parameter Direction #

var adParamUnknown = 0;
var adParamInput = 1;
var adParamOutput = 2;
var adParamInputOutput = 3;
var adParamReturnValue = 4;

Suchrichtung #

var adSearchForward = 1;
var adSearchBackward = -1;

Bookmark #

var adBookmarkCurrent = 0;
var adBookmarkFirst = 1;
var adBookmarkLast = 2;

Fehler-Konstanten #

var adErrInvalidArgument = 3001;
var adErrNoCurrentRecord = 3021;
var adErrIllegalOperation = 3219;
var adErrInTransaction = 3246;
var adErrFeatureNotAvailable = 3251;
var adErrItemNotFound = 3265;
var adErrObjectInCollection = 3367;
var adErrObjectNotSet = 3420;
var adErrDataConversion = 3421;
var adErrObjectClosed = 3704;
var adErrObjectOpen = 3705;
var adErrProviderNotFound = 3706;
var adErrBoundToCommand = 3707;
var adErrInvalidParamInfo = 3708;
var adErrInvalidConnection = 3709;
var adErrNotReentrant = 3710;
var adErrStillExecuting = 3711;
var adErrOperationCancelled = 3712;
var adErrStillConnecting = 3713;
var adErrUnsafeOperation = 3716;