SQL Editor Question/ Hotkeys

Hi,

I have connected to a database successfully, and i am now trying to input form the connected database using the input tool and the "choose table or specify query " dialogue box with the option of using the SQL editor. I am specifying the query correctly using the SQL syntax:

SELECT * FROM LIST where USER_NAME="JOHN DOE";

which i know is correct but i guess the editor is not accepting the semicolon instead outputs a colon from my keyboard and so is giving me an error that the command is not ended properly, can someone help me with why this is happening and how do i resolve it?

Tips and Tricks

Accepted answers

myastarling

I can't tell you why that's the case in Alteryx, but the SQL editor does not accept semicolons. Just remove the semicolon and your code should parse just fine.

All comments

myastarling

I can't tell you why that's the case in Alteryx, but the SQL editor does not accept semicolons. Just remove the semicolon and your code should parse just fine.

razzy

Excellent response but i am still having an error of invalid identifier on the message pane even though the query ran, and also how do i save the oracle client downloaded on my c: drive , because its like every time i start the connection i have to delete it and then install again. I have still not got any outputs on the query

razzy

this is the error message it is giving me:

Error: Input Data (1): DataWrapOCI: Unable to prepare the query: "SELECT count(*) FROM PAT_LIST where LIST_ID= " 330686"" Error: ORA-00904: " 330686": invalid identifier

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703