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

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 ’12:13′ and rwb09 between ’14’ and ’15:16′      ”

g_wc2 = (null)

lc_qbe_sn = 0

This entry was posted in fourjs platform and tagged . Bookmark the permalink.

Leave a comment