Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi line Select Query
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi line Select Query
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. -- Regards, Tom Ogilvy "madhan " wrote in message ... Hi, I have a problem i have a select statement which is about 20 odd lines and i'm trying to retrive data from the database but the problem is that it gives me a error. can anyone tell me how to link a multiline select statement into one in VB. thanks --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi line Select Query
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. -- madhan wrote in message ... Hi, I have a problem i have a select statement which is about 20 odd lines and i'm trying to retrive data from the database but the problem is that it gives me a error. can anyone tell me how to link a multiline select statement into one in VB. thanks --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to select a multi value from a drop down box | Excel Discussion (Misc queries) | |||
Concatenate: Multi-Line Cell with 2 single line cells | Excel Worksheet Functions | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) | |||
Extract values from a multi-select multi-column list-box | Excel Programming | |||
Multi Select List Box | Excel Programming |