+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Updating SIMS UDF'S in Technical; Iíve been working on updating SIMS UDF'S using a script (originally written by an RM Forum member, who I haven't ...
  1. #1
    Unvalidated User
    Join Date
    Jan 2008
    Posts
    54
    Thank Post
    1
    Thanked 3 Times in 3 Posts
    Rep Power
    0

    Updating SIMS UDF'S

    Iíve been working on updating SIMS UDF'S using a script (originally written by an RM Forum member, who I haven't been able to contact) and seem to be having a few problems.

    It appears that only the last field in the loop is updated.

    For example:

    We want to update the Username (4), ICT Password (7) and the
    Email Password (10).

    After the script is executed the Email password is there but
    the Username and ICT password are blank.

    It seems as if each update removes the last entry this
    happens even when using separate scripts. (Username is
    entered but when script enters ICT Password the Username
    disappears, and the same happens when the Email Password is
    entered the ICT Password disappears.)

    We have successfully connected to the database and have
    double checked that we are using the correct fields.

    I have attached the files that we are using, which may help
    you to understand our problem

    Thanks for your help
    Attached Files Attached Files

  2. #2
    Unvalidated User
    Join Date
    Jan 2008
    Posts
    54
    Thank Post
    1
    Thanked 3 Times in 3 Posts
    Rep Power
    0
    *bump


    .

  3. #3

    Join Date
    Nov 2007
    Location
    London
    Posts
    65
    Thank Post
    9
    Thanked 3 Times in 2 Posts
    Rep Power
    14
    Jody
    It's possible your lack of response will be due to people's nervousness at helping you perform direct writes to the SIMS database using SQL scripts. Have you taken advice on this from your local support team ?

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS workstation snot updating
    By KWestos in forum MIS Systems
    Replies: 2
    Last Post: 27th June 2008, 09:22 AM
  2. Sims clients updating
    By FN-GM in forum MIS Systems
    Replies: 16
    Last Post: 15th January 2008, 05:21 PM
  3. SIMS getting stuck when updating.
    By FN-GM in forum MIS Systems
    Replies: 20
    Last Post: 4th January 2008, 08:58 AM
  4. Windows not updating
    By Ric_ in forum Windows
    Replies: 9
    Last Post: 28th March 2006, 07:55 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •