Correct me if i'm wrong...
Hi,
Consider the following code:
VB Code:
Set oRs = CallMethodToGetRecordset()
Set oRs1 = oRs
Set oRs = Nothing
All along I'v been under the impression that setting oRs to Nothing within the scope would set oRs1 also to Nothing. But today I see that oRs1 has its records in place! I wondor how...
Is it something like this?
The statement "Set oRs1 = oRs" will set oRs1 to the Base Address of oRs. If I set the base address of oRs to Nothing, oRs1 is still pointing to the location with the values.
However, when I move oRs, oRs1 is also getting moved. When i close oRs, oRs1 is also getting closed!
Can some one pls explain...
- Jemima.