I am developing a B4A SQLite database project which is being used to process service records in the field. At the end of the job a customer signature is collected, canvas data is passed to a buffer array and inserted into the SQLite database as a blob field along with the text fields which are passed as strings. This all works fine and the data and signature can be read using SQLite viewer.
The next stage of the program needs to pass the data to an online MySQL database. I am using the 'ExecuteRemoteQuery' routine provided in Erels MySQL database example i.e.:
ExecuteRemoteQuery("UPDATE NetService SET SiteNameAddress='" & m.GetValueAt(7) & "',RecordMode='" & m.GetValueAt(15)& "',Signature='" & Array As Object(Buffer) & "',DateIn='" & m.GetValueAt(18) & "',DateOut='" & m.GetValueAt(19) & "' WHERE ServiceID = '" & SID & "'", 7 )
(The signature is being passed using the Array As Object(Buffer)). The code passes text fields over perfectly but I am not convinced that the blob field is being properly transferred. The field appears in MySQL as something like [BLOB - 28B]. If this is downloaded it is a 4kb file which seems to consist of about 11 letters and the rest is blank space. Clearly either the blob has not transferred correctly or I have misunderstood something. Does MySQL accept a blob field transferred from SQLite in this way or should I be encoding it somehow (in which case could you show me how?).
:sign0104: