| 订阅 | 在线投稿
分享
 
 
 

Oracle Developer 2000中的一些实用语句

2008-08-19 06:50:56  编辑来源:互联网  宽屏版  评论

本文为【Oracle Developer 2000中的一些实用语句】的汉字拼音对照版显示拼音

Oracle Developer 2000zhongdeyixieshiyongyuju

abort_query; tingzhichaxundezhixing

add_group_column(record group id huo name,group column tianjiayigeliedaoyigejiluzuRecord group id

name,column type,column width);

add_group_row(record group id huo name,row number); tianjiayigexingdaoyigejiluzurecord group idshioraclefu

yuzhegezudeweiyidemingchengrow numberzhidinglezhegexingzaizuzhong

weizhi.

add_list_element(list name or list id,

list index,list lable,list value); tianjiayixiangdaoxialaliebiaokuang,list nameshilistdemingzi,list index

shitianjiadaoliebiaokuangdesuoyinlist labelzhidinglefangruliebiaozhongdeshuzhi

chuan,list valuebaohanleliebiaobiaoshisuoduiyingdeshujukudeshuzhi.

add_parameter(listhuoname,parameter,parameter type,value) tianjiayigeshenshudaoyigeshenshuliebiao,shenshuliebiaoshiyigebianliangliebiao,zhexie

bianliangjiangbeiweigeiqitaduixianglisthuonamezhidinglezhegeliebiaodebiaoshi,

parameter type(shenshuleixing)baohanliangzhongkeyongshuzhi

text_typeshiyichuanzifu;data_parametershiyigezhidingyizaiform

zhongdingyidejiluzudechuan.valueshichuangeibeitiaomokuaideshijishuzhi.

application_parameter cu使shioraclexianshiEnter parameter valuesduihuakuangguanlianle

dangqiancaidanformdeshenshuanqishuzhibeixianshi

background_menu (1...10); congbeijingcaidanzhongxianshiyigecaidanxiang

bell; cu使shizhongzhichanshengyigemingjiao(yaoyouyinxianghuoerjicainengtingyio)

block_menu; xianshiyigeshuzhideliebiaotabaokuoyouxiaokuaidemingzihetamendexu

liehao

break; tingzhiformdezhixingxianshitiaoshiqi.zhu:zhinengzaitiaoshimoshishi

call_input; jieshoubingzhixinggongnengjianshuru;

checkbox_checked(name); fanhuiyigezhenhuojiadezhibiaoshijianchakuangdezhuangtai

check_record_uniqueness beion_check_uniquechufaqitiaoyongshiweijianchazhuguanjianzidewei

yixingerbeishihuaformguocheng.

clear_block rendangqiandekuaizhongqingchujilu.

clear_eol; congguangbiaokaishidaoxiexingjieshuqingchuwenbenxiangdezhi

clear_form qingchuformdesuoyoujilucommit mode shenshujuyoudeshenshuwei

(commit mode,rollback mode) ask_committishicaozuozhetijiaojilu;do_commitsaoxingtijiao;

no_commitqingchuformbingbutijiaojilu.no_validatetijiao

weijingyouxiaojianyandeshuju.

clear_item(name); qingchuzhidingdexiang.

clear_list(name); qingchuxialaliebiaodezhi

clear_message; qingchuxinxitishiquyuzhongsuoyoudexinxi

clear_record; qingchudangqianjiluzhongdesuoyouzhi.

close_form(name) guanbidangqianformqitadeformtongguozhidingdenameguanbi.

commit_form; 使shiformzhongdezhigaixiushukukudedebiao.

convert_other_value(name) gaibianxiajieliebiaokuangyuanxinganniuzujianchakuangdezhiweifuhedangqianxiang

zhuangtaidezhi.

copy(variable 1,variable 2); kaobeizhicongbianliang1daobianliang2;

count_query; 使shiyongoncountchufaqibiaomingchaxunsuohuoqudejilushu.

create_group(record group name); chuangjianjingtaihuowuchaxunjiluzuchuangjianhoukeyongzichengxu

populate_group_with_query,

add_group_column,add_group_rowlaixiangzutianjiajilu

create _group_from_queryny( anzhidingselectyujuchuangjianjiluzu.

record group name,select statement);

create_parameter_list(list name); chuangjianshenshuliebiaokeyongzichengxu:add_parameterlaitianjia

