Thanks Frank.  I did not know that! I've been putting in the ";" forever.

Jeff

Jeff Johnson
SanDC, Inc.
(623)-582-0323

www.san-dc.com <http://www.san-dc.com>
www.cremationtracker.com <http://www.cremationtracker.com>
www.arelationshipmanager.com <http://www.arelationshipmanager.com>


On 1/3/2014 12:54 PM, Frank Cazabon wrote:
Jeff,

I see the others have helped out in terms of using AERROR and pointing out the extra comma. To answer this:

On 03/01/2014 12:30 PM, Jeff Johnson wrote:
Should there be ";" line continuations in there? Also, any reason why you put the commas in front instead of behind the varuable?

No, SQL uses ";" as a terminator to run all the command that came before that.

I put the commas at the start of a line because I find it much easier to see that the commas exist that way.




--- StripMime Report -- processed MIME parts ---
multipart/alternative
 text/plain (text body -- kept)
 multipart/related
   text/html
   image/jpeg
---

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to