it seems that if the table field count * the # of rows > 65000 you get this
error unless the array is initialized prior to the copy to command
I went back through the code and made sure the arrays were initialized, only
found one instance in the old code.
Allan Lindgren
mailto: allan_lindgren /at/ starkey .DO.T com
> Subject: error 43 - There is not enough memory to complete this
> operation.
>
>
> Hi guys and gals
> Back from holidays and back to solving the worlds problems, well
> VFP anyway
> Back to the error 43 problems. Got in data that throws the error
> and can now
> trace the error
> The code is very old, here’s what happens, in a sale, when adding
> a type of
> Hearing aid that needs an ear mold made, the user is asked if they want to
> add this to sales. sales is in a buffered state. So the code constructs a
> filer depending on different criteria so the same form can be used for
> multiple purposes. The offending code is
> Copy to array laSource for &lcWhere
> lcWhere is the customer_id and the sale item id, 1 record is found but we
> now get an error 43 - There is not enough memory to complete this
> operation.
> checked in both VFP7 and VFP6 same error.
> I have changed this to do a scatter to laSource and now avoid
> this problem.
> Does the copy to array try to load all records before applying the filter?
>
> Allan Lindgren
> mailto: allan_lindgren@starkey.com
>
>
©2002 Allan Lindgren |
