Hi, Fred-
>With the stupid questions atleast you know that people are using the toolkit.
First there'd have to be a stupid question, and yours wasn't it. :)
> In the SQLExecute example in the help
>
>'Connect to the Database, execute the query and disconnect
>'SqlConnect(), SqlExecute(), SqlDisconnect()
>oConn = SqlConnect(lcConnectionString)
>goView = SqlExecute(oConn, lcSQL, "CustomerList")
>
>goView is the resulting object from the SQLExecute. How should goView be defined? Which object should it be defined as?
There were two glitches in that example. As you found, goView wasn't DIMensioned (was undefined) and oConn's declaration syntax is incorrect. Try the following code and it should work for you.
...
Dim lcConnectionString As String
Dim lcSQL As String
Dim oConn As OleDb.OleDbConnection
Dim goView As Data.DataView
...