How can i execute query with charachter condition with database toolbox R2011b
조회 수: 1 (최근 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!