Jump to content

Script kills network


This topic is 7180 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • Newbies

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_B):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 ]

Link to comment
Share on other sites

This topic is 7180 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.