November 13, 2003 at 11:23 pm
How can we use comments in access query like -- in SQL
My Blog:
November 17, 2003 at 8:00 am
This was removed by the editor as SPAM
November 17, 2003 at 9:33 am
Please explain how and where you want to put these comments:
In the database window?
Right mouse click the name of the query. Enter comments in the description, on the view menu select details.
In design view?
I don't think you can
In Sql view?
I don't think you can
In VBA?
Precede comment with an apostrophe '
November 18, 2003 at 9:43 pm
in SQL View
I want to run this query
Select * from Table1
-- Where a= 1
Where a= 1 is the commented line
My Blog:
November 19, 2003 at 4:48 am
As mentioned above, I don't think this is possible in SQL view
November 19, 2003 at 9:56 am
Sorry NO SQL COMMENTS are supported in Jet
* Noel
November 20, 2003 at 11:14 pm
Ok thanks every body
My Blog:
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply