Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.basic.visual.misc > #1636 > unrolled thread

Odd behaviour

Back to article view | Back to comp.lang.basic.visual.misc

Contents

  Odd behaviour R C Nesbit <spam@ukrm.net> - 2012-11-19 11:29 +0000
    Re: Odd behaviour R C Nesbit <spam@ukrm.net> - 2012-11-19 12:20 +0000

#1636 — Odd behaviour

I have a bit of code in a routine which iterates through a 
For I = 0 to n loop
and builds and executes a number of SQL statements for a 
MySQL database.

This bit:
sSql = "SELECT Sum(tblQuotes.TotalValue) AS SumOfTotalValue 
From tblQuotes " & _
" INNER JOIN tblInvoice ON tblQuotes.InvoiceID = 
tblInvoice.I_ID " & _

works once, then bounces to the error handler because it 
produces:

"SELECT Sum(tblQuotes.TotalValue) AS SumOfTotalValue From 
tblQuotesINNER JOIN tblInvoice"
   ^^^^^^^^^^^

If I put a break point in and step the code back to the sql 
build line again it works fine
"SELECT Sum(tblQuotes.TotalValue) AS SumOfTotalValue From 
tblQuotes INNER JOIN tblInvoice"
     ^^^^^^^^   
I am wearing a dent in the desk banging my head against it!

-- 
Rob Pearson

[toc] | [next] | [standalone]

#1637

R C Nesbit spoke:
> I am wearing a dent in the desk banging my head against it!

Bad form etc.. but please ignore this post.
As usual, just writing about it clears the brain-block.

-- 
Rob Pearson

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.basic.visual.misc

csiph-web