MARIProject Database Structure

View Name:MARISysUserFormFields
Based on table:MPSysUserFormFields
Group:Group: SysUserTable
Description:SDK: User-Defined Tables: Form Fields

Field Table(Germ.field)/Type Description Related
FormFieldID FormFieldID

INT Primary

TableID TableID

SMALLINT Index

MARISysUserTable.TableID
FieldName FieldName

NVARCHAR (50) Index

MARISysUserTableFields.FieldName
PageID PageID

INT Index

MARISysUserFormPages.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 MARISysLanguageStrings.CaptionID
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

ConnectionType ConnectionTyp

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

MARISysUserFormFields.ParentFormFieldId
ParentFormFieldMode ParentFormFieldMode

INT


Linked by

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


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany