I am trying to convert for ex. 12012008 to 12/01/2008 in 4gl code. There is going to be a list of dates so I am trying to figure out the simplest way in which to code it...any suggestions?
SQL:
SELECT COUNT(*)
FROM table1
WHERE NOT EXISTS
(SELECT item e
FROM table2, table3
WHERE prod_S_dept = filter_itema
and prod_cat = filter_itemb
and itemc = itemd)
4GL:
SELECT COUNT(*)
FROM table1
WHERE NOT EXISTS
(SELECT item e
FROM table2, table3...
I created code in SQL that works. I then used the same code in 4GL but it doesn't work...no errors just the wrong answer. Does anyone know where I might look to find the problem?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.