After looking at your posts, talking with an associate, and looking at the code base I am using, I have decided to do the following.
-------------------
local objects
If Not MyObject Is Nothing Then
MyObject.Shutdown
Set MyObject = Nothing
End If
-------------------
Global /...
OK, in my example, I pass the LeafObject myLeaf out of the function.
Is it safe to set myLeaf to nothing before exiting the function?
--------------------------
In the calling sub, let's say I have. . .
set gobjNewLeaf = getLeaf()
Since it is a global, where do I set it to nothing...
I have inherited an app that has 25 classes in 6 dlls.
I have a memory leak that appears after several days.
I know that I have to set my objects to nothing.
My questions are. . .
How do I determine what to set to nothing?
adodb.connection
adodb.command
adodb.recordset
MSXML2.DOMDocument...
OK, I have more info
The DLL I am calling has events in it, and accesses other dll's that have events in them.
Is this something that would cause the server to time out while attempting to instantiate the object?
Don803
create a recordset named "rs" then . . .
dim Field
Response.Write("<table><tr>")
for each Field in rs.fields
Response.Write("<td><b>" & Field.name & "</b></td>")
next
Response.Write("</tr>")
do while not rs.eof...
I inherited an application that was written in VB6.
I have been asked to convert it to ASP.
I am attempting to access some of the DLL's the application uses, and they cause the page to time out.
I write VB to access the same DLL, and it all works fine.
What would make a dll cause timeouts on...
I occasionally need to send url's via email, and do not want the url messed with.
I send the value, and a hash. I also use a secret salt value.
example:
salt = "salt makes food taste better"
Then on my page, if the value, and hash do not match I state that the page is unavailable...
I am an VB 6.0 & ASP programmer, and am getting ready to learn / switch to ASP.NET.
Do I need VS.NET, or can I get by with just VB.NET?
I have VS 6.0 now, and only use the VB portion. I do not like interdev, and prefer to code asp using an editor. I have been told that asp.net is more like...
I found a reference that may shed some light.
It is in the Transact-SQL help file from SQL 7.0
sqlbol.chm
---------------------------------------
If a DECLARE CURSOR using Transact-SQL syntax does not specify READ_ONLY, OPTIMISTIC, or SCROLL_LOCKS, the default is as follows:
· If the SELECT...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.