sorry there is not enough memory to complete this operation 
Author Message
 sorry there is not enough memory to complete this operation

Hello again,

I have another issue which one of you may be able to shed some light on...

When running a script I receive the error: "sorry there is not enough memory
to complete this operation"

the script is basically this:

Find All Records
If First Record Matches Criteria
    Display message
Else
    Omit Record
    Run Script "B"
            Script "B":
                If First Record Matches Criteria
                    Show Message
                Else
                    Omit Record
                    Run Script "B"
                End IF
End If

So you can see that the script will naturally run until a record matches a
criteria set then will display a message, otherwise it will just keep
repeating until it reaches the last record.

So why am I getting the memory error?

Any and all help will be greatly appreciated.

Many thanks...

- Tom



Tue, 22 Jun 2004 15:56:34 GMT
 sorry there is not enough memory to complete this operation

You are using two scripts to basically run a loop, but nowhere in there are you
testing for the existence of an records.  The result is that FileMaker runs
these scripts endlessly which, because it is running as a sub-script (it still
has all those "End If"s to run) will result in a memory error.

It would all be much cleaner if you wrote it as follows:
Find All Records
Goto Record [First]
Loop
    Exit Loop If [ Status(CurrentFoundCount)=0 ]
    If [Field = Criteria]
        Display message
    Else
        Omit Record
    End If
End Loop

Quote:

> When running a script I receive the error: "sorry there is not enough memory
> to complete this operation"

> the script is basically this:

> Find All Records
> If First Record Matches Criteria
>     Display message
> Else
>     Omit Record
>     Run Script "B"
>             Script "B":
>                 If First Record Matches Criteria
>                     Show Message
>                 Else
>                     Omit Record
>                     Run Script "B"
>                 End IF
> End If

> So you can see that the script will naturally run until a record matches a
> criteria set then will display a message, otherwise it will just keep
> repeating until it reaches the last record.

> So why am I getting the memory error?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 321-5176
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance


Tue, 22 Jun 2004 16:05:37 GMT
 sorry there is not enough memory to complete this operation
Sorry --

You actually want to quit the script after showing a message.  To do
that, add either a 'Exit Script' or 'Exit Loop If [1=1]' after the
'Display Message' step.

Quote:

> When running a script I receive the error: "sorry there is not enough memory
> to complete this operation"

> the script is basically this:

> Find All Records
> If First Record Matches Criteria
>     Display message
> Else
>     Omit Record
>     Run Script "B"
>             Script "B":
>                 If First Record Matches Criteria
>                     Show Message
>                 Else
>                     Omit Record
>                     Run Script "B"
>                 End IF
> End If

> So you can see that the script will naturally run until a record matches a
> criteria set then will display a message, otherwise it will just keep
> repeating until it reaches the last record.

> So why am I getting the memory error?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 321-5176
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance


Tue, 22 Jun 2004 16:09:10 GMT
 sorry there is not enough memory to complete this operation
Howard,

Thanks for the help, I am implementing your advice presently.

Happy New Year

- Tom

---------------------------------


Quote:
> Sorry --

> You actually want to quit the script after showing a message.  To do
> that, add either a 'Exit Script' or 'Exit Loop If [1=1]' after the
> 'Display Message' step.


> > When running a script I receive the error: "sorry there is not enough
memory
> > to complete this operation"

> > the script is basically this:

> > Find All Records
> > If First Record Matches Criteria
> >     Display message
> > Else
> >     Omit Record
> >     Run Script "B"
> >             Script "B":
> >                 If First Record Matches Criteria
> >                     Show Message
> >                 Else
> >                     Omit Record
> >                     Run Script "B"
> >                 End IF
> > End If

> > So you can see that the script will naturally run until a record matches
a
> > criteria set then will display a message, otherwise it will just keep
> > repeating until it reaches the last record.

> > So why am I getting the memory error?

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Howard Schlossberg              (818) 321-5176
> FM Pro Solutions       Los Angeles, California
> Associate Member, FileMaker Solutions Alliance



Tue, 22 Jun 2004 16:20:50 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Memory issue (Not enough storage is available to complete this operation )

2. error - There is not enough memory to complete operation

3. Not enough memory to complete operation...

4. SQL7: Not enough storage is available to complete this operation

5. Not enough storage to complete this operation

6. Not enough storage is available to complete this operation

7. Not enough storage is available to complete this operation

8. not enough storage is available to complete this operation

9. not enough storage is available to complete this operation

10. Error 0x8007000E - Not enough storage is available to complete this operation

11. Not enough storage is available to complete this operation

12. Not enough memory to complete query


 
Powered by phpBB® Forum Software