Dim b() As Byte
For i=i0 To i1
b(y)=lstFinish.Get(i)
y=y+1
Next
strQuery = "UPDATE `ZSampl` SET `Sound`= ? WHERE `crc`= ?"
Log(strQuery)
Dim bc As ByteConverter
Main.sqlDB.ExecNonQuery2(strQuery, Array As Object(bc.HexFromBytes(b), CRC))
If the SQLite database Sound column is a BLOB then the first parameter element in the array should just be the Byte Array "b", it should not be a String.
Same as with CakePictureBlob here in the working example that I pointed you to earlier:
Perhaps if you call your Byte Array "
SoundBlob" instead of just "
b", that might make your code more self-explanatory.
Code which "explains itself" naturally and reduces the number of things we need to remember about it, is usually a good thing.
On a related note, your logged hex looks like audio data = at least that everything beforehand is probably working. We are on the home stretch!
(16-bit, mono, little endian, signed, sample rate 20-44 kHz)
View attachment 162479