Namespace: Consultingwerk.SmartFramework
Class 
SmartDataAccess Copy to Clipboard
Parent classes:
Progress.Lang.Object
Consultingwerk.OERA.DataAccess
Consultingwerk.SmartFramework.SmartDataAccess

Inherits: Consultingwerk.OERA.DataAccess
Implements: Consultingwerk.OERA.IDataAccess, Consultingwerk.OERA.IDataAccessCanFind, Consultingwerk.OERA.IDataAccessCountRecords, IDSQueryStringSource, Consultingwerk.OERA.IProvidesSmartRecordInformation
Inherited by: Consultingwerk.SmartFramework.Authentication.UserDataAccess Consultingwerk.SmartFramework.Authentication.UserProfileDataAccess Consultingwerk.SmartFramework.Authorization.FieldSecurityItemDataAccess Consultingwerk.SmartFramework.Authorization.GroupDataAccess Consultingwerk.SmartFramework.Authorization.MenuGroupDataAccess Consultingwerk.SmartFramework.Authorization.ParentGroupDataAccess Consultingwerk.SmartFramework.Repository.Class.AttributeGroupDataAccess Consultingwerk.SmartFramework.Repository.Class.AttributeUsed.AttributeValueDataAccess Consultingwerk.SmartFramework.Repository.Class.AttributeValueDataAccess Consultingwerk.SmartFramework.Repository.Class.ClassTypeDataAccess Consultingwerk.SmartFramework.Repository.Class.LinkTypeDataAccess Consultingwerk.SmartFramework.Repository.Class.ObjectTypeDataAccess Consultingwerk.SmartFramework.Repository.Class.SupportedInstanceObjectTypeDataAccess Consultingwerk.SmartFramework.Repository.Class.SupportedLinkDataAccess Consultingwerk.SmartFramework.Repository.Customization.CustomizationDataAccess Consultingwerk.SmartFramework.Repository.Customization.CustomizationTypeDataAccess Consultingwerk.SmartFramework.Repository.Field.EntityFieldMappingDataAccess Consultingwerk.SmartFramework.Repository.Object.Export.ObjectMasterDataAccess Consultingwerk.SmartFramework.Repository.Object.ObjectMasterDataAccess Consultingwerk.SmartFramework.Repository.Object.WhereUsed.WhereUsedDataAccess Consultingwerk.SmartFramework.Repository.ScreenMapping.EntityTableMappingDataAccess Consultingwerk.SmartFramework.Repository.ScreenMapping.ScreenTypeDataAccess Consultingwerk.SmartFramework.Repository.ScreenMapping.UiTypeDataAccess Consultingwerk.OERA.DynamicBusinessEntity.DynamicDataAccess Consultingwerk.SmartFramework.System.TableDataAccess Consultingwerk.SmartFramework.System.Tags.TagDataAccess Consultingwerk.SmartFramework.System.TranslationDataAccess Consultingwerk.SmartFramework.System.UiTranslationDataAccess Consultingwerk.SmartFramework.System.ValueListDataAccess Consultingwerk.SmartFramework.Web.RouteDataAccess Consultingwerk.SmartFramework.Workflow.WorkflowDataAccess Consultingwerk.SmartFramework.Workflow.WorkflowExecutionLogDataAccess Consultingwerk.SmartFramework.Workflow.WorkflowInstanceDataAccess Consultingwerk.SmartUnit.OERA.MockDataAccess.GenericMockDataAccess Consultingwerk.SmartFramework.Authorization.SecurityAssignmentDataAccess Consultingwerk.SmartFramework.Authorization.SecurityObjectDataAccess Consultingwerk.SmartFramework.Authorization.SecurityRealmDataAccess Consultingwerk.SmartFramework.Authorization.SecurityTokenDataAccess Consultingwerk.SmartFramework.Authorization.ToolbarSecurityItemDataAccess Consultingwerk.SmartFramework.Authorization.UserGroupDataAccess Consultingwerk.SmartFramework.Context.ContextStoreDataAccess Consultingwerk.SmartFramework.Lock.LockDataAccess Consultingwerk.SmartFramework.Menu.MenuDataAccess Consultingwerk.SmartFramework.Menu.MenuStyleDataAccess Consultingwerk.SmartFramework.Menu.ModuleDataAccess Consultingwerk.SmartFramework.Menu.ProductDataAccess Consultingwerk.SmartFramework.Repository.BusinessEntities.RepositoryObjectDataAccess Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaBusinessEntity.MetaBusinessEntityDataAccess Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaDataSource.MetaDataSourceDataAccess Consultingwerk.SmartFramework.Repository.BusinessEntities.MetaEntityTable.MetaEntityTableDataAccess Consultingwerk.SmartFramework.Repository.Class.AttributeDataAccess Consultingwerk.SmartFramework.Scheduler.SchedulerJobDataAccess Consultingwerk.SmartFramework.Scheduler.SchedulerJobPlanDataAccess Consultingwerk.SmartFramework.Scheduler.SchedulerJobStatusDataAccess Consultingwerk.SmartFramework.Scheduler.SchedulerQueueDataAccess Consultingwerk.SmartFramework.System.AttachmentDataAccess Consultingwerk.SmartFramework.System.AttachmentRoleDataAccess Consultingwerk.SmartFramework.System.CommentRoleDataAccess Consultingwerk.SmartFramework.System.ConfigurationValueDataAccess Consultingwerk.SmartFramework.System.DeletionDataAccess Consultingwerk.SmartFramework.System.ImportFileStatus.ImportFileStatusDataAccess Consultingwerk.SmartFramework.System.KeyFieldAssignmentTypeDataAccess Consultingwerk.SmartFramework.System.LanguageDataAccess Consultingwerk.SmartFramework.System.LoginCompanyDataAccess Consultingwerk.SmartFramework.System.MessageDataAccess Consultingwerk.SmartFramework.System.ModifiedStateDataAccess Consultingwerk.SmartFramework.System.RelationDataAccess Consultingwerk.SmartFramework.System.SmartBusinessEntityDataAccess Consultingwerk.SmartFramework.System.SmartCache.CacheDataAccess
ABSTRACT


