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. firstname.lastname@example.org http://www.hanoverwire.com 717.637.3795 Ext.3040 "Walden H. Leverich" To: "'email@example.com'" <firstname.lastname@example.org> <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-Lemail@example.com Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.