Mike Yearwood
Toronto, Ontario, Canada
Environment versions
Network:
Windows 2000 Server
>For some reason, when I try to insert a record to a table with about 700K records (not many fields) in it, I am getting the following: "There is not enough memory to complete this operation (Error 43)" - From the exe that is doing an INSERT this shows as an error going to the error log file, but until the user clicks OK on the dialog the table is locked and this really causes problems for other users. Any thoughts about why a program would have this issue even when the PRG/DBF, etc have not changed in some time? In VFP7 Development, if I insert a record (blank) I get this error but if I click IGNORE it goes on. As well, the app seems to complete but it closes out. Should I just trap 43 and do nothing with it? Is that the only way out?
Hi Doug
NEVER ignore errors. Find out the cause. At least you'll learn something! It used to be that there was some difference in Rushmore memory usage for index files around the 500K record mark. Things would be ok prior to that limit. What exactly is your INSERT command? Hopefully it's a SQL Insert with that number of records.
The number of users and/or the number of insert could have changed causing the error to be more frequent.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only