shenshuparaneter listshenshuliebiaojingchangbeizuoweiyi

juchuangeirun_product,call_form,new_formzichengxu.

create_queried_record; dang使shiyongon_fetchchufaqishizaikuaizhuluhuancunzhongchuangjianjilu.

huancuncunfangzhenaxieweibeixianshidejilu

create_record; zaidangqiankuaizhongchuangjianyitiaojilu.

create_time(time name,milliseconds,iterale); chuangjianyigejishiqimilliseconds(miao)kuaidingmeigexunhuande

fenpeishijianshenlouiterateyoulianggexuanxiang:repeatmorengaosu

jishiqizaiwanchengyicijishihouchongfu;on_repeat,wanchengyicijishihou

buchongfu.

cut_region jianqiexuanzhongdewenbenbingbaocunyujianqiebanzhong.

dbms_err_code huobingxianshizuihoudeshujukucuowudaima

dbms_error_text xianshishujukucuowuleixingxinxihewenzixinxi

debug_mode kaiqihuoguanbitiaoshimoshi,zhezhongmoshizhiyongyucaidanmokuai.

default_value(literal, variable); ruguodangqianzhiweinullzefangzhiwenzichuanliteraldaovariablezhong.

delete_group(name) shanchujiluzu.

delete_group_row(name,row,number); congjiluzuzhongshanchubiaochudexing

delete_list_element(name,list index); shanchuxiajieliebiaozhongdeyixiang.suoyinweilist index

delete_parameter(name,parameter); congshenshuliebiaozhongshanchuzhidingshenshu

delete_record shanchudangqianjilu;

delete_time(name) shanchujishiqi

destroy_paramter_list(name); shanchuyigeyudingdebeitiaoshenshuliebiaonamejiweiliebiaomingcheng

do_key(neizhizichengxuming) monianxiayizichengxumingmingdegongnengjian;

duplicate_item congshangyijiluzhongkaobeixiangtongxiangdezhidaodangqianjiludexiangzhong.

duplicate_record congshangyijiluzhongkaobeimeimeigexiangdaodangqianjiludeduiyingxiangzhong

edit_textitem(x,y[,gaodu,kuandu]) weidangqianwenbenxiangxianshiyigebianjiqi(henyouyisidelei!)

enforce_column_security cu使shiyingyongjianchaliedeanquanxing.

enter duidangqianxiangjianchaqiyouxiaoxing

enter_query gaiformdemoshiweienter query

erase(quanjubianliangming); congneicunzhongxiaoquzhidingdequanjubianliang;

error_code; buhuobingqiexianshioracle formsdecuowuxuhao

error_text; xianshijieshiformcuowudewenzixinxi

error_type; xianshicuowudeleixing.frmshuomingformscuowu,orashuomingshishujukucuowu

execute_query 使shioracletiqujiludaoformzhong,bingzhiformyugengxinmoshi

execute_trigger(chufaqiming) zhixingzhidingdechufaqi

fetch_records; qidongjiangjilutiqudaoformzhong

find_block(kuaiming); chazhaokuaideID.

find_canvas(huabanming); chazhaohuabanmingdeID.

find_column(jiluzuzulieming); chazhaozuliedeID.

find_editor(bianjiqiming); chazhaobianjiqideID.

find_form(formming); chazhaoformdeID.

find_group(jiluzuming); chazhaojiluzudeID.

find_item(xiangming) chazhaoxiangmingdeID.

find_menu_item(caidanxiangming); chazhaocaidanxiangdeID.

find_relation(guanximing); chazhaoguanxideID.

find_time(timeming); chazhaotimedeID.

find_view(canvas-viewming); chazhaohuabudeID.

find_window(chuangkouming); chazhaochuangkoudeID.

first_record; xianshidiyitiaojilu

form_failire fanhuibiaoshizuihouyigeformzhixingjieguodebuerzhi

form_fatal fanhuibiaoshizuihouyigezhixingjieguodebuerbiaodashichenggonghuoshibaifanhuifalse

zhimingdecuowucaifanhuitrue

form_success; fanhuibiaoshizuihouzhixingjieguodebuchengbiaodashichenggongfanhuitrue,shibaihuozhiming

cuowufanhuifalse

forms_ddl(statement); caozuoformguochengzhongzhixingsqlmingling,minglingyujukeyishiwenzidml,ddlhuodai

