Recent

Author Topic: Progress of a BLOB being uploaded to a MySQL database  (Read 3202 times)

Wrathzn

  • Newbie
  • Posts: 4
Progress of a BLOB being uploaded to a MySQL database
« on: July 18, 2014, 02:09:07 pm »
Hello fellow programmers,

I am busy programming a database application that requires documents to be uploaded and downloaded
as supporting documents to and from client tables,
I have successfully created such an upload and download BLOB field however have found the upload process can take some time,
and thus would like to create a progress bar,
I have no idea how to find the current status of the

dmoUbuntu.quePdf.ParamByName('content').LoadFromFile(OpenDialog1.FileName, ftBlob); 

query as it is being executed and commited.

I have searched everywhere for an answer to the above problem,
but have been unable to find one anywhere,
Also I cannot locate any examples of SQL progress bars within the Lazarus IDE or from any source it seems,

Thank you
I know that I have come to the right place for an answer to this irritation  :D

engkin

  • Hero Member
  • *****
  • Posts: 3112
Re: Progress of a BLOB being uploaded to a MySQL database
« Reply #1 on: July 18, 2014, 03:21:49 pm »
Use LoadFromStream instead and provide your own custom stream with a progress event.

Wrathzn

  • Newbie
  • Posts: 4
Re: Progress of a BLOB being uploaded to a MySQL database
« Reply #2 on: July 20, 2014, 11:04:20 pm »
So Simple,  8)
Thank you very much engkin

cpalx

  • Hero Member
  • *****
  • Posts: 754
Re: Progress of a BLOB being uploaded to a MySQL database
« Reply #3 on: July 21, 2014, 01:54:51 pm »
I dont grt it. How will you do it? Can you post the code please

 

TinyPortal © 2005-2018