Navigate to: Methods | Constructors | Events | Properties | ProDatasets | Temp-Tables



Top Method Summary
Options Name Purpose
AssignKeyFieldValues (handle) Invoked by DataAccess:CommitChanges within the database transaction to optionally assign key field values for new records
AssignSmartRecordInformation () Assign SmartRecordKey and Attachment/Comment function
CheckSystemOwned (handle) Checks if the user is authorized to maintain records with the System Owned flag
CommitChanges (handle) This procedure is called from SaveChanges in the DA to do the actual database commit and any transaction-related validation logic for a buffer.
ResetModifiedState (character, character) Resets a modification for the given table and key field values
CHARACTER SourceTable (character) Returns the name of the source (database) table for a ProDataset table name
CHARACTER TargetColumn (character, character, handle) Returns the temp-table field name matching a database field name
TrackModifiedState (character, character) Tracks a modification for the given table and key field values
ValidateAddOnlyColumns (handle, character) Performs AddOnly validation for a list of columns
ValidateMandatoryColumns (handle, character) Performs Mandatory validation for a list of columns
ValidateSmartTableMetadata (handle) Performs mandatory and add-only validation based on SmartTable metadata
CHARACTER ValidationColumns (handle, character, character) Maps source table columns to temp-table columns for validation

Top Constructor Summary
Options Name Purpose
SmartDataAccess (handle) Constructor of the SmartDataAccess class

Top Property Summary
Options Name Purpose
LOGICAL DisableReferentialIntegrity
Consultingwerk.Framework.Collections.CharacterDictionary SourceTables
LOGICAL TrackDeletions
LOGICAL UseNoWaitForReferentialIntegrity


Method Detail
Top

AssignKeyFieldValues (handle)
Purpose: Invoked by DataAccess:CommitChanges within the database transaction
to optionally assign key field values for new records
Notes: Assigns key field values for new records based on the
SmartTable.KeyFieldAssignmentGUID setting

