MARIProject Database Structure

Table Name:MPSysUserFormFields
View Name:MARISysUserFormFields
Group:Group: SysUserTable
Description:SDK: User-Defined Tables: Form Fields

Field View(engl.field)/Type Description Related
FormFieldID FormFieldID

INT Primary

TableID TableID

SMALLINT Index

MPSysUserTable.TableID
FieldName FieldName

NVARCHAR (50) Index

MPSysUserTableFields.FieldName
PageID PageID

INT Index

MPSysUserFormPages.PageID
TabOrder TabOrder

INT

ZOrder Zorder

INT

ControlType ControlType

INT

0=Textbox;1=checkbox;2=Combobox;3=SpecialMemo;4=MARISearchBox;5=MARIPerioden;6=Label;7=LabelInfo;8=LookupLabel;9=ComboIndent clsPublicEnums_MARIEditControlTyp
Caption Caption

NVARCHAR (100) Index

CaptionID CaptionID

INT Index

Language ID MPSysStrings.ID
LocationX LocationX

INT

LocationY LocationY

INT

SizeX SizeX

INT

SizeY SizeY

INT

Anchor Anchor

INT

System.Windows.Forms.AnchorStyle Top=1, Button=2 left=4, right=8
RefFormFieldID RefFormFieldID

INT Index

RefLinkTyp RefLinkTyp

INT

Enabled Enabled

SMALLINT (0=false,-1=true)

StyleFormat StyleFormat

INT

ClassIDSource ClassIDSource

INT

0=MARI, 1=User defined tableID
ClassID ClassID

INT Index

ClassID
PeriodenComboMode PeriodenComboMode

INT

ConnectionTyp ConnectionType

INT

ComboMode ComboMode

INT

ComboModeFilter ComboModeFilter

NTEXT

ShowInMARIMasterGrid ShowInMARIMasterGrid

SMALLINT Index

Mandatory Mandatory

SMALLINT (0=false,-1=true)

LayerCode LayerCode

INT

CompareMode CompareMode

INT

ParentFormFieldId ParentFormFieldId

INT

MPSysUserFormFields.FormFieldID
ParentFormFieldMode ParentFormFieldMode

INT


Linked by

Table Description
MPSysUserFormFields SDK: User-Defined Tables: Form Fields


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany