Hey ya’ll,
I saw some other posts similar to this, but I wasn’t sure it was the same problem.
I’m trying to do an upload file using T-SQL FILESTREAM and I seem to be moving forward, but I encountered a problem when programming the “On file Upload” script on the upload file component.
I initially tried using the “system.db.runQuery” function and it was working, but it was giving an error complaining about no sets being returned. Then I tried the runUpdateQuery and it didn’t work, and then I tried runPrepQuery and it didn’t work. I noticed the errors it was giving me referred to the runQuery even though I had “saved” the changes.The only way I could get it to work was by adding a completely new upload component and putting the latest script using runPrepQuery from the getgo. Then it worked with no problems. The other component still runs the old script even if the new one is saved.Maybe it’s a bug?
I’m running Ignition 8.0.4.