B4J Question resultset error with sqlite-jdbc-3.7.2

TorontoJim

Member
Licensed User
Longtime User
I'm trying to implement the KVS for the first time. I'm getting this error:

B4X:
Unknown type: resultset
Are you missing a library reference?

(screen shots of all this are attached)

I've read several threads on this and can't see that I'm missing anything. I'm using B4J 4.20.

I've added SQLite to the header of the main script:

B4X:
#Region  Project Attributes 
	#MainFormWidth: 600
	#MainFormHeight: 400 
	#AdditionalJar: sqlite-jdbc-3.7.2
	#AdditionalJar: bcprov-jdk15on-150
#End Region




In the class module "sql1" is red:

B4X:
Public Sub Initialize (Dir As String, FileName As String)
	If [color=red]sql1[/color].IsInitialized Then [color=red]sql1[/color].Close
	[color=red]sql1[/color].InitializeSQLite(Dir, FileName, True)
	CreateTable
End Sub


These are the libraries added. I tried adding jSQL but that didn't solve it.
 

TorontoJim

Member
Licensed User
Longtime User
I realized this wasn't in there, so I added it. Did not affect the error.

B4X:
kvs.Initialize(File.DirApp, "datastore")
 
Upvote 0

TorontoJim

Member
Licensed User
Longtime User
I just added it in. I'm still getting the error that:

B4X:
Undeclared variable sql1 is used before it was assigned any value
 
Upvote 0

TorontoJim

Member
Licensed User
Longtime User
The declaration was commented out in Process_Globals. Thank you. I don't know when I did that, again, PICNIC.
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…