I`m trying to transfer some pictures from a Blob column from a SQLite Database into the new MySQL Database Blob column but it seems that no matter what i do it still does not work properly and in the end i cannot see the picture in my app.
Any ideas ?
So far what i did the only way that i get something inside the MySQL Database is :
dim recSet As RecordSet // this is the recordset that is fetching the data from the SQLite Database
Dim rec As RecordSet
rec.blobColumn("ColumnName") = recSet.Field("picture").NativeValue
SQLServer.InsertRecord(TableName, rec)
So far here i get some weird data starting with PPIC but in the app when i look i cannot see the picture.
Hello Guys, recently i tried to copy the data from the sqlite to the mysql server but no luck , i managed to replace Christians method with direct code but unfortunately it does not work properly . maybe im doing it wrong , any help is welcomed.
So in both cases i have the pictures columns as Blob
In the RecordSet while i update the record i set it like
rsp.Field("pict").PictureValue = thumb where thumb is a picture and it gets saved, if i create a record i so same way i treat the Blob column as a pictureColumn rec.PictureColumn("pict") = pictureBuffer.resize(128, 128) is that correct ?
If i look into the database and i click on the record specially in mysql mode it shows me the picture which is good, but not in sqlite mode when i do this , it deletes the records and that`s it. so the question is field().PictureValue is available over all the databases or just on Mysql ?