cracked egg
5th May 2004, 17:57
It looks like when I ran "print where used tables" and selected a particular field tiitm001.oltm the results include cases where there is a "select tiitm001.* " not just a specific ref to tiitm001.oltm. Is this the case? (I chose field level.)
Regards

lbencic
5th May 2004, 19:41
Yep, that's the case as far as I can tell, I just ran into this. Theoretically, it's used at that point, because it's selected. Any number of other (even external) process could access that variable then, so it's listed in print where used.

Still this is a pain if you just want to see where standard Baan uses the variable.

If you have source code, you can run an os search for that variable in the program scripts, functions, dlls', report scripts. Then you can eliminate those components when you run print where used. Together they should give a better picture of where that specific table field is used, not just read using the .* in the sql.