Commenting within the queries (1 Viewer)

Jonny

Registered User.
Local time
Today, 11:14
Joined
Aug 12, 2005
Messages
140
I'm getting lost due to multiple criterias within the queries. What's the best practice to comment the criterias?
 

arnelgp

error reading drive A:
Local time
Today, 16:14
Joined
May 7, 2009
Messages
9,332
put in a Table the query name, SQL string, criteria, comment
there is no facility to add comment on the query itself.
 

Jonny

Registered User.
Local time
Today, 11:14
Joined
Aug 12, 2005
Messages
140
put in a Table the query name, SQL string, criteria, comment
there is no facility to add comment on the query itself.
Good idea, thank you!
 

isladogs

CID Moderator
Staff member
Local time
Today, 09:14
Joined
Jan 14, 2017
Messages
13,194
Alternatively, you can add a comment/description to any database object such as a query which can be viewed when you use Details view in the navigation pane.



To add a description, click the object in the nav pane and select Object Properties from its context menu.
 

Attachments

Jonny

Registered User.
Local time
Today, 11:14
Joined
Aug 12, 2005
Messages
140
Alternatively, you can add a comment/description to any database object such as a query which can be viewed when you use Details view in the navigation pane.



To add a description, click the object in the nav pane and select Object Properties from its context menu.
Great, thank you!
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom