hi, i have a problem now and i think many people like me! please help, i tried to solve it but i can't
2 次查看(过去 30 天)
显示 更早的评论
i have a code below:
...
i = curs.Data{1}
update(connA, 'inputtb', {'Timeout'}, {'out'}, 'where ID = i')
...
in my project, ''i'' isn't constant. Because every time I find ID in my database, it return a new curs.Data{1} so I want ''i'' were a variable. Any time it return curs.Data{1}, the code update (below) will be execute, and ''i'' was imported value from curs.Data{1}. The problem is in whereclause, it seem like we can't put one variable into place ''i'' above!
0 个评论
回答(2 个)
Image Analyst
2013-5-1
Try making it a string with the number embedded with sprintf():
theQuery = sprintf('where ID = %d', i);
curs.Data{1} update(connA, 'inputtb', {'Timeout'}, {'out'}, theQuery)
By the way, having many people "like" you is not a problem - it's great. You have many friends. Better than have many people hate you. :-)
0 个评论
hoang
2013-5-2
4 个评论
Image Analyst
2013-5-3
I'm not sure what you're asking. What's your code for using the update() function? Actually I haven't used MATLAB with databases, so I'm not going to be any help.
另请参阅
类别
在 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!