| SQL Query Problem [message #373750] |
Fri, 04 May 2001 06:04 |
Linda
Messages: 22
Registered: July 2000
|
Junior Member |
|
|
I have written a pass-through query in vb to perform the following SQL Query. The results is a continous text string that when I try to run in VB comes up with a "Command not ended properly string". However if I take the string into a text editor and put it into the following layout it works....
INSERT INTO ENGINE_DERATE ( SERIAL_NUMBER, FILENAME, LOG_DATE, ENGINE, AIRCRAFT, FLIGHT_TIME, FLIGHT_NO, MAX_EPR, ACT_EPR, PART_NUMBER, CODE, K_FACTOR )
SELECT ENGINE_DATA.SERIAL_NUMBER, ENGINE_DATA.FILENAME, ENGINE_DATA.LOG_DATE, ENGINE_DATA.ENGINE, Max(ENGINE_DATA.AIRCRAFT) AS MaxOfAIRCRAFT, Max(ENGINE_DATA.FLIGHT_TIME) AS MaxOfFLIGHT_TIME, Max(ENGINE_DATA.FLIGHT_NO) AS MaxOfFLIGHT_NO, Max(ENGINE_DATA.MAX_EPR) AS MaxOfMAX_EPR, Max(ENGINE_DATA.ACT_EPR) AS MaxOfACT_EPR, Max(ENGINE_DATA.PART_NUMBER) AS MaxOfPART_NUMBER, Max(ENGINE_DATA.CODE) AS MaxOfCODE, Max(ENGINE_DATA.K_FACTOR) AS MaxOfK_FACTOR
FROM ENGINE_DATA
GROUP BY ENGINE_DATA.SERIAL_NUMBER, ENGINE_DATA.FILENAME, ENGINE_DATA.LOG_DATE, ENGINE_DATA.ENGINE
ORDER BY ENGINE_DATA.SERIAL_NUMBER, ENGINE_DATA.FILENAME, ENGINE_DATA.LOG_DATE, ENGINE_DATA.ENGINE;
Can anyone explain why it will not run a single text string but is happy split down into smaller lines.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
