Subject | IB6 to FB Ambiguous Detection Utility |
---|---|
Author | Kevin Stanton |
Post date | 2003-03-24T18:35:28Z |
Greetings,
Not sure if anyone would be interested in this utility, but I'm in the
middle of creating a program to detect select statements with multiple
tables and ambiguous field names. I've got a gdb with 336 procs and 387
triggers and just don't want to slug though it manually.
The program scans procs and triggers looking for this condition and fills a
listbox of "suspects".
If there is any interest, I would/will gladly post the binaries and Delphi
source code on my web site for download.
I'm working on the stored proc end of it and triggers won't be much of an
adjustment. And I would also then have to pretty it up as well - a bit
rough at the moment.
Cheers,
Kevin
Not sure if anyone would be interested in this utility, but I'm in the
middle of creating a program to detect select statements with multiple
tables and ambiguous field names. I've got a gdb with 336 procs and 387
triggers and just don't want to slug though it manually.
The program scans procs and triggers looking for this condition and fills a
listbox of "suspects".
If there is any interest, I would/will gladly post the binaries and Delphi
source code on my web site for download.
I'm working on the stored proc end of it and triggers won't be much of an
adjustment. And I would also then have to pretty it up as well - a bit
rough at the moment.
Cheers,
Kevin