c# - Data type mismatch in criteria expression exception -

-

when run code gives me mismatch criteria exception"

enter image description here

enter image description here

remove quotes amounts , category_id

"update products set amount=" + amount1 + " category_id=" + temp;

this build correct sql string.

btw encourage use query parameters queries https://msdn.microsoft.com/it-it/library/system.data.oledb.oledbcommand.parameters(v=vs.110).aspx


Comments

Post a Comment

Popular posts from this blog

mysql - FireDac error 314 - but DLLs are in program directory -

-
i getting when trying access mysql database : [firedac][phys][mysql]-314. cannot load vendor library [libmysql.dll or libmysqlld.dll] this did not happen (unchanged) code, however, have upgraded windows 10 , had reinstall delphi xe8, system configuration matter. in order try solve problem, copied both of files c:\windows\sysytem32. when did not seem work, copied them \win32\debug, generated .exe resides. i imagine doing rather stupid, can't see what. the proper solution place driver file (eg., libmysql.dll ) in application's folder, or place installation location in fddrivers.ini file: [mysql] vendor=<folder>\libmysql.dll (recent versions of documentation seem use vendorlib instead of vendor in ini file.) see rad studio documentation topics configuring drivers (firedac) , connect mysql server (firedac) more information.
Read more

python - How to read gradle build progress from it's output? -

-
i execute gradle python subprocess: proc = subprocess.popen(["./gradlew", "assemble", stdout=subprocess.pipe, stderr=subprocess.pipe, ) then run 2 threads read stdout , stderr: class mythread(qtcore.qthread): def run(self): while true: line = self.stream.readline() if line not none , len(line) > 0: // process line else: break i read log correct, can't read output like: > building 53% > :project:assemble i tried replace readline read , not helped. if execute: ./gradlew assemble | hd i not see build progress in hd . is solution read progress?
Read more

c# - How do I debug "System.DllNotFoundException: The specified procedure could not be found"? -

-
i've got pinvoke wrapper set native dll, time try invoke it, crashes, saying system.dllnotfoundexception: specified procedure not found . things i've checked: the dll in same folder exe. dependency walker shows dll has 1 non-system dll dependency, , it's loaded (successfully) process point. it gives same error no matter function try call into, including dummy function no body. (so points 1 , 3 answer here not apply.) i've used dependency walker ensure functions being exported, same names, including case sensitivity. by point, i'm @ wits' end. how can debug , figure out what's going wrong? error message i'm getting spectacular pile of fail when comes usefulness; doesn't tell me name of procedure can't find. i'd debug first in native application. reasons explain later. put simple console app in same directory c# executable. have console app call loadlibrary , getprocaddress on dll p/invoking. same error occur? ...
Read more