working with version 2019r3.1, this code is giving me a hard time
[code]Var rs As RowSet
Var i As Integer = 1
Var Mid As Integer
Var Qry As String = “SELECT * FROM Suppliers ORDER ASC BY LastName”
rs = OrdersDatabase.SelectSQL(“SELECT * FROM Suppliers ORDER ASC BY LastName”)[/code]
SelectSQL don’t compile, throwing this error
SetEmailsAdds.YesButton.Action, line 14
There is more than one method with this name but this does not match any of the available signatures.
rs = OrdersDatabase.SelectSQL("SELECT * FROM Suppliers ORDER ASC BY LastName")
The documentation states that the second parameter is optional, but the compiler acts as its mandatory, this is what I get at the bottom when the cursor its over ExecuteSQL:
(14, 26) Database.SelectSQL(sql As String, values() As Variant) As RowSet
Then is it a bug, a code 16 or what else ?