New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Beginner basics for SQLStudio + QTScript #3448

Open
DBJDBJ opened this Issue Oct 31, 2018 · 6 comments

Comments

2 participants
@DBJDBJ

DBJDBJ commented Oct 31, 2018

Hi, great product. Please advise where can I read about total beginner basics for QTScript-ing?
I think I am doing it fine but for some reason, it does not work. I never used SQLiteStudio before. I am trying to make this work:

SELECT word from words where (word == reverse(word))

where reverse() is a QTScript function, seen on the screen dump

I am getting:

[05:24:07] Error while executing SQL query on database 'EN_DICTIONARY': no such function: reverse

SQLStudio version is 3.2.1, OS is WIN10 PRO
Please advise,
Thanks ...

@pawelsalawa

This comment has been minimized.

Owner

pawelsalawa commented Oct 31, 2018

You named your function "function reverse".

Just remove "function " prefix out of the name, keep just "reverse".

@DBJDBJ

This comment has been minimized.

DBJDBJ commented Nov 4, 2018

And it worketh. Grateful as I am I have to say I still have not been able to find an online text which will also ease the burden on you to answer this kind of questions.

For example: if a user clicks on green '+' on a functions editing dialogue, the app puts the word 'function' in the 'Function name' field. Without knowing what I am doing I just added a function name thus producing a typical beginners mistake. Perhaps if you would leave that field empty the number of beginners complaining will be much smaller with the proper introductory text too.

Great App. Kind regards ...

@pawelsalawa

This comment has been minimized.

Owner

pawelsalawa commented Nov 5, 2018

You are absolutely right. This is confusing. I'll change it.

@pawelsalawa pawelsalawa added the bug label Nov 5, 2018

@pawelsalawa pawelsalawa added this to the 3.2.2 milestone Nov 5, 2018

@DBJDBJ

This comment has been minimized.

DBJDBJ commented Nov 5, 2018

Glad to be of service ...

@DBJDBJ

This comment has been minimized.

DBJDBJ commented Nov 5, 2018

Ah, sorry but more ideas are coming in :) How about this?

User clicks on the green '+' and app creates some kind of complete "hello world" script?
With perhaps some useful comments in the code, links and a such?

I might think that will ease the questions about functions, considerably?

Kind regards ...

@pawelsalawa

This comment has been minimized.

Owner

pawelsalawa commented Nov 5, 2018

Good idea. I will incorporate it somehow.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment