ssbaan
7th January 2003, 16:15
I have a question about BaaN's SupportEye.
Someone in our organization has mentioned that with the download of BaaN's SupportEye you receive a tool for viewing BaaN source code! I sorta find this hard to believe that BaaN would open this up to it's non-source client base, but being we are one of the non-source clients, this does sound interesting.
Has anyone else heard of this or have any information on this?
Thanks
dave_23
7th January 2003, 17:57
SupportEye won't give you the "source" but its "Object Magnifier"
will give you a nice picture of what tables, dlls are being used and what type of actions are being used on them. Plus it will give a nice picture of all the queries being issued as below:
SQL 1 select tccom000.ncmp
from tccom000
where tccom000.ncmp = :i.cono
as set with 1 rows
SQL 2 select tfgld004.gcmp
from tfgld004
where tfgld004.srno = 1
and tfgld004._compnr = :i.cono
as set with 1 rows
SQL 3 select tfgld003.bcmp
from tfgld003
where tfgld003.srno = 1
and tfgld003._compnr = :tfgld004.gcmp
as set with 1 rows
SQL 4 select tfgld008.desc:o.desc
from tfgld008
where tfgld008._index1 = { :i.leac }
and tfgld008._compnr = :i.cono
as set with 1 rows
SQL 5 select tfgld016.*
from tfgld016 for update
where tfgld016.cono = :hold.rcmp
and tfgld016.leac = :hold.rlea
as set with 1 rows
SQL 6 select tfgld016.cono
from tfgld016
where tfgld016.cono = :hold.rcmp
and tfgld016.leac = :hold.rlea
as set with 1 rows
ssbaan
7th January 2003, 23:51
Dave_23
Do you know if that will work on customized or customer written
sessions,. or just BaaN standard sessions?
Thanks
Dikkie Dik
8th January 2003, 09:51
It works on both as the Object Magnifier is lookig to objects. In fact all embedded SQL can be found. Thinks that will be missed are:
- dynamic SQL
- SQL generated from standard program
- SQL generated from DAL
lbencic
8th January 2003, 23:38
Much of the 'source code' information that Support Eye can give you can be found by running the bic_info.exe / bic_info6.1 command on the object (standard or custom). This will show you all of the SQL syntax, as well as external variables etc. It will also show you the path to the current object in your VRC.
Dikkie Dik
9th January 2003, 09:41
Thats correct. But I llike the interface and possibilities of SupportEye and the program underneath itself (bboam) more than bic_info. For example when searching for a certain string or combination can be done more easili. Also db commands can be found like db.delete, db.first etc. This is not/hardly possible by bic_info.