Hi,
I have noticed that if I send a result set to a sub, any chages to that Result set is temporary in that sub.
It was normally behaving in B4A 9.80
And many Errors in my application riased since I updated to newer versions:
logs when runing with B4A version 9.80 :
and when compiled with B4A version 9.90 ... ver 11.0
I have noticed that if I send a result set to a sub, any chages to that Result set is temporary in that sub.
It was normally behaving in B4A 9.80
And many Errors in my application riased since I updated to newer versions:
B4X:
Sub Process_Globals
Dim SQL1 As SQL
Dim myCur As ResultSet
End Sub
Sub Globals
'These global variables will be redeclared each time the activity is created.
End Sub
Sub Activity_Create(FirstTime As Boolean)
Activity.LoadLayout("Layout")
End Sub
Sub Activity_Resume
End Sub
Sub Activity_Pause (UserClosed As Boolean)
End Sub
Sub Button1_Click
File.Copy(File.DirAssets,"myData.db",File.DirInternal,"myData.db")
SQL1.Initialize(File.DirInternal,"myData.db",False)
myCur = SQL1.ExecQuery("SELECT * from History")
Log("1 ColumnName(0) = " & myCur.GetColumnName(0))
ChangeCursor(myCur)
Log("2 ColumnName(0) = " & myCur.GetColumnName(0))
End Sub
Sub ChangeCursor(TempCur As ResultSet)
TempCur = SQL1.ExecQuery("SELECT * from Stock")
Log("3 ColumnName(0) = " & TempCur.GetColumnName(0))
End Sub
logs when runing with B4A version 9.80 :
B4X:
** Activity (main) Resume **
1 ColumnName(0) = LastVersion
3 ColumnName(0) = BarcodeValue
2 ColumnName(0) = BarcodeValue
and when compiled with B4A version 9.90 ... ver 11.0
B4X:
** Activity (main) Resume **
1 ColumnName(0) = LastVersion
3 ColumnName(0) = BarcodeValue
2 ColumnName(0) = LastVersion