RE: VB Help

Walden,

Thanks for the tip. The problem I was having was that I was checking
PARMS(0) instead of cm.parameters(0). But I will now try what you said.


Thanks again,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040



                    "Walden H.
                    Leverich"                  To:     
"'midrange-l@midrange.com'" <midrange-l@midrange.com>
                    <WaldenL@TechSoftIn        cc:
                    c.com>                     Subject:     RE: VB Help
                    Sent by:
                    midrange-l-admin@mi
                    drange.com


                    01/17/02 10:29 AM
                    Please respond to
                    midrange-l






Mark,

1) Don't use Parameters.Refresh, it's a performance killer.
2) If you do use Parameters.Refresh there is no reason to append the
parameters since that's what .Refresh did for you. You're simply adding
additional parameters to a collection that already had enough.

-Walden

------------
Walden H Leverich III
President
Tech Software
(516)627-3800 x11
WaldenL@TechSoftInc.com
http://www.TechSoftInc.com

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.