Welcome to SQLDBcontrol Forums Sign in | Join | Help
in

problem with references and referenced by

Last post 09-06-2006, 21:04 by admin. 0 replies.
Sort Posts: Previous Next
  •  09-06-2006, 21:04 81

    problem with references and referenced by


    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
View as RSS news feed in XML
Powered by Community Server, by Telligent Systems