Oracle query in Visual Web Developer 2005

[jcs1953]

This is part of a query that runs fine in Oracle.
SELECT TESTS.TEST_NAME "Test",RESULTS.RESULT_NUMERIC "Results" ,REQ_PANELS.RUN_DATE "Date"........

In Visual Web Developer it's
Dim ocmdSelect As New OracleCommand("SELECT TESTS.TEST_NAME "Test",RESULTS.RESULT_NUMERIC "Results,REQ_PANELS.RUN_DATE "Date" .....

And of course this doesn't work because of the ". I've tried ' and () and everything else I can think of. I even tried REQ_PANELS.RUN_DATE As Date but Date can't be used this way.

Any suggestions on how to solve this?

 

[jbenson001]

The whole command has to be wrapped in ":
ie: "Select .... "

If there are quotes that need to be inside of the Outer quotes then either use single quotes (') or 2 double quotes("")

Something like:
Dim ocmdSelect As New OracleCommand("SELECT TESTS.TEST_NAME ""Test"", ...

 

[jcs1953]

The double quotes worked great. Thanks for your help!

 

[jbenson001]

Cool, glad to help