using workspace variable value in visual query builder?

How can i use the values from workspace variable of matlab program in SQL queries of visual query builder (i.e SELECT * FROM tablename WHERE salary>workspacevariable's value) instead of static values like (WHERE salary>1000)?

1 Comment

productdesc = 'Painting Set';
sqlquery = ['SELECT * FROM productTable ' ...
'WHERE productDescription = ' '''' productdesc ''''];
results = fetch(conn,sqlquery)

Sign in to comment.

Answers (0)

Asked:

on 19 Mar 2017

Commented:

on 28 Aug 2020

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!