View Single Post
  #9 (permalink)  
Old 07-23-08, 07:11
abp abp is offline
Registered User
 
Join Date: Jul 2008
Posts: 7
Well, thanks for your honesty!

Here's the reason for the query formatting:

The query is in a scanning loop against a list of various tables. Therefore, the tablename is variable, as also the query contains variables within the various fields. And then all is read into the query before execution:

sQuery = q1 + q2 + q3 + q4 + q5 + q6 + q7 + q8 + q9 + q10 + q11 + q12 + q13 + q14

q.readFromString(sQuery)

If memory serves, the passing of variables thru a query could be handled easily with a ~, but not the tablename....thus the readFromString....
Reply With Quote