When using the SQL Explorer and trying to execute a SELECT query for a column name containing the word create (ie., create_date) the query fails with a message of, "(-1) rows affected." Executing the same query in a task simply returns no output.

Example:

This query fails:



This query works:



Is there any way I can work around this issue when I need to do a named select from a database table that has a column with that name? I've already tried using an alias that doesn't contain the word "create" but the query still fails.

As an example, something like this doesn't work:



Any other ideas?

you could create a stored procedure then run that instead of the query. Regardless of what column names or words appear in the stored proc it gets run on the sql server and not through VC.

You could use task 1 to update your stored proc then task 2 to run it. Really you would not "see" a difference in how you use VC. You would just have two tasks instead of one.

The sql output can be tricky sometimes.

Output for me looks blank until I open it

Line #1 is typically blank

When using the SQL Explorer and trying to execute a SELECT query for a column name containing the word create (ie., create_date) the query fails with a message of, "(-1) rows affected." Executing the same query in a task simply returns no output.

Example:

This query fails:

select 'test' as create_date

This query works:

select 'test' as creation_date

Is there any way I can work around this issue when I need to do a named select from a database table that has a column with that name? I've already tried using an alias that doesn't contain the word "create" but the query still fails.

As an example, something like this doesn't work:

select
    create_date as creation_date
from my_table

Any other ideas?

Hi John,

Are you still having an issue with this or did Joeys suggestion work out for you?

---