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

 

CREATE OR REPLACE VIEW OEB_FILE AS
SELECT “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 ?

 

yeah, because the oeb_file is a view in the oracle, we can not use the ‘select * from oeb_file’ directly.

 

 

have a look the sid_file data:

SID01    SID02    SID03    SID04    SID05    SID06    SID07    SIDDATE
3376068    103C    a1020    H2254    1073688    udm_tree    15:42:19    09-九月-10
3377252    1031    a1020    H4110    660060    axmt410    16:09:28    09-九月-10
3377603    1020    a1020    H2304    1433646    udm_tree    16:15:17    09-九月-10
3412757    1020    a1020    H2519    422052    axmt410    14:50:58    10-九月-10
3385881    1031    a1020    H2242    1225160    cxmr301    19:35:31    09-九月-10
3388612    103C    a1020    H2254    852284    udm_tree    20:59:36    09-九月-10
3407583    103    a103    tiptop    721546    apcp200    12:45:01    10-九月-10
3407613    103C    a1020    H4330    799334    p_crdata_set    12:45:26    10-九月-10
3412280    1030    a1020    H3305    1253964    artr002    14:39:07    10-九月-10
3439608    1020    a1020    H3626    467246    axmt410    10:52:16    11-九月-10
3413757    1030    a1020    H3303    1311024    udm_tree    15:10:54    10-九月-10
3414140    103    a103    H2465    680642    arti111    15:18:10    10-九月-10
3451034    1031    a1020    H3369    1626156    udm_tree    15:34:20    11-九月-10
3474967    1020    a1020    H2204    1237334    udm_tree    10:08:26    12-九月-10
3525070    103    a103    H1645    1114684    cxmr001    10:50:32    13-九月-10
3485070    1028    a1020    H3834    1347620    axmt410    14:28:42    12-九月-10
3488513    103    a103    tiptop    1704326    apcp200    15:30:01    12-九月-10
3493091    1020    a1020    H2440    1404956    udm_tree    16:54:23    12-九月-10
3541803    1028    a1020    H2283    540676    udm_tree    17:15:04    13-九月-10
3525040    1031    a1020    H3723    553502    cxmr001    10:49:41    13-九月-10
3581515    103    a103    H4311    1315518    udm_tree    17:26:02    14-九月-10
3618272    103D    a1020    H2246    1622452    axmt410    16:57:24    15-九月-10
3581644    1027    a1020    H2858    119238    axmt410    17:27:38    14-九月-10

 

 

 

 

 

technology exchange:

 

msn:erp.expert@hotmail.com

skype:mrsf_jean.luc

在alipay支付宝里，我们现在不能充入一张银行卡的钱，再提现到另一张卡里了，看下面，正在申请退回我的钱

 

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

 

   #—>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’

 

 

same as :

 

        LET c_sql=” SELECT SUM((oeb12-oeb24+oeb25-oeb26)*oeb05_fac)    “,
                  ” FROM oeb_file, oea_file    “,
                  ” WHERE oeb04=? AND oeb01 = oea01 AND oea00<>’0′    “,
                  ”  AND oeb70 = ‘N’  AND oeb12-oeb24+oeb25-oeb26>0 AND oeaconf = ‘Y’  “
    PREPARE pre_001 FROM c_sql
    LET g_ima.oeb_q = 0
    EXECUTE pre_001 using g_ima.ima01 INTO g_ima.oeb_q
    FREE pre_001
   IF cl_null(g_ima.oeb_q) THEN
      LET g_ima.oeb_q = 0
   END IF

   DISPLAY BY NAME g_ima.oeb_q

 

 

technology exchange: msn:erp.expert@hotmail.com

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

 

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 to ?

 

can you help me ?

 

how can i do it?

 

HELP!

IM:

msn:erp.expert@hotmail.com

skype:mrsf_jean.luc

i can not connect internet for 5 hours, because i install one proxy plugin into the chrome. it modified my IE proxy.

at last , i uncheck the proxy setting, all is right.

How about the 120tg casio and el-2135 calc?

 

I think it is very good for desktop calc.

 

 

i love it.

just now i bought one -www.tecsun.com.cn pl390 radio.

just now i bought one -www.tecsun.com.cn pl390 radio.

test it

if found that it is not good for shortwave.

fourjs fjs is not good

1、it don’t have a good real time editor.

2、debug is pool.

3、function is simple.

 

and so on

have a good day

have a good day 🙂

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

 

when i r.d2+, then error, error picture:

 

r.d2+ axmt620
program 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:          0
debugger backend terminated

 

 

 

 

 

make friends msn: erp.expert (at) hotmail.com

skype:mrsf_jean.luc