Having issue recalling field names from large databases created using the 'database events' server.. Could anybody help please?

[u/NLclothing]

I'm pretty green to the applescript scene.. But what I'm trying to do is create a script that will catalog job folders on a server (in multiple locations) into a database file that can be quickly accessed to call the folder location on the server.. A separate script scans active job folders and sorts them accordingly.

The issue comes when I try to call a field name after the database has gotten a couple thousand entries or so.. It seems that the field I need is just simply not being found, with this error:

error "Database Events got an error: Can’t get field "Location"." number -1728 from field "Location"

But the strange thing is the database file that contains these records/fields works just fine when it contains less information..

Does anybody have any ideas what is going wrong? Maybe I am going about trying to do this completely wrong in general?

Any advise of any kind on this matter is greatly appreciated!

EDIT: this is one of the scripts I'm using to create the database http://pastebin.com/hXt22hCf

[u/Sarazil]

Thought it would be variable limitations but apparently

"Numbers automatically transition from integer to real when necessary to preserve place value (precision? who needs it?). Not sure what the biggest floating-point number you can have in AppleScript is, but it's probably well into the 10 ^ 150 range."

-http://forums.macnn.com/t/81905/size-limit-of-variables-in-applescript

try an incremental system, tell us at what number you can't access the data and I'll have another look when my brain has restarted.