Hi Adam,

>> do you really want ALL of the inserts to be rolled back?

Yes - What I need is an all or nothing. The for loop should process 18
times and I need all 18 loops to be without error or they all need to be
rolled back.

Question :- doest "ParamByName" (and FieldByname for that matter) cause
the query to search its parameters list each time its called and then
returns the index value. Params[0] prevents the search and hence speeds
up the query ?

>> Also, unless I am going nuts, you probably want to stop at

High(PerArray)-1

PerArray is a zero based array so High(MyArray) will return
Length(MyArray) - 1

--
Regards,
Grant Brown

Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au

SiteDoc - Easy to Use - Powerful Results