Run Script from a separate db

[mkohler28]

I am using 2 dbs, one is an interface file the other a data file. I have a script that runs from the data file when data gets changed on a field, but the change to the data is done on the interface file. The script runs (debugger on) but passes over parameters that it shouldn't and the script fails (there are other scripts that run within this script). If I go and run the same script directly from the data file I have no issues.

 

I have other scripts that do the same thing but in a smaller scale and I have no issues. Any ideas why this would be happening?

[Weetbicks]

an oversight in the scripting most likely, impossible to answer without actually seeing an example sorry. I assume you are changing the field value in a script run on interface, then calling a data file script from the running script. It almost sounded like you have a data file script that "triggers" itself when a field contents changed, using a plugin?

 

can you be a bit more specific?

[mkohler28]

Sure, first I'm using a ZippScript plugin. I have a field called 'ServiceLevel' in the interface file, this field, when changed calls the script on the data file to populate a DeliveryDate field. The script looks at two fields to determine what to set the delivery date as; 'dayofweekpickup' and 'serviceleveldays' these are calculation fields that provide numeric values for PickupDate and ServiceLevel fields.

 

If[data::dayofweekpickup = 2 and data::serviceleveldays = 1]

Set Field [data::DeliveryDate; data:: PickupDate +1]

If[data::dayofweekpickup = 2 and data::serviceleveldays = 2]

Set Field [data::DeliveryDate; data:: PickupDate +2]

etc..

 

So my when my data fits one of the parameters above it still just skips over it. I Just recently changed my data file to an interface file and everything seemed to convert fine other than this and one other script.

[mkohler28]

Actually 'ServiceLevel' is a field in the data file, just accessed via the interface file.

[mkohler28]

I figured this out by just setting up a script in the data file which performs a script from an external file which runs the scrpit from the interface file.