OracleForm属性内置子程序触发器系统变量简介解析

1、OracleForm属性、内置子程序、触发器、系统变量精解OracleForm属性、内置子程序、触发器、系统变量精解属性11.1通用属性名称(Name子类信息(SubclassInformation备注(Comments标题(Title方向(Direction字体名称(FontName字体大小(FontSize字体粗细(FontWeight字体风格(FontStyle字体间距(FontSpacing前风景(Foreground背风景(Background填补图案(FillPattern字符模式逻辑属性(CharacterModeLogicalAttribute黑底白字(WhiteonBlack

2、视觉属性组(VisualAttributeGroup目前记录视觉属性组(CurrentRecordVisualAttributeGroup?/div宽度(Width高度(Height立体(Bevel显示水平转动条(ShowHorizontalScrollBar显示垂直转动条(ShowVerticalScrollBar可见(VisibleX轴坐标(XPositionY轴坐标(YPosition启用(Enabled标签文本(Label同意查问(QueryAllowed同意插入(InsertAllowed同意更新(UpdateAllowed显示转动条(ShowScrollBar带转动条画布(Scro

3、llBarCanvas转动条标签页(ScrollBarTabPage转动条方向(ScrollBarOrientation转动条的X轴坐标(ScrollBarXPosition转动条的Y轴坐标(ScrollBarYPosition转动条的宽度(ScrollBarWidth转动条的高度(ScrollBarHeight反转方向(ReverseDirection显示的记录数(NumberofRecordsDisplayed提取的最大记录数(MaximumRecordsFetched最大查问时间(MaximumQueryTime最大长度(MaximumLength固定长度(FixedLength大小写限

4、制(CaseRestriction列名(ColumnName自动跳离(AutomaticSkip折行风格(WrapStyle数据种类(DataType记录间的距离(DistanceBetweenRecords图标文件名(IconFilename需要(Required帮助提示(Hint1.2表格模块对象属性控制台窗口(ConsoleWindow菜单源(MenuSource菜单模块(MenuModule初始菜单(InitialMenu菜单风格(MenuStyle推延推行“需要”属性(DeferRequiredEnforcement菜单角色(MenuRole鼠标导航限制(MouseNavigatio

5、nLimit第一导航数据块(FirstNavigationDataBlock考证单元(ValidationUnit交互模式(InteractionMode孤立模式(IsolationMode坐标系统(CoordinateSystem字符单元宽度(CharacterCellWidth字符单元高度(CharacterCellHeight实体单位(RealUnit使用3D控件(Use3DControls表格水平工具条画布(FormHorizontalToolbarCanvas表格垂直工具条画布(FormVerticalToolbarCanvas保留点模式(SavepointMode1.3触发器对象属

6、性触发器风格(TriggerStyle触发器文本(TriggerText在输入-查问模式中触发(FireinEnter-QueryMode履行层次(ExecutionHierarchy在“键盘帮助”中显示(DisplayinKeyboardHelp?“键盘帮助”文本(KeyboardHelp?Text触发器种类(TriggerType1.4警示对象属性信息(Message警示风格(AlertStyle按钮1标签(Button1Label按钮2标签(Button2Label按钮3标签(Button3Label缺省警示按钮(DefaultAlertButton1.5数据块对象属性导航器风格(Nav

7、igationStyle前一个导航数据块(PreviousNavigationDataBlock下一个导航数据块(NextNavigationDataBlock查问数组大小(QueryArraySize缓冲的记录数(NumberofRecordsBuffered查问全部记录(QueryAllRecords记录方向(RecordOrientation单记录(SingleRecord数据库数据块(DatabaseBlock使用主键(EnforcePrimaryKey查问数据源种类(QueryDataSourceType查问数据源名称(QueryDataSourceName查问数据源列(QueryD

8、ataSourceColumns查问数据源参数(QueryDataSourceArgumentsWHERE子句(WHEREClauseORDERBY子句(ORDERBYClause优化提示(OptimizerHint锁定模式(LockingMode同意删除(DeleteAllowed键模式(KeyMode仅更新改正的列(UpdateChangedColumnsOnly推队列安全控制(EnforceColumnSecurityDML数据目标种类(DMLDataTargetTypeDML数据目标名称(DMLDataTargetName插入过程名称(InsertProcedureName插入过程结果

9、集列(InsertProcedureResultSetColumns插入过程参数(InsertProcedureArguments更新过程名(UpdateProcedureName更新过程结果集列(UpdateProcedureResultSetColumns更新过程参数(UpdateProcedureArguments删除过程名(DeleteProcedureName删除过程结果集列(DeleteProcedureResultSetColumns删除过程参数(DeleteProcedureArguments锁定过程名(LockProcedureName锁定过程结果集列(LockProcedu

10、reResultSetColumns锁定过程参数(LockProcedureArgumentsDML数组大小(DMLArraySize估计算汇总(PrecomputeSummaries在数据块菜单中列出(ListedInBlockAtribute数据块描绘(DataBlockDescription1.6项对象属性项种类(ItemType对齐(Justification多行(Multi-Line隐蔽数据(ConcealData保持光标地点(KeepCursorPosition弹出式菜单(PopupMenu文件名(Filename履行模式(ExecutionMode通信模式(Communicati

11、onMode数据源数据块(DataSourceDataBlock数据源X轴(DataSourceXAxis数据源Y轴(DataSourceYAxis提交时更新(UpdateonCommit复选时的值(ValuewhenChecked未复选时的值(ValuewhenUnchecked其余值的复选框映照(CheckBoxMappingofOtherValues图象格式(ImageFormat图象深度(ImageDepth压缩质量(CompressionQuality显示质量(DisplayQuality显示面板(ShowPalette大小风格(SizingStyle列表中的元素(Elementsi

12、nList列表风格(ListStyle接见键(AccessKey图标化(Iconic缺省按钮(DefaultButton声音格式(SoundFormat音频通道(AudioChannels压缩(Compress声音质量(SoundQuality可用键盘导航(KeyboardNavigable前一个导航项(PreviousNavigationItem下一个导航项(NextNavigationItem鼠标导航(MouseNavigate初始值(InitialValue格式掩码(FormatMask最高同意值(HighestAllowedValue最低同意值(LowestAllowedValue从项

13、中复制值(CopyValuefromItem用项同步化(Synchronizewithitem计算模式(CalculationMode公式(Formula汇总函数(SummaryFunction汇总块(SummarizedBlock汇总项(SummarizedItem显示的项数(NumberofItemDisplayed主键(PrimaryKey仅查问(QueryOnly查问长度(QueryLength不划分大小写的查问(CaseInsensitiveQuery仅为NULL则更新(UpdateOnlyifNULL锁定记录(LockRecord值列表(ListofValues列表X轴地点(Lis

14、tXPosition列表Y轴地点(ListYPosition编写器(Editor编写器的X轴地点(EditorXPosition编写器的Y轴地点(EditorYPosition画布(Canvas标签页(TabPage开释(Rendered显示播放按钮(ShowPlayButton显示录制按钮(ShowRecordButton显示倒回按钮(ShowRewindButton显示快进按钮(ShowFastForwardButton显示音量控制(ShowVolumeControl显示时间显示器(ShowTimeIndicator显示滑杆(ShowSlider提示(Prompt提示显示风格(Prompt

15、DisplayStyle提示文本对齐(PromptJustification提示附件边沿(PromptAttachmentEdge提示对象对齐(PromptAlignment提示附件偏移(PromptAttachmentOffset提示对象对齐偏移(PromptAlignmentOffset提示阅读次序(PromptReadingOrder提示视觉属性组(PromptVisualAttributeGroup提示字体名(PromptFontName提示字体大小(PromptFontSize提示字体粗细(PromptFontWeight提示字体风格(PromptFontStyle提示字体间距(Pr

16、omptFontSpacing提示前风景(PromptForegroundColor提示背风景(PromptBackgroundColor提示填补图案(PromptFillPattern提示(Hint自动显示提示(DisplayHintAutomatically工具提示(Tooltip工具提示视觉属性组(TooltipVisualAttributeGroup初始键盘状态(InitialKeyboardState读取次序(ReadingOrder键盘状态(KeyboardState1.7关系对象属性从数据块(DetailDataBlock关系条件(JoinCondition删除记录行为(Dele

17、teRecordBehavior防备无主记录操作(PreventMasterlessOperations协调(Coordination协调状态(CoordinationStates1.8画布对象属性画布种类(CanvasType输入时置前(RaiseOnEntry弹出式菜单(PopupMenu窗口(Window画布上的视图端口X轴地点(ViewportXPositionCanvas画布上的视图端口Y轴地点(ViewportYPositionCanvas视图端口的X轴地点(ViewportXPosition视图端口的Y轴地点(ViewportYPosition视图端口高度(ViewportHei

18、ght视图端口宽度(ViewportWidth标签风格(TabStyle标签附件边沿(TabAttachmentEdge1.9框架对象属性布局数据块(LayoutDataBlock更新布局(UpdateLayout布局风格(LayoutStyle框架对齐(FrameAlignment单对象对齐(SingleObjectAlignment水平边距(HorizontalMargin垂直边距(VerticalMargin水平对象偏移(HorizontalObjectOffset垂直对象偏移(VerticalObjectOffset同意扩展(AllowExpansion缩短包含(Shrinkwrap垂

19、直填补(VerticalFill每行最多对象数(MaximumObjectsPerLine开端提示对齐(StartPromptAlignment开端提示偏移(StartPromptOffset顶部提示对齐(TopPromptAlignment顶部提示偏移(TopPromptOffset允很多行提示(AllowMulti-Line同意顶部-附带提示(AllowTop-Attached同意开端-附带提示(AllowStart-Attached框架标题(FrameTitle框架标题对齐(FrameTitleAlignment框架标题偏移(FrameTitleOffset框架标题间隔(FrameTit

20、leSpacing框架标题阅读次序(FrameTitleReadingOrder转动条对齐(ScrollBarAlignment框架标题视觉属性组(FrameTitleVisualAttributeGroup1.10标签页对象属性1.11编写器对象属性底部标题(BottomTitle1.12值表(Lovs对象属性列表种类(ListType记录组(RecordGroup列映照属性(ColumnMappingProperties显示以前过滤(FilterBeforeDisplay自动显示(AutomaticDisplay自动刷新(AutomaticRefresh自动选择(AutomaticSele

21、ct自动地点(AutomaticPosition自动列宽(AutomaticColumnWidth自动跳离(AutomaticSkip1.13表格对象组对象属性1.14表格参数对象属性参数数据种类(ParameterDataType参数初始值(ParameterInitialValue1.15表格属性类对象属性1.16记录组对象属性记录组种类(RecordGroupType记录组查问(RecordGroupQuery列规格(ColumnSpecifications1.17表格视觉对象属性1.18窗口对象属性主画布(PrimaryCanvas水平工具条画布(HorizontalToolbarCa

22、nvas垂直工具条画布(VerticalToolbarCanvas窗口风格(WindowStyle模式(Modal退出时隐蔽(HideonExit同意封闭(CloseAllowed同意挪动(MoveAllowed同意从头调整大小(ResizeAllowed同意最大化(MaximizeAllowed同意最小化(MinimizeAllowed最小化标题(MinimizedTitle继承菜单(InheritMenu1.19菜单模块对象属性主菜单(MainMenu菜单目录(MenuDirectory菜单文件名(MenuFilename启动代码(StartupCode使用安全性(UseSecurity模

23、块角色(ModuleRoles1.20菜单对象属性子标题(Subtitle底部标题(BottomTitle分别式菜单(Tear-OffMenu1.21菜单项对象属性菜单项种类(MenuItemType魔术项(MagicItem菜单项单项选择组(MenuItemRadioGroup命令种类(CommandType命令文本(CommandText键盘加快键(KeyboardAccelerator在菜单中可见(VisibleinMenu在水平菜单工具条中可见(VisibleinHorizontalMenuToolbar在垂直菜单工具条中可见(VisibleinVerticalMenuToolbar菜

24、单中的图标(IconinMenu菜单项代码(MenuItemCode项角色(ItemRoles无权限显示(DisplaywithoutPrivilege帮助描绘(Help1.22菜单对象组对象属性1.23菜单参数对象属性隐蔽数据(Secure关系菜单(AssociatedMenus菜单参数初始值(MenuParameterInitialValue1.24菜单视觉属性对象属性第二章内置子程序2.1公共内置子程序GENERATE_SEQUENCE_NUMBERID_NULLRUN_PRODUCTVALIDATE2.2应用内置子程序DO_KEYGET_APPLICATION_PROPERTYHOST

25、PAUSESET_APPLICATION_PROPERTYUSER_EXIT2.3表格内置子程序BELLBREAKCALL_FORMCALL_INPUTCLEAR_FORMCLOSE_FORMCOMMIT_FORMDEBUG_MODEENTERERASEEXECUTE_TRIGGEREXIT_FORMFIND_FORMFORM_FAILUREFORM_FATALFORM_SUCCESSGET_FORM_PROPERTYGO_FORMHELPNEW_FORMNEXT_FORMOPEN_FORMPOSTPREVIOUS_FORMREDISPLAYREPLACE_MENUSET_FORM_PROPE

26、RTYSHOW_KEYSSHOW_MENUSYNCHRONIZE2.4块内置子程序BLOCK_MENUCLEAR_BLOCKFIND_BLOCKGET_BLOCK_PROPERTYGO_BLOCKNEXT_BLOCKPREVIOUS_BLOCKSET_BLOCK_PROPERTY2.5记录内置子程序CHECK_RECORD_UNIQUENESSCLEAR_RECORDCREATE_QUERIED_RECORDCREATE_RECORDDELETE_RECORDDOWNDUPLICATE_RECORDFIRST_RECORDGET_RECORD_PROPERTYGO_RECORDINSERT_R

27、ECORDLAST_RECORDLOCK_RECORDNEXT_RECORDNEXT_SETPREVIOUS_RECORDSCROLL_DOWNSCROLL_UPSELECT_RECORDSSET_RECORD_PROPERTYUPUPDATE_RECORD2.6项内置子程序CHECKBOX_CHECKEDCLEAR_EOLCLEAR_ITEMCONVERT_OTHER_VALUECOPYCOPY_REGIONCUT_REGIONDEFAULT_VALUEDISPLAY_ITEMDUMMY_REFERENCEDUPLICATE_ITEMEDIT_TEXTITEMFIND_ITEMGET_FIL

28、E_NAMEGET_ITEM_INSTANCE_PROPERTYGET_ITEM_PROPERTYGET_RADIO_BUTTON_PROPERTYGO_ITEMIMAGE_ZOOMNAME_INNEXT_ITEMNEXT_KEYPASTE_REGIONPLAY_SOUNDPREVIOUS_ITEMREAD_IMAGE_FILEREAD_SOUND_FILERECALCULATESELECT_ALLSET_ITEM_INSTANCE_PROPERTYSET_ITEM_PROPERTYSET_RADIO_BUTTON_PROPERTYWRITE_IMAGE_FILEWRITE_SOUND_FIL

29、E2.7窗口内置子程序FIND_WINDOWGET_WINDOW_PROPERTYHIDE_WINDOWMOVE_WINDOWREPLACE_CONTENT_VIEWRESIZE_WINDOWSET_WINDOW_PROPERTYSHOW_WINDOW2.8画布内置子程序FIND_CANVASFIND_VIEWGET_CANVAS_PROPERTYGET_VIEW_PROPERTYHIDE_VIEWPRINTSCROLL_VIEWSET_CANVAS_PROPERTYSET_VIEW_PROPERTYSHOW_VIEW2.9标签页内置子程序FIND_TAB_PAGEGET_TAB_PAGE_P

30、ROPERTYSET_TAB_PAGE_PROPERTY2.10事务办理内置子程序ENFORCE_COLUMN_SECURITYFETCH_RECORDSFORMS_DDLISSUE_ROLLBACKISSUE_SAVEPOINTLOGONLOGON_SCREENLOGOUT2.11查问内置子程序ABORT_QUERYCOUNT_QUERYENTER_QUERYEXECUTE_QUERY2.12关系内置子程序FIND_RELATIONGET_RELATION_PROPERTYSET_RELATION_PROPERTY2.13记录组内置子程序ADD_GROUP_COLUMNADD_GROUP_R

31、OWCREATE_GROUPCREATE_GROUP_FROM_QUERYDELETE_GROUPDELETE_GROUP_ROWFIND_COLUMNFIND_GROUPGET_GROUP_CHAR_CELLGET_GROUP_DATE_CELLGET_GROUP_NUMBER_CELLGET_GROUP_ROW_COUNTGET_GROUP_SELECTIONGET_GROUP_SELECTION_COUNTPOPULATE_GROUPPOPULATE_GROUP_WITH_QUERYRESET_GROUP_SELECTIONSET_GROUP_CHAR_CELLSET_GROUP_DAT

32、E_CELLSET_GROUP_NUMBER_CELLSET_GROUP_SELECTIONUNSET_GROUP_SELECTION2.14列表项内置子程序ADD_LIST_ELEMENTCLEAR_LISTDELETE_LIST_ELEMENTGET_LIST_ELEMENT_COUNTGET_LIST_ELEMENT_LABELGET_LIST_ELEMENT_VALUEPOPULATE_LISTRETRIEVE_LIST2.15参数列表内置子程序ADD_PARAMETERCREATE_PARAMETER_LISTDELETE_PARAMETERDESTROY_PARAMETER_LIS

33、TGET_PARAMETER_ATTRGET_PARAMETER_LISTSET_PARAMETER_ATTR2.16菜单内置子程序APPLICATION_PARAMETERBACKGROUND_MENUFIND_MENU_ITEMGET_MENU_ITEM_PROPERTYHIDE_MENUITEM_ENABLEDMENU_CLEAR_FIELDMENU_NEXT_FIELDMENU_PARAMETERMENU_PREVIOUS_FIELDMENU_REDISPLAYMENU_SHOW_KEYSNEXT_MENU_ITEMPREVIOUS_MENUPREVIOUS_MENU_ITEMQUER

34、Y_PARAMETERSET_INPUT_FOCUSSET_MENU_ITEM_PROPERTYSHOW_BACKGROUND_MENUSHOW_MENUTERMINATEWHERE_DISPLAY2.17警示内置子程序FIND_ALERTSET_ALERT_BUTTON_PROPERTYSET_ALERT_PROPERTYSHOW_ALERT2.18信息内置子程序CLEAR_MESSAGEDBMS_ERROR_CODEDBMS_ERROR_TEXTDISPLAY_ERRORERROR_CODE.ERROR_TEXTERROR_TYPEGET_MESSAGEMESSAGE.MESSAGE_CODEMESSAGE_TEXTMESSAGE_TYPE第三章触发器3.1键触发器Key-FnKey-Others3.2On触发器On-Check-Delete-MasterOn-Check-UniqueOn-Clear-DetailsOn-CloseOn-Column-SecurityOn-CommitOn-CountOn-DeleteOn-ErrorOn-FetchOn-InsertO