Repository Update Script Error

More
3 weeks 2 days ago #22976 by downing
Hi,

Firstly, many thanks for this new feature.
I already have 2 use cases for it!

now to the problem ;)
The "How to activate the block transformation" script runs into an error.

 

Thanks in advance
Thomas 
 

Please Log in or Create an account to join the conversation.

More
3 weeks 2 days ago #22979 by admin
Please try replacing -10 with some other value for example -33

"OBJECT_ID*-10"

INSERT INTO OBJECTS_TREE (OBJECT_ID,PARENT_ID,NAME,OBJECT_TYPE)
Select OBJECT_ID*-10 as OBJECT_ID,
PARENT_ID,'Block Transformations' as NAME,
420 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=390

It is good to hear that you found block transformations useful.

We did put a lot of effort into developing it and we have done an enormous amount of testing.
It has a lot of room for improvement though ;-)

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
3 weeks 2 days ago #22981 by downing
Great

It worked :)
Many thanks Mike

But shouldn't there be more examples here?

 

Thomas

Please Log in or Create an account to join the conversation.

More
3 weeks 2 days ago #22982 by admin
The examples are in the default MS Access repository.

You can copy them across using the repository synchronization wizard.

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
3 weeks 2 days ago #22983 by downing
Thx Mike worked Great
Never used the Wizard before

Greets Thomas
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.