Description Box for the Definition Query

159
1
10-04-2010 10:28 AM
Status: Open
AlexZhuk
Regular Contributor

Some def. queries can be quite long and complicated. That's why a description box right under the query in the layer's Properties box is needed where we could leave our notes in plain English.

1 Comment
DanaNolan
Although I do agree with your suggestion, you can use SQL comments in the DQ. The separate box you are suggesting would have to be kept up to date with the SQL, otherwise it would do more harm than good.

Another consideration is who looks at the DQ tab. If the DQ is permanent, it should probably be commented in the General tab of the layer. I do this for layers.