Good morning colleagues forum ...
I have an Image already stored in my phone's sqlite as blob field.
I want to remove it and pass it to another database (remote MySQL), but here I read that to remove it had to encrypt it to Base64, then what and when I code my application running. I make this:
How to correct this??
Sorry, my English is not very good
Sorry... this my error...
I have an Image already stored in my phone's sqlite as blob field.
I want to remove it and pass it to another database (remote MySQL), but here I read that to remove it had to encrypt it to Base64, then what and when I code my application running. I make this:
B4X:
Sub Copiar_Local_a_MySQL
Dim GetImagen() As Byte
Dim NombreImagen As String
Dim SU As StringUtils
Dim ImagenCod As Int
CURSOR1=SQL1.ExecQuery("SELECT * FROM Imagen")
For i =0 To CURSOR1.ColumnCount -1
CURSOR1.Position = i
NombreImagen=CURSOR1.GetString("OCR_I")
GetImagen=CURSOR1.GetBlob("FotoEvidnc")
ImagenCod=SU.EncodeBase64(GetImagen)
ExecuteRemoteQuery("INSERT INTO evidenciaext(ORC_I, FotoEvidencia) VALUES ('"& NombreImagen &"', '"& ImagenCod &"')",LISTA_INSPECCION)
Next
End Sub
How to correct this??
Sorry, my English is not very good
Sorry... this my error...
B4X:
LogCat connected to: emulator-5554
** Activity (main) Create, isFirst = true **
** Activity (main) Resume **
80
main_copiar_local_a_mysql (B4A line: 705)
Observacioness=CURSOR1.GetString("Observaciones")
android.database.CursorIndexOutOfBoundsException: Index 8 requested, with a size of 8
at android.database.AbstractCursor.checkPosition(AbstractCursor.java:424)
at android.database.AbstractWindowedCursor.checkPosition(AbstractWindowedCursor.java:136)
at android.database.AbstractWindowedCursor.getString(AbstractWindowedCursor.java:50)
at anywheresoftware.b4a.sql.SQL$CursorWrapper.GetString(SQL.java:355)
at b4a.example.main._copiar_local_a_mysql(main.java:1638)
at b4a.example.main._btnguardarinfo_click(main.java:1308)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:525)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:169)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:157)
at anywheresoftware.b4a.BA.raiseEvent(BA.java:153)
at anywheresoftware.b4a.objects.ViewWrapper$1.onClick(ViewWrapper.java:63)
at android.view.View.performClick(View.java:4240)
at android.view.View$PerformClick.run(View.java:17721)
at android.os.Handler.handleCallback(Handler.java:730)
at android.os.Handler.dispatchMessage(Handler.java:92)
at android.os.Looper.loop(Looper.java:137)
at android.app.ActivityThread.main(ActivityThread.java:5103)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:525)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:737)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:553)
at dalvik.system.NativeStart.main(Native Method)
startService: class anywheresoftware.b4a.samples.httputils2.httputils2service
startService: class anywheresoftware.b4a.samples.httputils2.httputils2service
startService: class anywheresoftware.b4a.samples.httputils2.httputils2service
startService: class anywheresoftware.b4a.samples.httputils2.httputils2service
startService: class anywheresoftware.b4a.samples.httputils2.httputils2service
startService: class anywheresoftware.b4a.samples.httputils2.httputils2service
startService: class anywheresoftware.b4a.samples.httputils2.httputils2service
startService: class anywheresoftware.b4a.samples.httputils2.httputils2service
sending message to waiting queue of uninitialized activity (submitjob)
sending message to waiting queue of uninitialized activity (submitjob)
sending message to waiting queue of uninitialized activity (submitjob)
sending message to waiting queue of uninitialized activity (submitjob)
sending message to waiting queue of uninitialized activity (submitjob)
sending message to waiting queue of uninitialized activity (submitjob)
sending message to waiting queue of uninitialized activity (submitjob)
sending message to waiting queue of uninitialized activity (submitjob)
** Service (httputils2service) Create **
** Service (httputils2service) Start **
** Service (httputils2service) Start **
** Service (httputils2service) Start **
** Service (httputils2service) Start **
** Service (httputils2service) Start **
** Service (httputils2service) Start **
** Service (httputils2service) Start **
** Service (httputils2service) Start **
** Activity (main) Create, isFirst = true **
** Activity (main) Resume **
main_copiar_local_a_mysql (B4A line: 738)
ImagenCod=SU.EncodeBase64(GetImagen)
java.lang.NumberFormatException: Invalid hex double:/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAIBAQEBAQIBAQECAgICAgQDAgICAgUEBAMEBgUGBgYFBgYGBwkIBgcJBwYGCAsICQoKCgoKBggLDAsKDAkKCgr/2wBDAQICAgICAgUDAwUKBwYHCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgr/wAARCAHgAoADASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD8H6KKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooA/RD/h0f+zV/0PHjf/wY2f8A8iUf8Oj/ANmr/oePG/8A4MbP/wCRK+pKKAPkD4i/sj/DT9g/wVe/tX/CDXNb1HxD4W8v+z7PxHcQzWUn2mRbOTzEhiic4jncrh1wwUnIBB8t/wCHuH7Sv/Qj+CP/AAXXn/yXX1J/wUZ/5Ms8Y/8AcO/9ONtX5cUAfUf/AA9w/aV/6EfwR/4Lrz/5Lo/4e4ftK/8AQj+CP/Bdef8AyXXy5RQB9R/8PcP2lf8AoR/BH/guvP8A5Lo/4e4ftK/9CP4I/wDBdef/ACXXy5RQB9R/8PcP2lf+hH8Ef+C68/8Akuj/AIe4ftK/9CP4I/8ABdef/JdfLlFAH1/8N/2uPiV+3h40s/2UPi9oeiad4e8U+Z/aF54ctpob2P7NG95H5bzSyoMyW6Bso2VLAYJBHqP/AA6P/Zq/6Hjxv/4MbP8A+RK+XP8AgnJ/yel4P/7iP/pvua/UegD5b/4dH/s1f9Dx43/8GNn/APIlH/Do/wDZq/6Hjxv/AODGz/8AkSvqSigD5b/4dH/s1f8AQ8eN/wDwY2f/AMiUf8Oj/wBmr/oePG//AIMbP/5Er6kooA+W/wDh0f8As1f9Dx43/wDBjZ//ACJR/wAOj/2av+h48b/+DGz/APkSvqSigD5A+Iv7I/w0/YP8FXv7V/wg1zW9R8Q+FvL/ALPs/EdxDNZSfaZFs5PMSGKJziOdyuHXDBScgEHy3/h7h+0r/wBCP4I/8F15/wDJdfUn/BRn/kyzxj/3Dv8A0421flxQB9R/8PcP2lf+hH8Ef+C68/8Akuj/AIe4ftK/9CP4I/8ABdef/JdfLlFAH1H/AMPcP2lf+hH8Ef8AguvP/kuj/h7h+0r/ANCP4I/8F15/8l18uUUAfUf/AA9w/aV/6EfwR/4Lrz/5Lo/4e4ftK/8AQj+CP/Bdef8AyXXy5RQB9f8Aw3/a4+JX7eHjSz/ZQ+L2h6Jp3h7xT5n9oXnhy2mhvY/s0b3kflvNLKgzJboGyjZUsBgkEeo/8Oj/ANmr/oePG/8A4MbP/wCRK+XP+Ccn/J6Xg/8A7iP/AKb7mv1HoA+W/wDh0f
Message longer than Log limit (4000). Message was truncated.
Last edited: