Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO, VFP DLL and
Message
 
To
07/08/2003 12:26:17
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00817660
Message ID:
00817809
Views:
15
>THanks Terry,
>
>I'm using DreamWeaver MX (Studio MX) to generate the page, then tweaking it.
>
>Here is the code that instanciates the Connection:
>
>Dim Recordset1
>Set Recordset1 = Server.CreateObject("ADODB.Recordset")
>Recordset1.ActiveConnection = MM_RushMaster_STRING
You might try something like this:
IF Recordset1.ActiveConnection.State > 0
   Recordset1.ActiveConnection.Close
ELSE
ENDIF
>Recordset1.Source = "SELECT * FROM seclvl"
>Recordset1.CursorType = 0
>Recordset1.CursorLocation = 2
>Recordset1.LockType = 1
>Recordset1.Open()
>
>I can't find MM_RushMaster_STRING defined anywhere in the page. So is 'Connection' implied with this syntax, or is it implicit, and I just don't see it anywhere? In that case, what syntax would I use to discretely Close the Connection?
>
>Thanks
>
>David
Imagination is more important than knowledge
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform