Multi line Select Query

  • Thread starter Thread starter madhan
  • Start date Start date
M

madhan

Hi,

I have a problem i have a select statement which is about 20 od
lines and i'm trying to retrive data from the database but the proble
is that it gives me a error. can anyone tell me how to link a multilin
select statement into one in VB.

thank
 
If it is more than 255 characters in length, you need to break the parts of
it into an array. Use the macro recorder to do an msquery query (Data=>Get
External Data) using a similar long query string and you will see how the
array is constructed.
 
A SQL statement is a single string. If it has contains line breaks
then these will be for ease of reading by a human. If you are putting
line breaks into code to make it easier to read, ensure you include
spaces between words e.g.

strSql = "SELECT Col1, Col2" & _
"FROM MyTable" ' <-error

strSql = "SELECT Col1, Col2" & _
" FROM MyTable" ' <-correct

If by multi-line you mean 20 SQL statements e.g. separated by
semicolons, you will need to send each statement one by one, but you
could do this in a batch so the RDBMS can optimize execution.
 
Tom is correct about the break apart.
Two solutions I have found helpful...
Put sections of Query string into a Dim Qry_1, Qry_2 AS
String variable... The add/concatenate the two strings
together when building the query statement...

The second thing to do is put the concatenated String
value into a Cell comment. The you can look at it and
debug it ...

(e-mail address removed)
 
Back
Top