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

2 vues (au cours des 30 derniers jours)
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 commentaire
Usama Arshad
Usama Arshad le 16 Avr 2016
i find out the solution just need to change a line in
query = sprintf( 'INSERT INTO tbl_OMR_Rp (barcode) VALUES(''%s'')',char(barcode));

Connectez-vous pour commenter.

Réponse acceptée

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

Plus de réponses (0)

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by