We have BO 4.1.2 and Oracle 7.3. Does anyone know of an easy way to document custom LOV or is there a 3rd party tool that will do it? If not I plan to manually select each object, open it’s properties, press edit for the LOV, press SQL and then cut and paste the SQL statement into a Access database associating the LOV with its Object, Class, and Universe.
In a message dated 00-01-27 12:59:34 EST, you write:
We have BO 4.1.2 and Oracle 7.3. Does anyone know of an easy way to
document custom LOV or is there a 3rd party tool that will do it? If not I plan to manually select each object, open it’s properties, press edit for the LOV, press SQL and then cut and paste the SQL statement into a Access database associating the LOV with its Object, Class, and Universe.
I don’t know if the object model supports it, but in V5 you can access the Designer application via VBA. Writing a script to do the work might save you some time if the proper objects and properties are available.
If you are still using V4, you should know that the universe file format has not changed. So you could use V5 Designer against a V4 universe without any problems.
Has anybody ever accomplished documenting the sql for LOVs in 6.5.1? I’ve looked at the object model but I haven’t been able to figure out if I can get to the LOV sql…
I’ve been looking into this recently and have not found anything, the object model doesn’t seem to pull the sql. Will pull names, values, but not the sql. Too bad, maybe an addition to the “wish list”.
(BOB member since 2002-07-10)
(BOB member since 2003-05-28)