Here is a few more information.
I am working from a copy of Eddie's Electronics Web version that I rework for a test.
The database is a class in the project whose superclass is SQLiteDatabase and name is OrdersDatabase. The object is set from a call to OrdersDatabase.OpenDatabase (modified for my needs):
Dim orders As New OrdersDatabase
orders.DatabaseFile = source
If Not orders.Connect Then
msg = "Could not connect to database for this user: " + orders.ErrorMessage
#If TargetDesktop Then
#ElseIf TargetWeb Then
App.AppendToDBErrorLog("DBFile: " + source.NativePath)
The source is a FolderItem set to a SQLiteDatabase file.
In the documentation about Database.SelectSQL (API 2.0):
Database.SelectSQL(SQLStatement as String [,ParamArray values() as Variant]) As RowSet
Database.SelectSQL(SQLStatement as String [,values() as Variant]) As RowSet
Those are the two signatures for the method, see the square brackets, compare to what I get in the IDE:
(14, 26) Database.SelectSQL(sql As String, values() As Variant) As RowSet
In the IDE values as Variant is not optional, and my guess is where the issue is from.
@Paul L What are your thoughts about my issue ?