Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExecute and resulting Object
Message
From
22/05/2002 22:12:11
 
 
General information
Forum:
ASP.NET
Category:
Visual FoxPro Toolkit for .NET
Miscellaneous
Thread ID:
00659391
Message ID:
00660246
Views:
11
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
Previous
Reply
Map
View

Click here to load this message in the networking platform