Search Results

Hi All, Mysql has a nice function to load a file and insert this in a field in the table.../") & "')" Functions.SQLDB.ExecNonQuery(tmpSQL) :(:(:(:( Full Insert or Update...
link: it can work correct Happy Coding;)...
link: Now I just only use JSQL lib. and disabled the MYSQL, SQL ,SQLCipher lib. then it can work correct,...
link: I am working in B4A not B4J...

Hi, the following code inserts a BLOB: SQL1.ExecNonQuery2("INSERT INTO table2 VALUES..., img2, img3, img4, img5 How can I insert the BLOB into a specific field, say "img3"? Also...
link: For the insert it would be something like this: SQL1.ExecNonQuery2("INSERT INTO table2 (id...
link: Hi, got it sorted with: If result.Tag = "get_partners" Then ...
link: I haven't got any experience with blobs. But if you are transferring data from an mysql blob to...

Wow... How I miss that....
link: You cannot add blobs as B4XTable data. You will need to load the blobs from your database and then...
link: Sorry @Erel you correct. The error is at line 85 at the attached code...
link: Hi I try to load blob images into b4xtable cells I use that code but it is not working...

https://www.b4x.com/android/forum/pages/results/?query=insert+blob&page=1&prefix=0 Please use forum search...
link: good night, I need an example of how to insert a blob field (picture) in a database SqlLite...

You're welcome. No, that's not me: when I was a child, I was much more irascible :mad: :D...
link: than a single blob insertion example. Do not take it bad, but I use only code that I fully...
link: I've attached a sample project. (it would be better to use a class for each table, instead of a...
link: #4 modified...

)) InsertBlob 'stores an image in the database. ReadBlob 'load the image from the database... background. Sub InsertBlob Dim Buffer() As Byte = File.ReadBytes(File.DirAssets, "smiley...) End If CreateTables FillSimpleData LogTable1 InsertManyRows Log("Number...
link: Hi Erel, is there a size limit for the image using InsertBlob function ?...
link: qui, piuttosto avanti nel thread, si chiama InsertBlob. https://www.b4x.com/android/forum/threads/sql...

If you are using @DonManfred's library, then look into the PreparedStatement, SetPreparedBlob, and ExecutePreparedStatement methods. If you have any issues with that, you'll need to have some...
link: Yes, but this code: query="INSERT INTO pics (pictures) VALUES(?)" db.ExecuteNonQuery2...
link: be using a prepared statement and ExecuteNonQuery2 to insert the byte array into your database...
link: , but cannot insert into MySQL. I using MYSQL lib and in reading BLOB with : .... Dim upic() AS Byte...

Hi Markus, The image data was already Base64 encoded, so I had to decode it to make it appear in the...
link: blob field instead of the base64 string? u can get the bytes from query by .GetBlob...
link: the JSON result and updates the SQLite database with that data. The SQLite field type is BLOB...
link: Thank you Mahares. I will check it out....

,\ image BLOB) sql.insert_animal=INSERT INTO animals VALUES (null, ?,?) Notes - Running... multiple requests at the same time. The result is a DBResult object. Example of sending an INSERT request: Sub InsertRecord (Name As String) Dim cmd As DBCommand = CreateCommand("insert_animal... For(j) JobDone(j As HttpJob) If j.Success Then Log("Inserted successfully!"... at once. The insert_animal command is defined in the config file: sql.create_table=CREATE TABLE IF...

You should have started a new thread for this question. You cannot run B4J servers in shared hostin...
link: The PHP script doesn't support blobs. You can switch to RDC which does support blobs (and has...
link: Check this thread, post#2 image2bytes and bytes2image https://www.b4x.com/android/forum/threads/b4x...