Posted using TxtLJ

[azurelunatic]

I became disenchanted with SQL (as found in Access) when I realized I could not comment my code.

Comments

[wibbble]

At least for MySQL, you can add comments with a '--' at the start of the line.

I've no idea about Access.

[xinef.livejournal.com]

Same for t-SQL as used in SQL Query Analyser. No idea if Access uses same syntax.

And you can add comments at the end of a line in the same way:

--this is a simple select statement
select * from database.dbo.thistable with (nolock) -- don't do this if this is a large table

[azurelunatic]

Useful!

[xinef.livejournal.com]

I work with SQL all the time. Can't say I'm an expert on all matters re SQL, but certainly on some! Feel free to drop questions and I'll try to answer them for you.

[ralmathon.livejournal.com]

From what I remember, you can't comment the SQL itself in Access. You can comment in the code just before you call the SQL however. That takes VB knowledge though. If it's on a button click that your calling the SQL, go into the code for the button and comment there. That's the best advice I can give. Sorry.,

[azurelunatic]

Makes sense.

This is all old grudges being brought up, nothing fresh.