Odd Errors returned

[Chuck Neal]

I have a project that has an export feature where it clones records to a 
new temp database.  It basically loops through the records and copies 
the content out and fills it back in the new file.  For images I import 
into a Director cast member then put it back in the second DB.  Its not 
running out of RAM but on certain larger sets of records I start getting 
errors over and over.  This is one query that works for the first 30 or 
so but after starts this...

UPDATE ids SET max_record = 275 WHERE table_name = 'technique_image'

-39 No error

Error is -39 but it says no error.


Another in the loop is this..

UPDATE ids SET max_record = 278 WHERE table_name = 'technique_image'
This gives me an error 301

Any idea why it starts?  Is it just bad to do too many DB changes in loops?

-Chuck
--------------------------
Chuck Neal
CEO, MediaMacros, Inc.
chuck at mediamacros.com
http://www.mediamacros.com
--------------------------
Check out the Developers Mall
Your one stop shop for all your Director Xtra Needs
http://www.mediamacros.net/customer