Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Fast way to clear params |
Thu, Dec 24 2009 9:32 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Is there a fast way to clear all the params for a query? I'm currently doing things like
if ipForename > 0 then findContact.ParamByName('Forename').AsString := ImportGrid.Cells[ipForename, rCntr] else findContact.ParamByName('Forename').Clear; because a number of the parameters may not exist. Its in a data import routine so I have to make allowances for some data being supplied an other not. Roy Lambert |
Mon, Dec 28 2009 9:43 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Is there a fast way to clear all the params for a query? I'm currently doing things like >> Unfortunately, the only way to do it is to loop through the Params property and call the Clear method for each parameter. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |