Stuart McLachlan
stuart at lexacorp.com.pg
Wed May 14 05:56:57 CDT 2003
On 14 May 2003 at 9:39, Roz Clarke wrote: > Thanks John > > I've thrown this back to the list to discuss your suggestions. > > Regarding the running of SQL statements direct versus passing a string > variable - is there a reason for doing this other than the > re-usability of the variable? I want to be able to explain why I was > looking for a certain thing, and so many of these things are just > habits I picked up from the list without ever fully understanding WHY. > For debugging purposes, it's a lot easier if you use a string variable. If something breaks, you can do a MsgBox strSQL to see where it has gone wrong. Using the SQL statement directly is an advantage if you are iterating through a loop and executing may times. It runs slightly faster. -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.