Script kills network

[Franky4Fngrs]

Ok ...i really don't know much about FM but my new job uses it. Here data is extracted from an accounting program to FM for reports. Everytime i run this "Master Import Delete" script it crashes the whole network (i.e. boots everyone off and requires server rebooting). Here is the script:

Perform Script [sub-scripts,"Re-Import"]

Perform Script [sub-scripts,"Delete V,C,X,0"]

Perform Script [sub-scripts,"Sort SO Line#"]

Perform Script [sub-scripts,"Apply Territory Correction"]

Perform Script [sub-scripts,"Verify BU"]

all right, this info is taken from a FoxPro based database program.....

Please someone help.....thx

[LiveOak]

Not nearly enough information to help you.

What platform(s) are you on (clients, server). What software and version are you running for your FM serving (FM Server?). The script you are showing us only has calls to other scripts with no detail of what they are doing. Is this script running a procedure in FoxPro?

-bd

[Franky4Fngrs]

clients = most 98 ..some 2k

server = 2k

fm server = 3.0

fm client = 4.13

[re-import script]

Find all

delete all records [no dialog]

import records [Restore, No dialog, "ODBC: Sbtso"]

set field ["Globals......etc

[Verify BU script]

go to record/request/PAge[First]

Loop

if["left( NuSBTIC_:PLINID , 1 ) = "P""]

set field["Salesmn","ZZ""]

Else

IF["Left( NuSBTIC_::PLIND , 1) = "W""]

set field[

hmm see..it goes in the sales order file for info..which is always in use...it always seems to crash at the re-import part....

[ February 21, 2002, 08:37 AM: Message edited by: Franky4Fngrs ]