Hi,
I am working on a solution to pull data out of our IMAGE database into FM v5.5. Pulling the data out of IMAGE isn't a problem, but I am not sure how to make the query I want dynamic. Here is a cut down version of the query:
SELECT WOSHT.SHTWO, WOSHT.SHTPN, IM.DESC, WOSHT.SHTQTY, IM.SCODE
FROM MANDB.IM IM, MANDB.WOSHT WOSHT
WHERE WOSHT.SHTPN = IM.ITNO AND ((WOSHT.SHTWO='123456'))
Instead of hardcoding '123456' I would like to use a global FM field.
In summary, I want to query an IMAGE database from FM using a FM field as the variable.
Is this possible?
