How to use the Input Dialog to execute SQL queries

Question

Is it possible to use the inputdlgfunction to execute an SQL query such as below :

    pdbSearchQuery = input('Enter your PDB Code: ', 's');
    curs = fetch(exec(conn, ['SELECT * FROM cath_2_wo_dup WHERE pdbcode = ' '''' pdbSearchQuery '''']));
    pdbSearchResults = curs.Data

I manage to do this by default, using the Command Window to search for columns in a database, but i would like to create a dialog box where users can type in a value to search the database, using the variables i have stated above.

It would look like this at the end:

Search bar to search for n column from the database table

When they click 'OK', it would lead that button to execute another script where it will create the tables and figures for them.

Is this possible to do in inputdlg or is there another function that does this similar method?

macduff · Accepted Answer · 2012-02-23 18:38:57Z

1

This is absolutely possible and will give you a lot of freedom in your code. For example, modified from the inputdlg help:

prompt = {'Enter table name:','Enter query field:'};
dlg_title = 'Input for query';
num_lines = 1;
def = {'mytable','thatProperty'};
answer = inputdlg(prompt,dlg_title,num_lines,def);
curs = fetch(exec(conn, ['SELECT * FROM ' char(answer{1}) ' WHERE ' char(answer{1}) '= ' '''' pdbSearchQuery '''']));

Should work well. Hope this helps!

answered Feb 23, 2012 at 18:38

macduff

4,67520 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jeiman Over a year ago

I changed a few names and variables around and i manage to retrieve columns from the database. However, when i ran this code as a script and type in a value in the input field and hit 'OK', MATLAB crashes. Could it be that it can't handle the number of scripts i am executing after the dialog window? I tried not executing anything, it still crashes. Please advise.

macduff Over a year ago

@Jeiman, I think it's likely the exec or fetch crashing, do you have multiple database connections at once? Also, when you say "not executing anything", you mean not executing any m-script after the call to the dialog box?

Jeiman Over a year ago

My apologies, i called out my other scripts too early before another script could take place. It's fixed now and working properly. Thank you very much for the explanation and solution.

Collectives™ on Stack Overflow

How to use the Input Dialog to execute SQL queries

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related