Hi everyone!
I'm trying to retrieve some data from a database's table in a spinner whose field is of type "enum" with the values 'A', 'I' and I use a list and a foreach iteration inside a Job to do it, but I get an error "Invalid Double"?? it's a string what I'm trying to retrieve from the database and I don't understand what I'm doing wrong. Thank you very much.
Here's my code:
	
	
	
	
	
	
	
		
			
			
			
			
			
		
	
	
	
		
	
	
		
	
The Map Log:
	
	
	
	
	
	
	
		
			
			
			
			
			
		
	
	
	
		
	
	
		
	
the Error Log:
	
	
	
	
	
	
	
		
			
			
			
			
			
		
	
	
	
		
	
	
		
	
			
			I'm trying to retrieve some data from a database's table in a spinner whose field is of type "enum" with the values 'A', 'I' and I use a list and a foreach iteration inside a Job to do it, but I get an error "Invalid Double"?? it's a string what I'm trying to retrieve from the database and I don't understand what I'm doing wrong. Thank you very much.
Here's my code:
			
				JobDone:
			
		
		
		Case  EDITARXREGISTRO
                Dim ListEdicion As List
                ListEdicion.Initialize
                ListEdicion = parser.NextArray
                For i = 0 To ListEdicion.Size - 1
                 
                    Dim MapaListEdit As Map
                                 
                    MapaListEdit = ListEdicion.Get(i)
                    Log(MapaListEdit)
                 
                Next
             
                For Each colroot As Map In ListEdicion
                 
                    Dim clave As String = colroot.Get("ID")
                    Dim nombre As String = colroot.Get("NOMBRE")
                    Dim estado As String = colroot.Get("ESTADO")
                 
                    Log(clave)
                    Log(nombre)
                    Log(estado)
                 
                
                    txtNombre.Text = nombre
                    spEstado.GetItem(estado)The Map Log:
			
				B4X:
			
		
		
		(MyMap) {ID=2, NOMBRE=MARZO-ABRIL, ESTADO=A}the Error Log:
			
				B4X:
			
		
		
		Error occurred on line: 131 (CAMP)
java.lang.NumberFormatException: Invalid double: "A"
    at java.lang.StringToReal.invalidReal(StringToReal.java:63)
    at java.lang.StringToReal.initialParse(StringToReal.java:164)
    at java.lang.StringToReal.parseDouble(StringToReal.java:282)
    at java.lang.Double.parseDouble(Double.java:301)
    at anywheresoftware.b4a.debug.RDebugUtils.numberCast(RDebugUtils.java:58)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:348)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA$2.run(BA.java:370)
    at android.os.Handler.handleCallback(Handler.java:739)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:148)
    at android.app.ActivityThread.main(ActivityThread.java:7406)
    at java.lang.reflect.Method.invoke(Native Method)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1230)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1120)
			
				Last edited: 
			
		
	
								
								
									
	
								
							
							 
				 
 
		 
 
		 
 
		 
 
		 
 
		 
 
		