Home › projects › Prolint Issue Tracker › Issues

check if every RECORD_NAME and Field_Ref are qualified

Wed, 2006-10-11 18:34 — jurjen
Project:Prolint Issue Tracker
Component:Rules
Category:feature request
Priority:normal
Assigned:Unassigned
Status:active
Description

Requested by Jeff Pilant: check if every RECORD_NAME and Field_Ref are qualified with a db-alias and appears in file "validalias.txt". Particularly usefull for Syteline sources. Related request: create an Open Source version of a "validalias.txt" for Syteline.


Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Mon, 2006-12-18 22:29 — inatanz

I wrote a rule like that to

I wrote a rule like that to check for field names without table names. For some reason though, its dated in 2003 and we're not using it. I dont remember if there was a problem with it - maybe it was too slow doing a schema check (since it was building a dynamic query for each field) ...
I'll probably test it and if it still works I may post it ... but it probably was slow and unreliable - that's my guess.


Mon, 2006-12-18 22:47 — jurjen
jurjen's picture

Re: I wrote a rule like that to

Hi Igor!
Have you seen rule tablename? It does an attempt to find fieldnames without table names.

But the original question was slightly different: it requires that specific table names are qualified with database-alias names.