Program designers would typically draw the ladder-logic diagram by hand. The development of ladder-diagram (LD) programming increased industry's acceptance because the graphical program diagram allowed electricians with little or no training in LD programming to follow the logical flow of each rung, in the same way an electrical-control schematic can be used for troubleshooting purposes. Original SQL Script URL Updated Script for TimeXtender 20.10.16.In the early 1970s, programmable logic controllers (PLC) became available as a replacement for hardwired relay logic panels. Listing changes in TX Objects since a given date or version number.Īt the end of each record you can find the query to list the history of the object up until the change. All versions created on or after this date will be taken into account. All versions starting from this version will be taken into account.ĭECLARE datetime = ' 20210401' - If = 0 this param will be used. Set to true if you want to start from a version.ĭECLARE BIGINT = 1 - If = 1 this param will be used. */ĭECLARE VARCHAR(100) = 'EDPB 2.0' - TimeXtender project you want to checkĭECLARE BIT = 0 - Choose whether you check versions from a given version number or from a given date. Load the script in SQL Server Management Studio (SSMS), point to a TimeXtender Repository SQL database and edit the following parameters before running the queries. This helps review changes in TimeXtender objects since a given date, or review differences between two saved versions of a project.
It covers the most used objects in the staging, data warehouse and semantic layer steps. This SQL script explores the version history at object level - showing all deletes, adds and restores of TimeXtender objects as well as who made the change, when did it occur and the version notes. This article includes an updated script for TimeXtender 20.10.16.64 (by deleting a few fields in the SELECT statement).
The original script was b ased on TimeXtender 20.5.8.64. This technique and SQL script were posted by Raf Lemmens in TimeXtender community forum for " Product Feedback and Ideas ".
0 kommentar(er)
