--- In [email protected], "entropyreduction" <alancampbelllists+ya...@...> wrote: > > > > --- In [email protected], "Sheri" <sherip99@> wrote: > > I think I lost mydb for purposes of close and release without the > > localcopy'ing. > > testLocalCopy function in > comPluginDemoScriptFileSysObjDotSyntaxForEach.powerpro > tests exactly that; handle comes back from function without a problem. > > Could you confirm problem still there in your script without localcopy? If > so I'll have to try and replicate it. >
I commented out all my localcopy's and there is no problem. At one time I did have a problem, but it must have been something else I did that fixed it. Possibly I was trying to close "mydb" in a function that never had the local variable. Now wondering if it would have been possible to create "mydb" for purposes of close and release with local mydb=myview.ActiveConnection ? ActiveConnection: Sets or returns a String value that contains a definition for a connection if the connection is closed, or a Variant containing the current Connection object if the connection is open. Default is a null object reference. What do you think? Regards, Sheri
