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 天）

hoang 2013-5-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/74202-hi-i-have-a-problem-now-and-i-think-many-people-like-me-please-help-i-tried-to-solve-it-but-i-can

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更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

回答（2 个）

Image Analyst 2013-5-1

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/74202-hi-i-have-a-problem-now-and-i-think-many-people-like-me-please-help-i-tried-to-solve-it-but-i-can#answer_84045

在 MATLAB Online 中打开

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

hoang 2013-5-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/74202-hi-i-have-a-problem-now-and-i-think-many-people-like-me-please-help-i-tried-to-solve-it-but-i-can#answer_84144

I mean many people has the same problem like me.(my english is bad ^^)

thank for suggestion, i tried but it doesn't work.

I want to update my datable table in MS ACCESS with a specific row was a variable, not constant. I had defined the ODBC data resource with Matlab database toolbox.

example, in image below, i want to update row ID 5, Timeout from ''in'' to ''out'' but not use the code: update(connA, 'inputtb', {'Timeout'}, {'out'}, where ID = 5')

4 个评论
显示 2更早的评论隐藏 2更早的评论

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.

hoang 2013-5-4