biaopl/sqldaimakuaidebiaodashi.

forms_ole.activate_server(id); qidongyigeolefuwuqi使shiqizhunbeijieshouolezidongshijian

forms_ole.close_server(id); guanbiyigeolefuwuqi使shiqiqieduanyugegeolerongqidelianjie

forms_ole.exec_verb(id,verb name); gaosuolefuwuqizhixingyouverb id huonamebiaomingdezhixingmingling;

forms_ole.find_ole_verb(id,verb name) fanhuiole verbdesuoyinzhi

forms_ole.get_interface_pointer(name); biaoshiyigeole2zidongzhixingduixiangdejubing;

forms_ole.get_verb_count(id); biaoshichuolefuwuqisuonengshibiedeminglingshuliang

forms_ole.initialize_container(id,file name); dangfuwuqijianrongshitianjiayigeoleduixiangdaoolerongqizhong

generate_sequence_number dangxuliebeidingyiweixiangshuxingdemorenzhishiqidongchanshengzhegexuhao

get_application_property(property name); weidangqianformdeshuxingdingyishuzhi

get_block_property(name,property) fanhuikuaishuxingzhi

get_canvas_property(name,property); fanhuihuabushuxingzhi

get_group_char_cell(group column id,row number); zhidingyigezifuhuozhejiluzudanyuandezichuandanyuanshiyigexing/liejiaochadian

get_form_property(name,property); fanhuizhidingdeformsdeshuxingzhi

get_group_date_cell(group column id,row number); zhidingyigejiluzudanyuanderiqizhidanyuanshiyigexing/liejiaochadian

get_group_number_cell(group column id,row number); zhidingyigejiluzudanyuandeshuzizhidanyuanshiyigexing/liejiaochadian

get_group_row_count(group name); biaoshizhidingjiluzuzhongdexinghao

get_group_selection(name,selection number); biaoshizhidingjiluzuzhongxingdeshuziweizhi

get_group_selection_count(name); zhidingzidongbiaodingweixuanzhongxingdezongshu

get_item_property(name,property); fanhuixiangshuxingzhi

get_list_element_count(list name); zhidingxiajieliebiaokuangneidezhidezonggeshu

get_list_element_label(list name,list_index); biaoshixuanzhongdexialaliebiaokuangneixiangdebiaoshimingcheng

get_list_element_value(list name,list_index); biaoshixuanzhongdexialaliebiaokuangneixiangdeshijizhi

get_lov_property(name,property); biaoshibutongdeshuzhishuxingshedingliebiao

get_menu_item_property(menu name,property); biaoshixuanzhongdecaidanxiangdezhuangtaixuanxiangwei:checked,enabledhelabeld

get_message; xianshidangqiandexinxi

get_parameter_list(list name); weizhidingdeliebiaodingyishenshuliebiaoID

get_parameter_attr(listname,shenshumingshenshuleixingshuzhi); biaoshibeixuanshenshuliebiaozhongshenshudeleixingdeshuzhishenshuleixingwei

data_parameterbiaoshicizhishizudewocheng

text_parameter:biaomingshenshuzhishiyigeshijishujuzhi

get_radio_button_property(item name,button name,property); biaoshixuanzhongdeyuanxinganniushuxing.

get_record_property(record number,block name,property); biaoshizhidingjiludezhuangtaibeizhichideshuxingweistatus.butongdezhuangtaizhi

shinew,changed,query,insert

get_view_property(view name,property); biaoshizhidingshitushuxingdezhishuxingweidisplay_x_pos,display_y_pos,height,

visible,width,window_name,x_pos_on_canvas,y_pos_on_canvas

get_window_property(window name,property); biaoshizhidingchuangkoushuxingdezhi,shuxingwei:height,remove_on_exit,title,visible,

width,window_handle,window_size,window_state,x_pos;

go_block(name); dingweidaozhidingdekuai

go_item(name); dingweidaozhidingdexiang

go_form(name); dingweidaozhidingdeform

go_record(jiluhao); dingweidaozhidingdejilu

help; xianshidangqianxiangdetishixinxi

hide_menu zaizifumoshipingtaishangcaozuoshi使shidangqiancaidanxiaoshi

hide_view(name) 使shizhidingdeshituxiaoshi

hide_window(name); 使shizhidingdechuangkouxiaoshi

