How can i execute query with charachter condition with database toolbox R2011b
1 view (last 30 days)
Show older comments
Hello I have problem when i execute query with charachter condation using database toolbox commands but no result output. I write this command sql_age = ['select LINGUSTIC_NAME from METAKNOWLEDGE_DET' ... 'where FIELD_NAME = ' '''AGE''']; select_age = exec (conn,sql_age); q1=fetch(select_age); agelist = q1.data; the output must get some result but no result out.
0 Comments
Accepted Answer
Geoff Hayes
on 7 Sep 2014
Yasser - if I build the same SQL string using your code, then the string becomes
select LINGUSTIC_NAME from METAKNOWLEDGE_DETwhere FIELD_NAME = 'AGE'
Note how there is no space between the table name and the where condition. Try re-creating your SQL command as
sql_age = ['select LINGUSTIC_NAME from METAKNOWLEDGE_DET ' ...
'where FIELD_NAME = ' '''AGE'''];
More Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!