How can i execute query with charachter condition with database toolbox R2011b
3 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Geoff Hayes
2014-9-7
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'''];
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!