host(xitongminglingpingmucaozuo); zhixingzhidingdecaozuoxitongmingling

id_null(duixiangid); ruozhidingdeduixiangshiyouxiaodezefanhuizhenshizefanhuijia

image_zoom(image_id,zoomleixing,zoomfactor); gaibianyouzoomin/outchanshengdekeshituxiangdaxiao,tadeleixingyouadjust_tofit,

selection_rectangle,zoom_in_factor,zoom_percent,zoomdexishu

shibaifenbi.

insert_record jiangdangqianjilutianhuidaoshujukuzhong

issue_rollbaco(savepointming); zhixingrollbackmingling,savepoint nameshizhishujubeitijiaodezuihoushijian

issue_savepoint(savepointming); zhixingyigebaocundongzuo

item_enabled(caidanming,xiangming); dangcaidanxiangyouxiaoshifanhuiyigezhenzhibuzezhiweijia

last_record; xianshijiluhuancunzhongzuihoujilu

list_value(shenshuzhi) xianshidangqianxiangzhideliebiaoshenshuzhishi:on_restrict,tagaosuformbuyao

使shiyongzidongchazhaohewanzhengmoshiyuqixiangfandeshirestrict.

lock_record; suodingshujukuzhongdexiangyingxing.

logon(yonghuming,koulingxianshidenglupingmucuowuxinxi) 使shiformlianjiedaooracleshujukushangzaidenglupingmushenshushedingshangshedingtruehui

使shioraclezaizichengxulianjieshujukushibaishixianshidenglupingmu.

logon_screen; xianshishujukudengluminmu

logout; 退tuichushujukudenglu;

main_menu; xianshiyingyongzhucaidan

menu_clear_field; shanchudangqianxiangdaoguangbiaoyoubiandezifu

menu_next_field; yidongguangbiaodaoshurushenshuzhiduihuakuangzhongxiayixiangshang.

menu_parameter; xianshishurushenshuzhiduihuakuangzhongsuoyoudangqiancaidanshenshudezhi

menu_previous_field; yidongguangbiaodaoshurushenshuzhiduihuakuangzhongqianyixiangshang.

menu_redisplay; zaicaidanshuaxinpingmu

menu_show_keys; xianshigongnengjianduihuakuang

message(xinxizifufanhuixiangying); zaixinxilanshangfangzhizhidingxinxitayoulianggeshenshu:acknowledge

xianshiyigetixingcaozuozhebukehushidemokuaino_acknowledge

gaosuoraclelianggexinxibeisongchuhoubuxuyaofanhuixiangying;

message_code; zhidingdangqianshengchengxinxidegeshu

message_text; zhidingdangqianshengchengxinxidewenzi

message_type; zhidingdangqianshengchengxinxideleixing

move_window(window name,x,y); yidongchuangkou

name_in(variable); weizhidingbianliangdingyishuzhi

next_block; yidongdaoxiayigekuai

next_form; yidongdaoxiayigeform

next_item; yidongdaoxiayigexiang

next_key; yidongdaoxiayigeguanjianzixiangzhegeguanjianzibixushiguangbiaokeyixiangde

youxiaode

next_menu_item; yidongdaoxiayigecaidanxiang

next_record; yidongdaoxiayitiaojilu

next_set; congshujukuhuoquxiayijilujibingjiangguangbiaozhixiangdiyigejilu

paste_region; niantiejianqiebanneirongdaoguangbiaochu

pause; tingzhiformjinchengzhidaoyonghuanxiayigegongnengjian

populate_group(zuming); zhixingjiluzuchaxunfanhuiyigeshuzibiaomingchenggong(0),fei(0)biaoshibai

populate_group_with_query(jiluzuidhuomingchengchaxun) yongchaxunjieguochongzhijiluzudeyigejiluxing

populate_list(list name,record group id); yongzhidingjiluzudeshuzhilaichongzhixialaliebiao

post; congformchuansongshujudaoshujukuwuxutijiao

previous_block; yidongguangbiaodaoqianyigekuai

previous_form; yidongguangbiaodaoqianyigeform

previous_item; yidongguangbiaodaoqianyigexiang

previous_menu; yidongguangbiaodaoqianyigecaidan

previous_menu_item; yidongguangbiaodaoqianyigecaidanxiang

previous_record; yidongguangbiaodaoqianyitiaojilu

print; zhixingdangqianchuangkoudepingmudayin

