Reply
Consistent Contributor
logos
Posts: 89
Registered: 12-05-2008
0

BEST PRACTICE: Put SQL statements in a variable for use in DB actions

The debugger doesn't show the SQL statements in DB actions; putting SQL statements in a variable right before the DB action and then using the variable in the DB action instead of the SQL ststements directly makes debugging MUCH easier. 

Tyler Style
IT Operations Manager
Healthy Habits, LLC

http://malthusian-solutions.com
http://nirdvana.com