Export (0) Print
Expand All

SqlParameters Table

The SqlParameters table stores database-related information in the form of parm and value pairs. As of AX 2009, this table is not used.

ID: 65517

Security Key: AdminTables

Method

Description

aosValidateDelete

(Inherited from xRecord.)

aosValidateInsert

(Inherited from xRecord.)

aosValidateRead

(Inherited from xRecord.)

aosValidateUpdate

(Inherited from xRecord.)

cancelTimeOut

Cancels a previous method call to the Object::setTimeOut Method. (Inherited from Object.)

caption

(Inherited from xRecord.)

checkRecord

(Inherited from xRecord.)

checkRestrictedDeleteActions

(Inherited from xRecord.)

clear

(Inherited from xRecord.)

company

(Inherited from xRecord.)

concurrencyModel

(Inherited from xRecord.)

context

(Inherited from xRecord.)

data

(Inherited from xRecord.)

dataSource

(Inherited from xRecord.)

dbOpInTransaction

(Inherited from xRecord.)

delete

(Inherited from xRecord.)

disableCache

(Inherited from xRecord.)

doClear

(Inherited from xRecord.)

doDelete

(Inherited from xRecord.)

doInsert

(Inherited from xRecord.)

doUpdate

(Inherited from xRecord.)

doValidateDelete

(Inherited from xRecord.)

equal

(Inherited from xRecord.)

executeCachedDisplayMethods

(Inherited from xRecord.)

getPresenceFieldData

(Inherited from xRecord.)

getTimeOutTimerHandle

Returns the timer handle for the object. (Inherited from Object.)

handle

Retrieves the handle of the class of the object. (Inherited from Object.)

helpField

(Inherited from xRecord.)

initValue

(Inherited from xRecord.)

insert

(Inherited from xRecord.)

isFormDataSource

(Inherited from xRecord.)

isTmp

(Inherited from xRecord.)

joinChild

(Inherited from xRecord.)

joinParent

(Inherited from xRecord.)

merge

(Inherited from xRecord.)

modifiedField

(Inherited from xRecord.)

new

Initializes a new instance of the Object class.. (Inherited from Object.)

notify

Releases the hold on an object that has called a wait method on this object. (Inherited from Object.)

notifyAll

Releases a lock on the object that was issued by a wait method on this object. (Inherited from Object.)

objectOnServer

Determines whether the object is on a server. (Inherited from Object.)

orig

(Inherited from xRecord.)

overwriteSystemfields

(Inherited from xRecord.)

owner

Returns the instance that owns the object. (Inherited from Object.)

postLoad

(Inherited from xRecord.)

queryTimedOut

(Inherited from xRecord.)

queryTimeout

(Inherited from xRecord.)

readPast

(Inherited from xRecord.)

recordLevelSecurity

(Inherited from xRecord.)

renamePrimaryKey

(Inherited from xRecord.)

reread

(Inherited from xRecord.)

RowCount

(Inherited from xRecord.)

selectForUpdate

(Inherited from xRecord.)

selectLocked

(Inherited from xRecord.)

selectRefRecord

(Inherited from xRecord.)

selectWithRepeatableRead

(Inherited from xRecord.)

setConnection

(Inherited from xRecord.)

setTimeOut

Sets up the scheduled execution of a specified method. (Inherited from Object.)

setTmp

(Inherited from xRecord.)

setTmpData

(Inherited from xRecord.)

skipAosValidation

(Inherited from xRecord.)

skipDatabaseLog

(Inherited from xRecord.)

skipDataMethods

(Inherited from xRecord.)

skipDeleteActions

(Inherited from xRecord.)

skipDeleteMethod

(Inherited from xRecord.)

skipEvents

Provides an option to turn off calling the Application.event* methods for the life time of the xRecord instance. (Inherited from xRecord.)

skipTTSCheck

(Inherited from xRecord.)

suppressWarnings

(Inherited from xRecord.)

toolTipField

(Inherited from xRecord.)

toolTipRecord

(Inherited from xRecord.)

toString

Returns a string that represents the current object. (Inherited from Object.)

ttsabort

(Inherited from xRecord.)

ttsbegin

(Inherited from xRecord.)

ttscommit

(Inherited from xRecord.)

update

(Inherited from xRecord.)

usageCount

(Inherited from xRecord.)

validateDelete

(Inherited from xRecord.)

validateField

(Inherited from xRecord.)

validateWrite

(Inherited from xRecord.)

wait

Pauses a process. (Inherited from Object.)

wasCached

(Inherited from xRecord.)

write

(Inherited from xRecord.)

xml

(Inherited from xRecord.)

Field

ID

Type

Configuration key

Description

id

1

None

parm

2

None

value

3

None

iParm

4

None

iValue

5

None

recVersion

61450

System Data Type: recVersion

Type: int

None

RecId

65534

System Data Type: recId

Type: int64

None

Relation

Table

Lines

DataArea

DataArea Table

SqlParameters.dataAreaId == DataArea.id

Index

AllowDuplicates

Enabled

Fields

Parm

No

Yes

parm

id

iParm

Use of this table might lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to CreateUpdateDelete. The Application Object Server authorizes each create, update, and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception is thrown.

Community Additions

ADD
Show:
© 2014 Microsoft