0

globale Änderung eines Tabellennamens

Hallo zusammen!

Habe folgende Herausforderung: ich greife bei verschiedenen Tabellen auf die Tabelle X zu. Diese Tabelle X möchte ich nun durch die Tabelle A (neu) ersetzen. Wie schaffe ich es, dass die übrigen Tabellen nun auf die neue Tabelle A zugreifen und nicht mehr auf die Tabelle X. 

Vielen Dank

6 replies

null
    • Fred
    • 9 mths ago
    • Reported - view

    Can you be more specific about what you mean by access Table X?

    By a reference field?

    Or do you have formulas?

    Wie schaffe ich es, dass die übrigen Tabellen nun auf die neue Tabelle A zugreifen und nicht mehr auf die Tabelle X.

    You have to make sure you go through your code and change all references to TableA. If it is a new reference field then you can do a Bulk Edit to set the links properly.

      • Norbert
      • 9 mths ago
      • Reported - view

       

      Thank you very much, Fred.
      what is the script for the bulk edit and is this script to be executed via the "global function" function?
       

    • Fred
    • 9 mths ago
    • Reported - view
     said:
    what is the script for the bulk edit and is this script to be executed via the "global function" function?

     Bulk Edit can be seen under the gear icon of a table.

    The script will depend on the records your tables.  Are the records in TableA have the same record Id as TableX? If not then what other fields can you use to find the correct record to link to?

      • Norbert
      • 9 mths ago
      • Reported - view

       

      Hallo Fred.

      Example:
      if notes.done = true than abcd
      end
      This script occurs in other tables. I would now like to change the statement in all tables to:
      if Alternative.done = true than abcd
      end
      How do I proceed?

      • Fred
      • 9 mths ago
      • Reported - view

      You have to go to each table and each script and type the adjustment. if there are a lot then you may want to look into using Ninext to help you find all scripts with reference to the old table. I found Ninext's search abilities to be invaluable when I was redesigning my DB and had to find all references to a table or field that got changed. You will probably have to message directly to get installation instructions.

      • Norbert
      • 9 mths ago
      • Reported - view

      Thank you very much for your support. 

Login to reply

Content aside

  • Status Answered
  • 9 mths agoLast active
  • 6Replies
  • 35Views
  • 2 Following