How can i execute query with charachter condition with database toolbox R2011b

1 次查看（过去 30 天）
yasser
yasser 2014-9-7
评论： yasser 2014-9-8
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.

请先登录，再回答此问题。

采纳的回答

Geoff Hayes
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!

Translated by