query_parameter(parameter literal); xianshibaohanzhidingshenshuzhidequery parameterduihuakuang

read_image_file(wenjianming,wenjianleixing,xiangming); xianshiformstuxiangxiangsuoduiyingdewenjian

redisplay; qingchuxiancunpingmubingchongxinqidongpingmu

replace_content_view(window name,view name); zaidangqianchuangkouzhonggaibianhuaban_shitudeneirong

replace_menu(caidanwenjianmingcaidanleixingchushihuacaidanming yongxincaidandaitidangqiancaidan

zuminguse_file);

rest_group_selection(record group idhuorecord group name); quxiaozuzhongxingjiludedangqianxuanding

resize_window(window id,kuan,gao); gaichuangkoudaxiaodaozhidingdeshezhi

retrieve_list(list name,record group name); baocundangqianliebiaodaozhidingdejiluzuzhong

run_product(oraclechanpin,wenjian,tongxunstyle,executi on style,location, qidongzhidingdeoracleruanjianchanpinbingzhixingwenjiancommunications

list ,display); shedingwei:synchronousgaosuoraclezaixinruanjianguanbihoufanhuiformkongzhi

asynchronousgaosuoraclelijifanhuiformskongzhi,zhixingshedingshi:batch,

runtime.dingweishedingjuedinglechanpinyaozhixingdewenjiandeweizhi;listhuoname

bianliangjuedingleyaochuangeichanpindeshenshuliebiaodisplaybianliangzhidingleyou

graphicsshengchengdeformstubiaodemingcheng.

scroll_down; congjiluhuancunzhongxianshixiayigejiluji

scroll_up; congzhuluhuancunzhongxianshiqianyigejiluji

scroll_view(view name,x,y); xiugaix,yhuabanzuobiaoshuxingshedinglaichongsheshitudeweizhi

select_all; quanxuandangqianxiangzhongdewenben

set_alert_property(alert name,alert_message_text,message); xiugaixianshiyubaojingtishizhongdewenzixinxibaojingxinxishuxingshi

alert_message_text(diergeshenshu);

set_application_property(property,setting); gaibiandangqianyingyongdeshuxingshuxingweicursor_style.qizhiwei:

busy,crosshair,default,help,insertion

set_block_property(block name,property,value); gaibiankuaishuxing

set_canvas_property(canvas name,property,valuehuo[x,y]); gaibianhuabanshuxing

set_form_property(form name,property,value); gaibianformshuxing

set_group_char_cell(zulieminghuoid,xinghao,shuzhi); gaibianyigezifuzudanyuandezhi

set_group_data_cell(zulieminghuoid,xinghao,shuzhi); gaibianyigeshujuzudanyuandezhi

set_group_number_cell(zulieminghuoid,xinghao,shuzhi); gaibianyigeshuzizudanyuandezhi

set_group_selection(jiluzuminghuoid,xinghao); xuanzhonghuodingweidaozhidingdejiluzudeyixing

set_input_focus(caidan); gaibianshurudiandaodangqiandeformcaidanshang

set_item_property(xiangming,shuxing,zhihuo[x,y]); gaibianxiangshuxing

set_lov_property(mingcheng,shuxing,zhihuo[x,y]); gaibianzhiliebiaoshuxing

set_menu_item_property(caidanxiangid,shuxing,zhi); gaibiancaidanxiangshuxing

set_parameter_attr(liebiaohuomingcheng,shenshu,shenshuleixing,zhi); gaibianshenshuliebiaozhongzhidingdeshenshudeleixingheshuzhi.

set_record_property(jiluhao,kuaiming,shuxing,shuzhi); gaibianzhidingjiludezhuangtaishuxing,shuxingzhiwei:changed_status,i

insert_status,new_status,query_status

set_relation_property(relation idgongmingcheng,shuxing,shuzhi); gaibianzhidingguanxideshuxing

set_view_property(view name,property ,vlalue[x,y]); xiugaiviewdeshuxing

set_timer(jishiqiid,haomiao,fanfu); xiugaijishiqidesheding.

set_window_property(name,property,value[x,y]); xiugaichuangkoudeshuxing

show_alert(name); qidongzhidingdejingbaoqibingfanhuiduiyingsuoxuananniudeshuzhi

show_ackground_menu; zhanshibeijingcaidan

