Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLExecute and resulting Object
Message
De
22/05/2002 22:12:11
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
 
 
À
22/05/2002 12:06:26
Information générale
Forum:
ASP.NET
Catégorie:
Visual FoxPro Toolkit pour .NET
Divers
Thread ID:
00659391
Message ID:
00660246
Vues:
17
Fred,

>I'm still having some problems. Is there an error object that I can look at to see
> the exact error?

As Kamal mentioned, you can use Try and Catch to catch errors, but in this case the IDE itself will help you out and combine that with a little dumb luck (in my case) and you're all set.

Basically, the IDE showed a blue squiggly under goView and the tooltip told me it variable wasn't declared. So, I put my cursor over the SQLExecute() function, which told me what type of variable the function returned ("System.Data.DataView"). So, I knew to do
Dim goView As Data.DataView
Since I have
Imports System.Data
in my class, I could just leave off the "Data." in the DIM statement.

For oConn, there is no error if you have the following Imports statement:
Imports System.Data.OleDb
If you don't included the Imports then the DIM needs to be:
Dim oConn As OleDb.OleDbConnection
The way I figured that last one out was again using the tooltip over the SqlDisConnect(oConn) statement to see what sort of parameter SqlDisConnect() was expecting.

HTH
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform