Hi Karl,
I downloaded and installed the new version, and it looks as the "referenced by" functionality is ok now. But, as a matter of fact, I think I found at least two other problems:
1. I have a stored procedure, named spVEN_REL_SALDO_NEGATIVO, and SQLDBControl says it references three tables and is referenced by another stored procedure, named spVEN_REL_SALDO_NEGATIVO_Funcionario. But this last stored procedure does not references the first one at all. I was intrigued by this error, tried some thoughts, and I think I solved it: it is the name. As you can see, the name of the second procedure is almost the same as the first, but appended with _Funcionario. Every time we have this kind of construction, SQLDBControl says the second is referencing the first. It seems your code is comparing only the number of characters of the shorter name;
2. when I look at "functions", I can see, in the "referenced by" every procedure which calls a specified function. But in the "references" in the procedures, I can see only tables and procedures, but not functions. Why?
I hope this can help you
Regards,
Joel
from the middle of the Rain Forest
SQLDBcontrol Support
support@sqldbcontrol.com