Hi,
I'm using ADO 2.7 and have memory leak when I try several times add
and delete records. See code (VB6)
Dim RS As ADODB.Recordset
Private Sub Main()
Dim counter As Long
Set RS = New ADODB.Recordset
RS.Fields.Append "Name", adVarChar, 255
RS.Open , , , adLockOptimistic
For counter = 1 To 100
Add_Records
Delete_Records
Next
MsgBox "Complete"
End Sub
The only issue I can see is that you never close the recordset.
Try upgrading to MDAC 2.8.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
RE: Converting VB6 Fileopen/input/close to vb.net ... swallow and spit it out as a single string.... stand alone components set for those VB6 file methods(such as FileOpen, ...Dim file_num As Integer = FreeFile ... For standard binary file read/write, in .NET, you can use BinaryReader ... (microsoft.public.dotnet.languages.vb)
Re: Back to VB6 and .NET ... memory than it is with prior libraries....Dim tExceptions As New DataTable ... It works slightly better than VB6 Edit and Continue. ... a DLL which is loaded by Orbiter to run the add-on (like a Project ... (microsoft.public.vb.general.discussion)
Re: Conversion Problem ... My overall intent is to convert an existing VB6 application into vb.net so I can still use multiple records I created in the new application. ...vb8 does not support arrays declared like arr1because when you try to do the Fileput it just gives an error saying only 2 dimentional arrays are supported - what a load of tat!!! ...dim arr1 ... (microsoft.public.dotnet.languages.vb)
RE: Converting VB6 Fileopen/input/close to vb.net ... stand alone components set for those VB6 file methods(such as FileOpen, ...Dim file_num As Integer = FreeFile ... For standard binary file read/write, in .NET, you can use BinaryReader ... Dim ClientFileName As String... (microsoft.public.dotnet.languages.vb)
RE: Converting VB6 Fileopen/input/close to vb.net ...BinaryReader classes in System.IO namespace to read ... stand alone components set for those VB6 file methods(such as FileOpen, ...Dim file_num As Integer = FreeFile ... Dim ClientFileName As String... (microsoft.public.dotnet.languages.vb)
