-
Recent Posts
Recent Comments
Eric on change work to guangzhou servi… Sapjean on When i open the ‘http://… Daniel on When i open the ‘http://… Sapjean on sap abap—关于range table r… 辉腾 on 笔记本 windows 7 只要在config.sys 加N… Archives
- February 2011
- January 2011
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- November 2008
Categories
- asp.net
- bank
- Computers and Internet
- 经济world
- database
- delphi
- 计算机与 Internet
- fourjs platform
- Hobbies
- IBM
- ibmaix
- java language
- java-jsp-app
- java-jsp-web-develop
- life of me
- office
- SAP
- SAP ABAP
- sap basis
- SAP FICO
- SAP MM
- sap-abap-java
- SAPSD
- sap_dotnet
- server_tomcat
- sqlserver
- tiptop erp(using fourjs)
- Uncategorized
- 我的生活
- 新闻与政治
Meta
Tag Archives: fourjs genero 4gl fjs.com oracle view sid_file
genero fourjs fjs.com 4gl—session in tiptop gp 5.2—open source code
sessionid in genero fourjs fjs tiptop gp 5.2: # Prog. Version..: ‘5.20.01’## Program name…: cl_insert_sid.4gl# Descriptions…: 將view所需要的資訊新增到sid_file內# Date & Author..: 2009/07/24 by Hiko# Usage……….: CALL cl_ins_del_sid(1)# Modify………: No.FUN-980030 09/08/10 by Hiko:For GP5.2DATABASE dsGLOBALS “../../config/top.global”################################################### Descriptions…: 將view所需要的資訊新增到sid_file內# Date … Continue reading
fourjs genero fjs.com 4gl—tiptop gp5.2, i can not get the data from the view, why?
CREATE OR REPLACE VIEW OEB_FILE ASSELECT “OEB01″,”OEB03″,”OEB04″,”OEB05″,”OEB05_FAC”,”OEB06″,”OEB07″,”OEB08″,”OEB09″,”OEB091″,”OEB092″,”OEB11″,”OEB12″,”OEB13″,”OEB14″,”OEB14T”,”OEB15″,”OEB16″,”OEB17″,”OEB18″,”OEB19″,”OEB20″,”OEB21″,”OEB22″,”OEB23″,”OEB24″,”OEB25″,”OEB26″,”OEB70″,”OEB70D”,”OEB71″,”OEB72″,”OEB901″,”OEB902″,”OEB903″,”OEB904″,”OEB905″,”OEB906″,”OEB907″,”OEB908″,”OEB909″,”OEB910″,”OEB911″,”OEB912″,”OEB913″,”OEB914″,”OEB915″,”OEB916″,”OEB917″,”OEB1001″,”OEB1002″,”OEB1003″,”OEB1004″,”OEB1005″,”OEB1006″,”OEB1007″,”OEB1008″,”OEB1009″,”OEB1010″,”OEB1011″,”OEB1012″,”OEB920″,”OEB1013″,”OEB930″,”OEB27″,”OEB28″,”OEB29″,”OEB30″,”OEB31″,”OEB935″,”OEB936″,”OEB937″,”OEB41″,”OEB42″,”OEB43″,”OEB931″,”OEB932″,”OEB933″,”OEB934″,”OEBUD01″,”OEBUD02″,”OEBUD03″,”OEBUD04″,”OEBUD05″,”OEBUD06″,”OEBUD07″,”OEBUD08″,”OEBUD09″,”OEBUD10″,”OEBUD11″,”OEBUD12″,”OEBUD13″,”OEBUD14″,”OEBUD15″,”OEB44″,”OEB45″,”OEB46″,”OEB47″,”OEB48″,”OEBPLANT”,”OEBLEGAL”,”TA_OEB001″,”TA_OEB002″,”TA_OEB004″,”TA_OEB005″,”TA_OEB006″ FROM a103.oeb_file WHERE oebplant = (SELECT sid02 FROM sid_file WHERE sid01=(SELECT userenv(‘SESSIONID’) FROM dual)); if i use the ‘select * from oeb_file’, then, the row is zero. why ? … Continue reading