show_editor(bianjiqimingzi,text in[x,y]optional,tex tount,result); zaizhidingweizhiqidongbianjiqi,jiangyichuanwenziweiru/chubianjiqi

show_keys; zhanxianformgongnengjianduihuakuang

show_lov(name,[x,y]); xianshizhidingdeshuzhiliebiao,zhegeneizhizichengxufanhuiyigebuer

zhi,tajiangbeizuoweidengshideyibufen(biru:a=show_lov(lov_name)

show_menu; jihuobingxianshidangqiancaidan

show_view(name); xianshizhidingdehuabanhuoshitu

show_window(name,[x,y]); zaix,yzuobiaoshangxianshizhidingdechuangkou

synchronize; jinzairuxialianggetiaojianmanzushiyuanxuoraclexiugaixianshi:yijing

wanchengduixinhuabanhuoshitudedingweibingformshichuyuxiangdejibiezhishang

terminate; tingzhixiangformhuoduihuakuangshurushuju.

unset_group_selection(jiluzuming,xinghao) quxiaoyouset_group_selectionsuozuodexingdexuanding

up; congjiluhuancunzhongxianshiqianyigejilu

update_record; 使shiformtongguoformdexiugaijinxingshujukugenggai

user_exit(biaodashi,cuowuwenzi); qiyongbaohanzaibiaodashishenshuzhongdeyonghu退tuichuchengxu

validate(shenshu); 使shiformzhixingjiyushenshufanweideyouxiaodeguocheng.shenshuwei:

default_scope,form_scope,record_scope,item_scope

vbx.fire_event(itemname,shijian,shenshubiaolist idhuomingcheng) weivbxkongjianjinxingshijiandeqidong

vbx.get_property(item namehuomingcheng,shuxing); biaoshivbxkongjianshuxingdezhi

vbx.get_value_property(name,shuxing); biaoshivbxkongjiandevbxkongzhishuxingzhi

vbx.invoke_method(name,fangfaming,w,x,y,z); zhixingbaohanzaixiangdefangfamingzhongdezhongjianxiang

vbx.set_value_property(name,shuxing); genggaizhidingdevbxkongjianshuzhishuxing

where_display; genggaiwherecaidanguangbiaoyidongxuanxiangdeshuzhi,zhiweion,off

write_image_file(tuxiangwenjian,wenjianleixing,mingcheng) congoracle formsdetuxiangxiangcunfangtuxiangdaowenjianzhong

原文
Oracle Developer 2000中的一些实用语句: abort_query; 停止查询的执行 add_group_column(record group id 或 name,group column 添加一个列到一个记录组,Record group id name,column type,column width); add_group_row(record group id 或 name,row number); 添加一个行到一个记录组,record group id是oracle赋 予这个组的唯一的名称,row number指定了这个行在组中 位置. add_list_element(list name or list id, list index,list lable,list value); 添加一项到下拉列表框,list name是list的名字,list index 是添加到列表框的索引,list label指定了放入列表中的数值 串,list value包含了列表标识所对应的数据库的数值. add_parameter(list或name,parameter,parameter type,value) 添加一个参数到一个参数列表,参数列表是一个变量列表,这些 变量将被伟给其他对象,list或name指定了这个列表的标识, parameter type(参数类型)包含两种可用数值: text_type是一串字符;data_parameter是一个指定已在form 中定义的记录组的串.value是传给被调模块的实际数值. application_parameter 促使oracle显示Enter parameter 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(time name,milliseconds,iterale); 创建一个计时器。milliseconds(秒)块定每个循环的 分配时间。参娄iterate有两个选项:repeat:默认,告诉 计时器在完成一次计时后重复;on_repeat,完成一次计时后 不重复. cut_region 剪切选中的文本并保存于剪切板中. dbms_err_code 获并显示最后的数据库错误代码 dbms_error_text 显示数据库错误类型信息和文字信息 debug_mode 开启或关闭调试模式,这种模式只用于菜单模块. default_value(literal, variable); 如果当前值为null,则放置文字串literal到variable中. 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的模式为enter query 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名); 查找form的ID. find_group(记录组名); 查找记录组的ID. find_item(项名) 查找项名的ID. find_menu_item(菜单项名); 查找菜单项的ID. find_relation(关系名); 查找关系的ID. find_time(time名); 查找time的ID. 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 id 或name标明的执行命令; 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,file name); 当服务器兼容时,添加一个ole对象到ole容器中 generate_sequence_number 当序列被定义为项属性的默认值时启动产生这个序号 get_application_property(property name); 为当前form的属性定义数值 get_block_property(name,property) 返回块属性值 get_canvas_property(name,property); 返回画布属性值 get_group_char_cell(group column id,row number); 指定一个字符或者记录组单元的字串。单元是一个行/列交叉点。 get_form_property(name,property); 返回指定的forms的属性值 get_group_date_cell(group column id,row number); 指定一个记录组单元的日期值,单元是一个行/列交叉点 get_group_number_cell(group column id,row number); 指定一个记录组单元的数字值,单元是一个行/列交叉点 get_group_row_count(group name); 标识指定记录组中的行号 get_group_selection(name,selection number); 标识指定记录组中行的数字位置 get_group_selection_count(name); 指定自动标定为选中行的总数 get_item_property(name,property); 返回项属性值 get_list_element_count(list name); 指定下接列表框内的值的总个数 get_list_element_label(list name,list_index); 标识选中的下拉列表框内项的标识名称 get_list_element_value(list name,list_index); 标识选中的下拉列表框内项的实际值 get_lov_property(name,property); 标识不同的数值属性设定列表 get_menu_item_property(menu name,property); 标识选中的菜单项的状态。选项为:checked,enabled和labeld get_message; 显示当前的信息 get_parameter_list(list name); 为指定的列表定义参数列表ID get_parameter_attr(listname,参数名,参数类型,数值); 标识被选参数列表中参数的类型的数值。参数类型为: data_parameter:表示此值是组的我称; text_parameter:表明参数值是一个实际数据值 get_radio_button_property(item name,button name,property); 标识选中的圆形按钮属性. get_record_property(record number,block name,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(window name,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命令,savepoint name是指数据被提交的最后时间 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 group id); 用指定记录组的数值来重置下拉列表 post; 从form传送数据到数据库,无须提交 previous_block; 移动光标到前一个块 previous_form; 移动光标到前一个form previous_item; 移动光标到前一个项 previous_menu; 移动光标到前一个菜单 previous_menu_item; 移动光标到前一个菜单项 previous_record; 移动光标到前一条记录 print; 执行当前窗口的屏幕打印 query_parameter(parameter literal); 显示包含指定参数值的query parameter对话框 read_image_file(文件名,文件类型,项名); 显示forms图像项所对应的文件 redisplay; 清除现存屏幕并重新启动屏幕 replace_content_view(window name,view name); 在当前窗口中改变画板_视图的内容 replace_menu(菜单文件名,菜单类型,初始化菜单名, 用新菜单代替当前菜单 组名,use_file); rest_group_selection(record group id或record group name); 取消组中行记录的当前选定 resize_window(window id,宽,高); 改窗口大小到指定的设置 retrieve_list(list name,record group name); 保存当前列表到指定的记录组中 run_product(oracle产品,文件,通讯style,executi on style,location, 启动指定的oracle软件产品并执行文件communications list ,display); 设定为:synchronous告诉oracle在新软件关闭后返回form控制 asynchronous告诉oracle立即返回forms控制,执行设定是:batch, runtime.定位设定决定了产品要执行的文件的位置;list或name 变量决定了要传给产品的参数列表。display变量指定了由 graphics生成的forms图表的名称. scroll_down; 从记录缓存中显示下一个记录集 scroll_up; 从主录缓存中显示前一个记录集 scroll_view(view name,x,y); 修改x,y画板坐标属性设定来重设视图的位置 select_all; 全选当前项中的文本 set_alert_property(alert name,alert_message_text,message); 修改显示于报警提示中的文字信息。报警信息属性是 alert_message_text(第二个参数); set_application_property(property,setting); 改变当前应用的属性。属性为:cursor_style.其值为: busy,crosshair,default,help,insertion set_block_property(block name,property,value); 改变块属性 set_canvas_property(canvas name,property,value或[x,y]); 改变画板属性 set_form_property(form name,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(编辑器名字,text in[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的图像项存放图像到文件中
󰈣󰈤
 
 
 
>>返回首页<<
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
王朝网络微信公众号
微信扫码关注本站公众号wangchaonetcn
 
 
静静地坐在废墟上,四周的荒凉一望无际,忽然觉得,凄凉也很美
©2005- 王朝网络 版权所有