AnsweredAssumed Answered

Not Enough Memory to complete operation calc

Question asked by mjohnson24 on Jun 7, 2016
Latest reply on Jun 8, 2016 by mjohnson24

I have filemaker solution that is connected to a MySQL database that is used by our phone system to pull a call report. it works ok but im now getting an error. The below calc is in a calc field and on the layout im getting a ? across the board. If i copy the same calc in the dataviewer i get a error about sorry not enough memory to complete operation.

 

If i change the variables that have the ~ in front of them and hard code the data instead of pulling them from fields then i get the output i need. Whats the issue with this?

 

Let ( [

 

~FindExt = $$ext ;

 

~src = cdr::src ;

~srcLength = Length ( ~src ) ;

 

~dst = cdr::dst ;

~c_dst = cdr::_c_dst ;

~dstLength = Length ( ~c_dst ) ;

 

~c_dstChannel = cdr::_c_dstChannel ;

~c_accountCode = cdr::_c_AccountCode ;

 

~c_EmployeeExt = cdr::_c_EmployeeExt ;

 

~direction = Case (

 

  ~src = ~dst ; "Incoming" ;

 

  ~srcLength = 3 and ~dstLength = 3 and ~c_dst = ~c_EmployeeExt ; "Incoming" ;

  ~srcLength = 3 and ~dstLength = 3 and ~dst = ~FindExt and ~src ≠ ~FindExt ; "Incoming" ;

  ~srcLength = 3 and ~dstLength = 3 and ~dst ≠ ~FindExt and ~src = ~FindExt ; "Outgoing" ;

  ~srcLength = 3 and ~dstLength = 3 and ~src = ~c_EmployeeExt ; "Outgoing" ;

 

  ~srcLength = 3 and ~c_dst ≠ ~c_dstChannel ; "Outgoing" ; 

  ~srcLength = 3 and IsEmpty ( ~c_dst ) ; "Outgoing" ;

  ~srcLength = 3 and ~c_dst = "i5" ; "Outgoing" ;

 

  ~dstLength = 3 and ~c_dst = ~c_dstChannel ; "Incoming"

 

 

  )

 

] ;

 

~direction

 

)

Outcomes