Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Odd behaviour
10 views
Skip to first unread message
R C Nesbit
Nov 19, 2012, 6:29:58 AM11/19/12
to
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
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
R C Nesbit
Nov 19, 2012, 7:20:04 AM11/19/12
to
R C Nesbit spoke:
As usual, just writing about it clears the brain-block.
--
Rob Pearson
> 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
0 new messages