Category Archives: fourjs platform

genero fourjs fjs —about the table ds.tiptop_columns —where is the ‘ds.tiptop_columns table’ data from?(tiptop gp 5.2)

Posted on 2010/10/27 by sapimplexpert

    in the tiptop gp 5.2,   about the table ds.tiptop_columns  —where is the ‘ds.tiptop_columns table’ data from?   do you know ?       technology exchange : msn: erp.expert@hotmail.com

Posted in fourjs platform, tiptop erp(using fourjs) | Tagged | Leave a comment

genero fourjs fjs.com 4gl- it can not get correct sql condition when use time conditon

Posted on 2010/10/17 by sapimplexpert

I found fourjs fjs language -construct, it can not get correct sql conditon when i need use the ‘time’ condition.   look below, this is evidence:   g_wc = “rwb06=TO_DATE(‘2010-10-12 00:00:00′,’YYYY-MM-DD HH24:MI:SS’) and rwb07=TO_DATE(‘2010-10-19 00:00:00′,’YYYY-MM-DD HH24:MI:SS’) and rwb08 between ’11’ and … Continue reading →

Posted in fourjs platform | Tagged | Leave a comment

genero fourjs fjs.com 4gl—tiptop gp 5.2 p_per p_perlang

Posted on 2010/10/13 by sapimplexpert

  about the p_per p_perlang, in our program , it has two rows for one program.   one row for customize program , one for standard program.   remember it.

Posted in fourjs platform | Tagged | Leave a comment

genero fourjs fjs.com 4gl—session in tiptop gp 5.2—open source code

Posted on 2010/10/12 by sapimplexpert

    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 →

Posted in fourjs platform | Tagged | Leave a comment

fourjs genero fjs.com 4gl—tiptop gp5.2, i can not get the data from the view, why?

Posted on 2010/10/11 by sapimplexpert

  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 →

Posted in fourjs platform | Tagged | Leave a comment

fourjs genero fjs 4gl—same function to get the data—one static sql and one dynamic sql

Posted on 2010/10/10 by sapimplexpert

     #—>sale order number:    MESSAGE ” (1)Wait…”   LET g_ima.oeb_q = 0   SELECT SUM((oeb12-oeb24+oeb25-oeb26)*oeb05_fac) INTO g_ima.oeb_q          FROM oeb_file, oea_file          WHERE oeb04 = g_ima.ima01 AND oeb01 = oea01 AND oea00<>’0′            AND oeb70 = ‘N’            AND oeb12-oeb24+oeb25-oeb26>0            AND oeaconf = ‘Y’ … Continue reading →

Posted in fourjs platform | Tagged | Leave a comment

fjs fourjs 4gl genero—which schema am i connecting? in oracle db

Posted on 2010/10/10 by sapimplexpert

  i have many schema, many users , after i switch schema serial times, now , which schema am i connecting? does it have one system variable to display it?     next sql time, which schema i will connect … Continue reading →

Posted in fourjs platform | Tagged | Leave a comment

fourjs-genero fourjs debug error, i don’t know why? can you help me?(Experience)

Posted on 2010/10/02 by sapimplexpert

  when i r.d2+, then error, error picture:   r.d2+ axmt620program is “/u1/topstd/tiptop/axm/4gl/../42r/axmt620.42r”, args are “”program is: “fglrun -d /u1/topstd/tiptop/axm/4gl/../42r/axmt620.42r 2>&1”, status is:          0debugger backend terminated           make friends msn: erp.expert (at) hotmail.com skype:mrsf_jean.luc

Posted in fourjs platform | Tagged | Leave a comment