Error using sprintf Function is not defined for 'System.String' inputs.

2 次查看（过去 30 天）
Usama Arshad
Usama Arshad 2016-4-16
回答： Usama Arshad 2016-4-16
filepath = 'D:\OMR_Images\barcode images\060.jpg';
NET.addAssembly('D:\MATLAB Projects\OMR\Barcode Bisegrw.dll');
barcode = Barcode_Bisegrw.Class1.StaticMethod(filepath);
conn = database('OMR','','','Vendor','Microsoft SQL Server','Server','localhost','AuthType','Windows','portnumber',1433);
query = sprintf( 'INSERT INTO tbl_OMR_Rp (barcode) VALUES(''%s'')',barcode);
curs = exec(conn,query );
close(curs);
close(conn);
The variable "barcode" is setting 1x1 System.String in workspace. and its showing correct value in Command Window but i need to send its value into database and its value is like 0 04 461248863 0
  1 个评论
Usama Arshad
Usama Arshad 2016-4-16
i find out the solution just need to change a line in
query = sprintf( 'INSERT INTO tbl_OMR_Rp (barcode) VALUES(''%s'')',char(barcode));

请先登录，再进行评论。

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

采纳的回答

Usama Arshad
Usama Arshad 2016-4-16
query = sprintf( 'INSERT INTO tbl_OMR_Rp (barcode) VALUES(''%s'')',char(barcode));

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 .NET Data Types in MATLAB 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by