Android Question Hanging App When Save File To db

[azzam223]

Hello

why When I Save my file (video,audio) To my database Server the app is Hanging ?
I want my app continue working while the file is uploading How Can I Do this?

 

[Erel]

Can you post the code that saves the file?

 

[azzam223]

I use Store procedure with Sql Query To Upload video File To My Db Server

I am sorry The problem is in b4a not b4j Could you please move the Thread To B4a Forum

 

[Erel]

Are you using RDC?

 

[azzam223]

yes I use Rdc

 

[Erel]

Can you post the relevant code?

 

[azzam223]

connection.BeginTransaction
  connection.ExecNonQuery2("insert  Attachments (WCID,ATTFile,Ext,FileName)values(?,?,?,?)",Array As Object(wcid,att.attach,att.ext,att.filename))
                                connection.TransactionSuccessful

att is object i created

when i save image or video or sound with this function the app is hang until the funtion finish

 

[Erel]

You are downloading the file from the remote database and then insert it into the local database, right?

You should use the asynchronous methods. See the batch inserts section: https://www.b4x.com/android/forum/threads/sql-tutorial.6736/#content

 

[azzam223]

No

I add file from my mobile galary And insert into Remote Server

I use Jsql from B4j program To connect To my remote sql server

 

[Erel]

Please start a new thread in the correct forum.

 

[azzam223]

I use b4a program but I copy jsql into b4a library

I do not use b4j program

 

[Erel]

Go over your previous posts. How could we have guess that you are using jSQL with a B4A app? I'm sorry but I cannot further help you.

 

[azzam223]

I am very sorry I think jsql use Rdc because that I say Yes

I cannot put Rdc Server in my site because it's prevent

So I Use Jsql And I copy it into b4a program Because I can with it Connect To my remote sqlServer