Lee J Posted August 19, 2001 Share Posted August 19, 2001 I have a quotation system with a script that Duplicates related items in a Line_Items db by first exporting the original items out, then performs a replace with new Quote Number, and then re-imports the original items back in. My scripts work ok running it locally, but when I Serve the databases via FMServer it fails to work. Any ideas folks? Link to comment Share on other sites More sharing options...
Vaughan Posted August 19, 2001 Share Posted August 19, 2001 You know, as I started reading your post about the fancy imports you do, I thought "that'll break when used multi-user"... Imports don't work multi-user *unless* they are performed from the host machine. The reason they don't work is that each guest's found set is independent from the host machine. My only suggestion is to get rid of the imports. Link to comment Share on other sites More sharing options...
Lee J Posted August 20, 2001 Author Share Posted August 20, 2001 OK If I get rid of the Imports how shall I handle the Duplication of the Related records?. We generate automatic Quotes with many being similiar to the last, Hence the reason to Duplicate. I found the Importing to be good because I reduced the chance of any previous quotes getting completely overidden. Who else can I duplicate related records via Portal? Link to comment Share on other sites More sharing options...
Vaughan Posted August 20, 2001 Share Posted August 20, 2001 Errr, what's wrong with the Duplicate record script step? Seriously... Link to comment Share on other sites More sharing options...
Lee J Posted August 20, 2001 Author Share Posted August 20, 2001 I did try using this initially by using a loopthrough the found set, however when I had a quote which had 100's of items I ran into all sorts of difficulty. However I will investigate this option as my FM skills have improved somewhat over the course of this project. cheers Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8307 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 accountSign in
Already have an account? Sign in here.
Sign In Now