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

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 日

0 投票

query = sprintf( 'INSERT INTO tbl_OMR_Rp (barcode) VALUES(''%s'')',char(barcode));

その他の回答 (0 件)

カテゴリ

製品

質問済み:

2016 年 4 月 16 日

回答済み:

2016 年 4 月 16 日

Community Treasure Hunt

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

Start Hunting!

Translated by