SQL editor error

[Mgstoly]

I am trying to run this script but I get this error,  just not sure how to fix it.

[RolandSchubert]

Hi @Mgstoly ,

you could try to remove the commented line. If this doesn't fix the problem: it seems to be an Oracle database. How do you connect (ODBC, OCI, ...)?

Best,

Roland

[Greg_Murray · Accepted solution]

Try running the workflow. You can usually get a little more information about the error from the results window. Copy the red error message and drop it into notepad then scroll to the end. 

Also take a look at this post:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/SQL-error-that-I-only-get-in-Alteryx/t...

[Mgstoly]

I connect via OCI,  I have other scripts that run just fine.  what do you mean by the commented line?

[Mgstoly]

so I added a space after select and From and it worked.  thanks!

[Mgstoly]

I added a space after select and from and it ran.