>We have a user receiving 'Insufficient Memory' errors when a user defined popup is created. When deleting enough data, no errors are received. However, our customer tells us no data may be deleted.
>
>What can we do to prevent the insufficient memory errors?
>
>Thanks for the help.
>
>Lance
Lance,
You may be suffering the other "fast machine" problem. On machines above 200 MHz lists created with "Prompt Fields" begin to choke on too many records. The trick is to slow it down a little. Try this:
First, change the "PROMPT FIELD BigTable.FldName" in the DEFINE POPUP to "PROMPT FIELD RetName(BigTable.FldName)"
Next create a function called RetName
FUNCTION RetName
PARAMETER FieldName
RETURN FieldName
That alone may be all you need, but if the machine is fast and the rows many, you may have to slow it a little more.
FUNCTION RetName
PARAMETER FieldName
PRIVATE nCntr, nMaxVal, nDummy
nmaxVal = 20
FOR nCntr = 1 TO nMaxVal
nDummy = 0
NEXT
RETURN FieldName
Hope this does the trick!
David.