[AccessD] ParamArray problem

But why is there "something in there"?  I am not passing anything.  However

Dim Obj As Variant
    For Each Obj In mcolDepObj
        Obj.Requery
    Next Obj

performs an obj.requery even though the array is "empty", i.e I haven't
passed anything in yet.

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart
McLachlan
Sent: Thursday, March 11, 2004 12:00 AM
To: Access Developers discussion and problemsolving
Subject: Re: [AccessD] ParamArray problem


On 10 Mar 2004 at 23:43, John W. Colby wrote:

> What the heck is going on here?  Can I not do this (not pass anything to a
> paramarray?
>

You can, but the way to check for an empty ParamArray is not obvious:

"To detect an empty ParamArray, test to see if the array’s upper
bound is less than its lower bound."





--
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.



--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com