• FORM内置系统函数


    abort_query;                                                    停止查询的执行

    add_group_column(record group id name,groupcolumn             添加一个列到一个记录组,Recordgroup id

    name,column type,column width);

    add_group_row(record group id name,rownumber);                添加一个行到一个记录组,recordgroup idoracle

                                                                  予这个组的唯一的名称,row number指定了这个行在组中

                                                                  位置.

    add_list_element(list name or list id,

    list index,list lable,list value);                                                  添加一项到下拉列表框,list namelist的名字,listindex

                                                                  是添加到列表框的索引,list label指定了放入列表中的数值

                                                                   ,list value包含了列表标识所对应的数据库的数值.

    add_parameter(listname,parameter,parametertype,value)           添加一个参数到一个参数列表,参数列表是一个变量列表,这些

                                                                  变量将被伟给其他对象,listname指定了这个列表的标识,

                                                                  parametertype(参数类型)包含两种可用数值:

                                                                  text_type是一串字符;data_parameter是一个指定已在form

                                                                  中定义的记录组的串.value是传给被调模块的实际数值.

    application_parameter                                           促使oracle显示Enterparameter values对话框。关联了

                                                                  当前菜单form的参数按其数值被显示。

     

    background_menu (1...10);                                        从背景菜单中显示一个菜单项

    bell;                                                          促使终址产生一个鸣叫(要有音响或耳机才能听以哦!)

    block_menu;                                                   显示一个数值的列表,它包括有效块的名字和它们的序

                                                                   列号

    break;                                                        停止form的执行,显示调试器.:只能在调试模式时

    call_input;                                                     接受并执行功能键输入;

    checkbox_checked(name);                                        返回一个真或假的值表示检查框的状态

    check_record_uniqueness                                        on_check_unique触发器调用时,为检查主关键字的唯

                                                                 一性而被始化form过程.

    clear_block                                                    人当前的块中清除记录.

    clear_eol;                                                    从光标开始到些行结束清除文本项的值。

    clear_form                                                    清除form的所有记录。commit mode参数具有的参数为

    (commit mode,rollback mode)                                     ask_commit提示操作者提交记录;do_commit扫行提交;

                                                                 no_commit清除form并不提交记录.no_validate提交

                                                                 未经有效检验的数据.

    clear_item(name);                                              清除指定的项.

    clear_list(name);                                              清除下拉列表的值

    clear_message;                                               清除信息提示区域中所有的信息

    clear_record;                                                  清除当前记录中的所有值.

    close_form(name)                                              关闭当前form,其它的form通过指定的name关闭.

    commit_form;                                                  使form中的值改修数库库的的表.

    convert_other_value(name)                                      改变下接列表框,圆形按钮组,检查框的值为符合当前项

                                                                状态的值.

    copy(variable 1,variable 2);                                          拷贝值从变量1到变量2;

    count_query;                                                 使用oncount触发器标明查询所获取的记录数.

    create_group(record group name);                                创建静态或无查询记录组,创建后可用子程序:

                                                               populate_group_with_query,

                                                               add_group_column,add_group_row来向组添加记录

    create _group_from_queryny(                                   按指定select语句创建记录组.

    record group name,select statement);

     

    create_parameter_list(list name);                                   创建参数列表,可用子程序:add_parameter来添加

                                                               参数。paraneter list(参数列表)经常被作为依

                                                               据传给run_product,call_form,new_form子程序.

    create_queried_record;                                         当使用on_fetch触发器时,在块主录缓存中创建记录.

                                                               缓存存放着那些未被显示的记录

    create_record;                                               在当前块中创建一条记录.

    create_time(timename,milliseconds,iterale);                           创建一个计时器。milliseconds()块定每个循环的

                                                               分配时间。参娄iterate有两个选项:repeat:默认,告诉

                                                               计时器在完成一次计时后重复;on_repeat,完成一次计时后

                                                                不重复.

    cut_region                                                  剪切选中的文本并保存于剪切板中.

    dbms_err_code                                              获并显示最后的数据库错误代码

    dbms_error_text                                             显示数据库错误类型信息和文字信息

    debug_mode                                                开启或关闭调试模式,这种模式只用于菜单模块.

    default_value(literal, variable);                                         如果当前值为null,则放置文字串literalvariable.

    delete_group(name)                                          删除记录组.

    delete_group_row(name,row,number);                            从记录组中删除标出的行。

    delete_list_element(name,list index);                                  删除下接列表中的一项.索引为list index

    delete_parameter(name,parameter);                             从参数列表中删除指定参数。

    delete_record                                                  删除当前记录;

    delete_time(name)                                              删除记时器

    destroy_paramter_list(name);                                   删除一个预定的被调参数列表,name即为列表名称

    do_key(内置子程序名)                                                  模拟按下以子程序命名的功能键;

    duplicate_item                                                 从上一记录中拷贝相同项的值到当前记录的项中.

    duplicate_record                                               从上一记录中拷贝每每个项到当前记录的对应项中

    edit_textitem(x,y[,高度,宽度])                                     为当前文本项显示一个编辑器(很有意思的咧!)

    enforce_column_security                                        促使应用检查列的安全性.

    enter                                                          对当前项检查期有效性

    enter_query                                                     form的模式为enterquery

    erase(全局变量名);                                             从内存中消去指定的全局变量;

    error_code;                                                    捕获并且显示oracle forms的错误序号

    error_text;                                                     显示解释form错误的文字信息

    error_type;                                                    显示错误的类型.frm说明forms错误,ora说明是数据库错误

    execute_query                                                  使oracle提取记录到form,并置form于更新模式

    execute_trigger(触发器名)                                        执行指定的触发器

    fetch_records;                                                 启动将记录提取到form

    find_block(块名);                                                查找块的ID.

    find_canvas(画板名);                                              查找画板名的ID.

    find_column(记录组,组列名);                                    查找组列的ID.

    find_editor(编辑器名);                                           查找编辑器的ID.

    find_form(form);                                              查找formID.

    find_group(记录组名);                                           查找记录组的ID.

    find_item(项名)                                                  查找项名的ID.

    find_menu_item(菜单项名);                                        查找菜单项的ID.

    find_relation(关系名);                                             查找关系的ID.

    find_time(time);                                              查找timeID.

    find_view(canvas-view);                                         查找画布的ID.

    find_window(窗口名);                                             查找窗口的ID.

    first_record;                                                  显示第一条记录

    form_failire                                                   返回表示最后一个form执行结果的布尔值

    form_fatal                                                     返回表示最后一个执行结果的布尔表达式。成功或失败返回false

                                                                 致命的错误才返回true

    form_success;                                                  返回表示最后执行结果的布称表达式。成功返回true,失败或致命

                                                                   错误返回false

    forms_ddl(statement);                                          操作form过程中执行sql命令,命令语句可以是文字,dml,ddl或代

                                                                   pl/sql代码块的表达式.

    forms_ole.activate_server(id);                                    启动一个ole服务器使其准备接受ole自动事件

    forms_ole.close_server(id);                                    关闭一个ole服务器使期切断与各个ole容器的连接

    forms_ole.exec_verb(id,verb name);                             告诉ole服务器执行邮verb idname标明的执行命令;

    forms_ole.find_ole_verb(id,verb name)                          返回ole verb的索引值

    forms_ole.get_interface_pointer(name);                         标识一个ole2自动执行对象的句柄;

    forms_ole.get_verb_count(id);                                  标识出ole服务器所能识别的命令数量

    forms_ole.initialize_container(id,filename);                               当服务器兼容时,添加一个ole对象到ole容器中

    generate_sequence_number                                       当序列被定义为项属性的默认值时启动产生这个序号

    get_application_property(propertyname);                       为当前form的属性定义数值

    get_block_property(name,property)                              返回块属性值

    get_canvas_property(name,property);                            返回画布属性值

    get_group_char_cell(group column id,rownumber);               指定一个字符或者记录组单元的字串。单元是一个行/列交叉点。

    get_form_property(name,property);                              返回指定的forms的属性值

    get_group_date_cell(group column id,rownumber);               指定一个记录组单元的日期值,单元是一个行/列交叉点

    get_group_number_cell(group column id,rownumber);             指定一个记录组单元的数字值,单元是一个行/列交叉点

    get_group_row_count(group name);                               标识指定记录组中的行号

    get_group_selection(name,selectionnumber);                    标识指定记录组中行的数字位置

    get_group_selection_count(name);                              指定自动标定为选中行的总数

    get_item_property(name,property);                              返回项属性值

    get_list_element_count(list name);                                  指定下接列表框内的值的总个数

    get_list_element_label(listname,list_index);                               标识选中的下拉列表框内项的标识名称

    get_list_element_value(listname,list_index);                              标识选中的下拉列表框内项的实际值

    get_lov_property(name,property);                              标识不同的数值属性设定列表

    get_menu_item_property(menuname,property);                   标识选中的菜单项的状态。选项为:checked,enabledlabeld

    get_message;                                                 显示当前的信息

    get_parameter_list(list name);                                     为指定的列表定义参数列表ID

    get_parameter_attr(listname,参数名,参数类型,数值);               标识被选参数列表中参数的类型的数值。参数类型为:

                                                                  data_parameter:表示此值是组的我称;

                                                                  text_parameter:表明参数值是一个实际数据值

    get_radio_button_property(item name,buttonname,property);             标识选中的圆形按钮属性.

    get_record_property(record number,blockname,property);                 标识指定记录的状态。被支持的属性为:status.不同的状态值

                                                               是:new,changed,query,insert

    get_view_property(view name,property);                            标识指定视图属性的值。属性为:display_x_pos,display_y_pos,height,

                                                                visible,width,window_name,x_pos_on_canvas,y_pos_on_canvas

    get_window_property(windowname,property);                    标识指定窗口属性的值,属性为:height,remove_on_exit,title,visible,

                                                                width,window_handle,window_size,window_state,x_pos;

    go_block(name);                                               定位到指定的块

    go_item(name);                                                定位到指定的项

    go_form(name);                                                 定位到指定的form

    go_record(记录号);                                             定位到指定的记录

    help;                                                         显示当前项的提示信息

    hide_menu                                                    在字符模式平台上操作时,使当前菜单消失

    hide_view(name)                                               使指定的视图消失

    hide_window(name);                                            使指定的窗口消失

    host(系统命令,屏幕操作);                                      执行指定的操作系统命令

    id_null(对象id);                                                 若指定的对象是有效的则返回真,事则返回假

    image_zoom(image_id,zoom类型,zoomfactor);                       改变由zoomin/out产生的可视图像大小,它的类型有:adjust_tofit,

                                                                  selection_rectangle,zoom_in_factor,zoom_percent,zoom的系数

                                                                  是百分比.

    insert_record                                                 将当前记录添回到数据库中

    issue_rollbaco(savepoint);                                   执行rollback命令,savepointname是指数据被提交的最后时间

    issue_savepoint(savepoint);                                  执行一个保存动作

    item_enabled(菜单名,项名);                                    当菜单项有效时返回一个真值,不则值为假

    last_record;                                                  显示记录缓存中最后记录

    list_value(参数值)                                               显示当前项值的列表。参数值是:on_restrict,它告诉form不要

                                                                  使用自动查找和完整模式;与其相反的是restrict.

    lock_record;                                                   锁定数据库中的相应行.

    logon(用户名,口令显示登录屏幕错误信息)                          使form连接到oracle数据库上。在登录屏幕参数设定上设定true

                                                                  会使oracle在子程序连接数据库失败时显示登录屏幕.

    logon_screen;                                                 显示数据库登录民幕

    logout;                                                       退出数据库登录;

    main_menu;                                                    显示应用主菜单

    menu_clear_field;                                              删除当前项到光标右边的字符

    menu_next_field;                                              移动光标到输入参数值对话框中下一项上.

    menu_parameter;                                               显示输入参数值对话框中所有当前菜单参数的值

    menu_previous_field;                                           移动光标到输入参数值对话框中前一项上.

    menu_redisplay;                                               在菜单刷新屏幕

    menu_show_keys;                                               显示功能键对话框

    message(信息字符,返回响应);                                    在信息栏上放置指定信息,它有两个参数:acknowledge

                                                                  显示一个提醒操作者不可忽视的模块;no_acknowledge

                                                                  告诉oracle两个信息被送出后不需要返回响应;

    message_code;                                                  指定当前生成信息的个数

    message_text;                                                 指定当前生成信息的文字

    message_type;                                                 指定当前生成信息的类型

    move_window(window name,x,y);                                 移动窗口

    name_in(variable);                                            为指定变量定义数值

    next_block;                                                   移动到下一个块

    next_form;                                                    移动到下一个form

    next_item;                                                     移动到下一个项

    next_key;                                                     移动到下一个关键字项,这个关键字必须是光标可移向的

                                                                  ,有效的

    next_menu_item;                                               移动到下一个菜单项

    next_record;                                                  移动到下一条记录

    next_set;                                                     从数据库获取下一记录集并将光标指向第一个记录

    paste_region;                                                粘贴剪切板内容到光标处

    pause;                                                        停止form进程直到用户按下一个功能键

    populate_group(组名);                                          执行记录组查询,返回一个数字表明成功(0),(0)表失败

    populate_group_with_query(记录组id或名称查询)                用查询结果重置记录组的一个记录行

    populate_list(list name,record groupid);                                   用指定记录组的数值来重置下拉列表

    post;                                                       form传送数据到数据库,无须提交

    previous_block;                                              移动光标到前一个块

    previous_form;                                                移动光标到前一个form

    previous_item;                                               移动光标到前一个项

    previous_menu;                                               移动光标到前一个菜单

    previous_menu_item;                                           移动光标到前一个菜单项

    previous_record;                                             移动光标到前一条记录

    print;                                                       执行当前窗口的屏幕打印

    query_parameter(parameter literal);                           显示包含指定参数值的queryparameter对话框

    read_image_file(文件名,文件类型,项名);                       显示forms图像项所对应的文件

    redisplay;                                                 清除现存屏幕并重新启动屏幕

    replace_content_view(window name,viewname);                  在当前窗口中改变画板_视图的内容

    replace_menu(菜单文件名,菜单类型,初始化菜单名,          用新菜单代替当前菜单

    组名,use_file);

    rest_group_selection(record group idrecord groupname);              取消组中行记录的当前选定

    resize_window(window id,,);                                改窗口大小到指定的设置

    retrieve_list(list name,record groupname);                               保存当前列表到指定的记录组中

    run_product(oracle产品,文件,通讯style,execution style,location,    启动指定的oracle软件产品并执行文件communications

    list ,display);                                                设定为:synchronous告诉oracle在新软件关闭后返回form控制

                                                              asynchronous告诉oracle立即返回forms控制,执行设定是:batch,

                                                              runtime.定位设定决定了产品要执行的文件的位置;listname

                                                              变量决定了要传给产品的参数列表。display变量指定了由

                                                              graphics生成的forms图表的名称.

    scroll_down;                                                  从记录缓存中显示下一个记录集

    scroll_up;                                                     从主录缓存中显示前一个记录集

    scroll_view(view name,x,y);                                       修改x,y画板坐标属性设定来重设视图的位置

    select_all;                                                   全选当前项中的文本

    set_alert_property(alertname,alert_message_text,message);                       修改显示于报警提示中的文字信息。报警信息属性是

                                                               alert_message_text(第二个参数);

    set_application_property(property,setting);                              改变当前应用的属性。属性为:cursor_style.其值为:

                                                                busy,crosshair,default,help,insertion

    set_block_property(blockname,property,value);                          改变块属性

    set_canvas_property(canvasname,property,value[x,y]);                改变画板属性

    set_form_property(formname,property,value);                          改变form属性

    set_group_char_cell(组列名或id,行号,数值);                            改变一个字符组单元的值

    set_group_data_cell(组列名或id,行号,数值);                            改变一个数据组单元的值

    set_group_number_cell(组列名或id,行号,数值);                          改变一个数字组单元的值

    set_group_selection(记录组名或id,行号);                              选中或定位到指定的记录组的一行

    set_input_focus(菜单);                                       改变输入点到当前的form菜单上

    set_item_property(项名,属性,值或[x,y]);                         改变项属性

    set_lov_property(名称,属性,值或[x,y]);                          改变值列表属性

    set_menu_item_property(菜单项id,属性,);                           改变菜单项属性

    set_parameter_attr(列表或名称,参数,参数类型,);                     改变参数列表中指定的参数的类型和数值.

    set_record_property(记录号,块名,属性,数值);                          改变指定记录的状态属性,属性值为:changed_status,i

                                                                    insert_status,new_status,query_status

    set_relation_property(relation id工名称,属性,数值);                    改变指定关系的属性

    set_view_property(view name,property ,vlalue[x,y]);                               修改view的属性

    set_timer(计时器id,毫秒,反覆);                                    修改计时器的设定.

    set_window_property(name,property,value[x,y]);                              修改窗口的属性

    show_alert(name);                                               启动指定的警报器并返回对应所选按钮的数值

    show_ackground_menu;                                            展示背景菜单

    show_editor(编辑器名字,textin[x,y]optional,tex tount,result);                  在指定位置启动编辑器,将一串文字伟入/出编辑器

    show_keys;                                                      展现form功能键对话框

    show_lov(name,[x,y]);                                           显示指定的数值列表,这个内置子程序返回一个布尔

                                                                  ,它将被作为等式的一部分(比如:a=show_lov(lov_name)

    show_menu;                                                       激活并显示当前菜单

    show_view(name);                                                显示指定的画板或视图

    show_window(name,[x,y]);                                        x,y坐标上显示指定的窗口

    synchronize;                                                    仅在如下两个条件满足时允许oracle修改显示:已经

                                                                  完成对新画板或视图的定位并form是处于项的级别之上

    terminate;                                                      停止向form或对话框输入数据.

    unset_group_selection(记录组名,行号)                              取消由set_group_selection所作的行的选定

    up;                                                           从记录缓存中显示前一个记录

    update_record;                                                  使form通过form的修改进行数据库更改

    user_exit(表达式,错误文字);                                        启用包含在表达式参数中的用户退出程序

    validate(参数);                                                   使form执行基于参数范围的有效的过程.参数为:

                                                                   default_scope,form_scope,record_scope,item_scope

    vbx.fire_event(itemname,事件,参数表list id或名称)                       vbx控件进行事件的启动

    vbx.get_property(item name或名称,属性);                              标识vbx控件属性的值

    vbx.get_value_property(name,属性);                                标识vbx控件的vbx控制属性值

    vbx.invoke_method(name,方法名,w,x,y,z);                            执行包含在项的方法名中的中间项

    vbx.set_value_property(name,属性);                                更改指定的vbx控件数值属性

    where_display;                                                  更改where菜单光标移动选项的数值,值为on,off

    write_image_file(图像文件,文件类型,名称)                          oracle forms的图像项存放图像到文件中

  • 相关阅读:
    [转]html5 Canvas画图教程(6)—canvas里画曲线之arcTo方法
    [转]html5 Canvas画图教程(5)—canvas里画曲线之arc方法
    [转]html5 Canvas画图4:填充和渐变
    [转]html5 Canvas画图教程(3)—canvas出现1像素线条模糊不清的原因
    [转]html5 Canvas画图教程(2)—画直线与设置线条的样式如颜色/端点/交汇点
    【Java进阶】Maven 简介
    【Java入地】Spring 的 作用域 & MVC & SSM
    【Linux】Kali 物理机安装笔记、简单过程及注意事项
    【电脑维修】 显卡错误(错误代码:43)
    【Linux】 编程环境搭建 JDK、Node.js、Npm、Yarn、Redis、Maven的安装与搭建
  • 原文地址:https://www.cnblogs.com/wanghang/p/6299514.html
Copyright © 2020-2023  润新知