-- Änderung der Feldreihenfolge UPDATE [edbTdef] SET [Feldnummer] = 3 WHERE [EdbInt] = 324 AND [Feldname] = 'UMS'; UPDATE [edbTdef] SET [Feldnummer] = 2, [Position] = 2 WHERE [EdbInt] = 324 AND [Feldname] = 'AKTN'; UPDATE [edbTdef] SET [Feldnummer] = 1, [Position] = 1 WHERE [EdbInt] = 324 AND [Feldname] = 'NAME'; -- Einfügen des fehlenden Feldes INSERT INTO [edbTdef] ([EdbInt],[Feldnummer],[Feldname],[Cluster],[POSITION],[Länge],[Typ],[Rochadetyp],[LinkBstn],[Redundant],[Flags],[Bezeichnung]) VALUES (324,0,'DSTEP',1,0,12,1,0,323,0,1,'Dialogschrittname'); -- Erhöhe Feldanzahl wegen neuen Feld UPDATE [edbBstn] SET [Anzahl_Felder] = 4 WHERE [EdbInt] = 324; -- Korrektur von Parent UPDATE [edbBstn] SET Parent = 'IDIS' WHERE [EdbInt] = 325; UPDATE [edbBstn] SET Parent = 'IDIS' WHERE [EdbInt] = 326; UPDATE [edbBstn] SET Parent = 'IDIS' WHERE [EdbInt] = 327; UPDATE [edbBstn] SET Parent = 'IDIS' WHERE [EdbInt] = 328; UPDATE [edbBstn] SET Parent = 'IDIS' WHERE [EdbInt] = 329; UPDATE [edbBstn] SET Parent = 'IDIS' WHERE [EdbInt] = 330; UPDATE [edbBstn] SET Parent = 'IDIS' WHERE [EdbInt] = 331;