Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLExecute and resulting Object
Message
De
22/05/2002 21:53:34
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
 
 
À
21/05/2002 10:53:35
Information générale
Forum:
ASP.NET
Catégorie:
Visual FoxPro Toolkit pour .NET
Divers
Thread ID:
00659391
Message ID:
00660243
Vues:
12
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.
...
    'Establish a connection and a command 
    Dim lcConnectionString As String
    Dim lcSQL As String
    Dim oConn As OleDb.OleDbConnection
    Dim goView As Data.DataView
...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform