Aleksandr Molchanov

Hi Lukasz,If you are referring to the recursive With in SQLite, we have not received any reports regarding the highlighting within the recursive expression. We tested some examples taken from https...

1. Community
2. General Discussion
3. SQL syntax highlighting is not working "with"

• 0 votes

I may assume this could be the case where the other patterns overlap each other. Please see the solution in this comment and let me know if it works https://youtrack.jetbrains.com/issue/DBE-2068...

1. Community
2. General Discussion
3. Running C# SQL String with a parameter causes [S0002][137] Must declare the scalar variable

• 0 votes

Hi, Please highlight the piece of code and try to inject it as SQL. See if this works.

1. Community
2. General Discussion
3. Rider on window cannot recognize sql dialect

• 0 votes

Hi Dave, I don't have a pg 9.3 data source, but it should be easy to spot if the built-in function is present in Database Explorer. You'd expect it to be listed under pg_catalog schema, so please e...

1. Community
2. General Discussion
3. Unknown database function 'date'

• 0 votes

Hi Rex, File types can't be added unless they are listed in one of the extensions we support in File | Settings | Editor | File Types However, you can highlight the code fragments of SQL and inje...

1. Community
2. General Discussion
3. Handlebars and SQL syntax highlighting?

• 0 votes

Hi Christian,Formatting of join conditions on new lines intended is currently listed as feature request:https://youtrack.jetbrains.com/issue/DBE-17971/Format-JOIN-conditionThe closest you can get t...

1. Community
2. General Discussion
3. Alignment of columns in ON-clauses when having multiple conditions

• 1 vote

Thanks for breaking this down. Unfortunately, we can't pass value variables through parameters. In case of parameters, it can be only a value you enter from the prompt, but not a variable with a v...

1. Community
2. General Discussion
3. Running C# SQL String with a parameter causes [S0002][137] Must declare the scalar variable

• 0 votes

If you're just declaring the @UserEmail and initiating this variable during the execution, you can use the expression by enclosing the variable name in quotes -> where id=:'@UserEmail' Or do you w...

1. Community
2. General Discussion
3. Running C# SQL String with a parameter causes [S0002][137] Must declare the scalar variable

• 0 votes

We have user parameters section in File | Settings | Database | Query Execution | User Parameters You can trigger a parameter prompt: where user = :'id'. You can add the value from the prompt

1. Community
2. General Discussion
3. Running C# SQL String with a parameter causes [S0002][137] Must declare the scalar variable

• 0 votes

Hi, Based on the error message, it looks like that variable is beyond the scope when it's being executed. May I know how and in which code portion you initialized / declared your variable? Also, n...

1. Community
2. General Discussion
3. Running C# SQL String with a parameter causes [S0002][137] Must declare the scalar variable

• 0 votes