Parameters:
phBeforeBuffer HANDLE
The handle of the before buffer
Top

AssignSmartRecordInformation ()
Purpose: Assign SmartRecordKey and Attachment/Comment function
Notes:

Top

CheckSystemOwned (handle)
Purpose: Checks if the user is authorized to maintain records with the
System Owned flag
Notes:

Parameters:
phBuffer HANDLE
The handle of the buffer
Top

CommitChanges (handle)
Purpose: This procedure is called from SaveChanges in the DA
to do the actual database commit and any transaction-related
validation logic for a buffer.
Notes: Override to CommitChanges in the DataAccess class. Performs cascading
deletion of SmartAttachment records
Uses Consultingwerk.SmartFramework.IRelationService to ensure
referential integrity (Delete Restrict, Delete Cascade)

Parameters:
phBuffer HANDLE
The handle of the buffer to commit
Top

ResetModifiedState (character, character)
Purpose: Resets a modification for the given table and key field values
Notes:

Parameters:
pcModifiedTable CHARACTER
The name of the database table to reset the modification for
pcKeyFieldValues CHARACTER
The values of the key fields to reset the modification for
Top

CHARACTER SourceTable (character)
Purpose: Returns the name of the source (database) table for a ProDataset
table name
Notes:

Parameters:
pcTempTableName CHARACTER
The temp-table buffer name to return the source table for
Returns CHARACTER
The database table name of the source table
Top

CHARACTER TargetColumn (character, character, handle)
Purpose: Returns the temp-table field name matching a database field name
Notes: The database table specified is the source table of the temp-table
This method should be overridden when the default functionality does
not return the proper field mapping (complex joined queries)

Parameters:
pcDatabaseTable CHARACTER
The name of the source database table
pcColumn CHARACTER
The name of the database field to return the mapped temp-table for
phDataSource HANDLE
The data source with the established mapping
Returns CHARACTER
The target (temp-table) field name
Top

TrackModifiedState (character, character)
Purpose: Tracks a modification for the given table and key field values
Notes:

Parameters:
pcModifiedTable CHARACTER
The name of the database table to track the modification for
pcKeyFieldValues CHARACTER
The values of the key fields to track the modification for
Top

ValidateAddOnlyColumns (handle, character)
Purpose: Performs AddOnly validation for a list of columns
Notes:

Parameters:
phBuffer HANDLE
The handle of the buffer to validate
pcColumns CHARACTER
The list of columns to validate
Top

ValidateMandatoryColumns (handle, character)
Purpose: Performs Mandatory validation for a list of columns
Notes:

Parameters:
phBuffer HANDLE
The handle of the buffer to validate
pcColumns CHARACTER
The list of columns to validate
Top

ValidateSmartTableMetadata (handle)
Purpose: Performs mandatory and add-only validation based on SmartTable metadata
Notes:

Parameters:
phBuffer HANDLE
The temp-table buffer handle
Top

CHARACTER ValidationColumns (handle, character, character)
Purpose: Maps source table columns to temp-table columns for validation
Notes:

Parameters:
phBuffer HANDLE
The temp-table buffer handle
pcTableName CHARACTER
The source database table name
pcColumns CHARACTER
The source table columns list
Returns CHARACTER
The mapped temp-table columns list


Constructor Detail
Top

SmartDataAccess (handle)
Purpose: Constructor of the SmartDataAccess class
Notes:

Parameters:
phDataset HANDLE
The handle of the Business Entity dataset


Property Detail
Top

LOGICAL DisableReferentialIntegrity

Returns LOGICAL
Top

Consultingwerk.Framework.Collections.CharacterDictionary SourceTables

Returns Consultingwerk.Framework.Collections.CharacterDictionary
Top

LOGICAL TrackDeletions

Returns LOGICAL
Top

LOGICAL UseNoWaitForReferentialIntegrity

Returns LOGICAL


©2006-2026 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       06.07.2026 14:32:50