J
JRB
Guest
Does anyone know if I can comment out select criteria in a query without deleting it???
-
Come enter the Ridemonkey Secret Santa!
We're kicking off the 2024 Secret Santa!
Come exchange gifts with other monkeys - from beer and snacks, to bike gear, to custom machined holiday decorations and tools by our more talented members, there's something for everyone.
Click here for details and to learn how to participate.
J
JRB
Guest
Not even if I edit the SQL??? That seems silly. Every other query lets you doesn't it???
Not to be lazy, but I have a form parameter I don't want to get hosed up.
Not to be lazy, but I have a form parameter I don't want to get hosed up.
There are a couple things you can do -
Copy/paste the original sql into the query description(right click the query > properties), then if you make some changes and something doesn't work you still have an original copy to fall back on.
You can also run the query from VB - just copy the sql to a string and comment out whatever you need.
Copy/paste the original sql into the query description(right click the query > properties), then if you make some changes and something doesn't work you still have an original copy to fall back on.
You can also run the query from VB - just copy the sql to a string and comment out whatever you need.
J
JRB
Guest
dropkick said:
I kind of figured the copy was my next bet. I may screw it up with VB.
Oh - and thanks.
Dude! Your avatar kicks major a$$. The wife and I just watched "American Splendor".....dropkick said:
-S.S.-