Table, View and CursorAdapter Data

The SDATADDTV.DBF table contains a record for every table, view and cursoradapter in an application. The table has the following structure.

 

Field Name

Type

Width

Comments

cPK

Character

48

PK field

cFK_DDD

Character

48

FK to SDATADDD (Database or CA Library)

cFK_DDDS

Character

48

FK to SDATADDDS (Data Source)

cFK_DDDS_LToR

Character

48

FK to SDATADDDS when nLToR_UseRemoteView = 1

cDescription

Character

100

Description

cDupPKView

Character

80

Name of view used to perform the duplicate PK check.

cDupPKViewDBC

Character

80

Name of the database that contains the view specified in the cDupPKView field.

cLToR_RemoteView

Character

80

Name of remote view for local-to-remote functionality.

cLToR_RemoteViewDBC

Character

80

Name of the database that contains the view specified in the cLToR_RemoteView field.

cName

Character

80

Table, view, or cursoradapter name

mComments

Memo

 

Comments

mLocation

Memo

 

Path to table if it is located outside the project directories.

mMainViewSource Database

Memo

 

For a view, identifies the database containing the source table.

mMainViewSource Table

Memo

 

For a view, identifies the source table.

mPostAddCode

Memo

 

Contains code that is run after a new record is created. The code is entered though the Data Builder/Manager.

mPostCopyCode

Memo

 

Contains code that is run after a record is created by copying an existing record. The code is entered though the Data Builder/Manager.

mPostDeleteCode

Memo

 

Contains code that is run after a record is deleted but before the transaction has ended. The code is entered though the Data Builder/Manager.

mPostDeletePost

TransactionCode

Memo

 

Contains code that is run after a record is deleted and after the transaction has ended. The code is entered though the Data Builder/Manager.

mPostRestoreCode

Memo

 

Contains code that is run after changes to a record are reverted. The code is entered though the Data Builder/Manager.

mPostSaveCode

Memo

 

Contains code that is run after a record is saved but before the transaction has ended. The code is entered though the Data Builder/Manager.

mPostSavePost

TransactionCode

Memo

 

Contains code that is run after a record is saved and after the transaction has ended. The code is entered though the Data Builder/Manager.

mPreAddCode

Memo

 

Contains code that is run before a new record is created. The code is entered though the Data Builder/Manager.

mPreCopyCode

Memo

 

Contains code that is run before a record is copied. The code is entered though the Data Builder/Manager.

mPreDeleteCode

Memo

 

Contains code that is run before a record is deleted but after the transaction has begun. The code is entered though the Data Builder/Manager.

mPreDeletePre

TransactionCode

Memo

 

Contains code that is run before a record is deleted and before the transaction has begun. The code is entered though the Data Builder/Manager.

mPreRestoreCode

Memo

 

Contains code that is run before a record is reverted. The code is entered though the Data Builder/Manager.

mPreSaveCode

Memo

 

Contains code that is run before a record is saved but after the transaction has begun. The code is entered though the Data Builder/Manager.

mPreSavePre

TransactionCode

Memo

 

Contains code that is run before a record is saved and before the transaction has begun. The code is entered though the Data Builder/Manager.

nLToR_UseRemote View

Numeric

1

 If 1, the local-to-remote functionality is turned on for the view.

nRecycleRecs

Numeric

1

Indicates whether deleted records in table should be recycled when the table is edited on a form. Default is 1, deleted records are recycled.

nSourceType

Numeric

1

1 (local view), 2 (remote view), 3 (table), 4 (cursoradapter)

nUseDupPKView

Numeric

1

If 1, the  view specified in the cDupPKView field is  used to perform the duplicate PK check.

mSelectCommand

Memo

 

Contains the SELECT command of the view or cursoradapter.

More:

Field Data