Tag Archives: genero fourjs fjs 4gl programming

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 →

  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.

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

  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 →