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

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

Odd behaviour

Show all headers | View raw

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

Back to comp.lang.basic.visual.misc | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

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

csiph-web