Hello all. Branching into some SQL and I've run into something strange. My program compiles a list of databases located in a custom directory and then loads one of these databases based on the file name. However, the temporary database I use does not initialize off of the selected list position:
It generates an error when trying to initialize the SQL off of the TEMPFileName, but if I input the exact file, "MyDatabase.db", it loads just fine, even though the TEMPFileName is the same string. What am I missing here?
B4X:
Dim DBDetected as List
Dim TEMPFileName as String
Dim TEMPModule as SQL
Dim i as Int=1
TEMPFileName=DBDetected.Get(i)
TEMPModule.Initialize(File.DirRootExternal, TEMPFileName, False)It generates an error when trying to initialize the SQL off of the TEMPFileName, but if I input the exact file, "MyDatabase.db", it loads just fine, even though the TEMPFileName is the same string. What am I missing here?