kkeller さんのグループアクティビティ

Method for power deleting a bogus part

kkeller — Thu, 16 Dec 2021 19:42:49 GMT

What is the method for getting past the message

"Part cannot be deleted. It is used in Part BOM related_id C0FDB52A894347949EC7F21DB31E6709."

At first glance, one might ask, why would you ever ever ever want to do that? Well, there are reasons that I may, as admin, want to delete the part as if it had never existed (duplcate, bogus, fat finger entry, bad import, etc)

Now, I have written SQL code that can purge every relation of which the item is a child, and it works, but this is not the preferred method as it is "Back Door" and very risky.

Keep in mind that this may be necessary, especially early in the Aras implementation when bogus parts are discovered and the company is not heavily relying on the integrity of the data....Yet.

I am hoping I have missed something fundamental

Kent

Server Side API to get connection string or URL

kkeller — Tue, 28 Sep 2021 20:54:42 GMT

From the Server side API, how do I get the connection string (i.e. Server, SQL Database)? I need it to execute custom SQL code that joins data from another database.

From the Client Side, I can use

var url = aras.getServerBaseURL();
var base = aras.getBaseURL();

But these functions are not available from the Sever Side API

I feel I am on the right right track with

dim scb as object = inn.getConnection

dim oInnDatabase as object = scb.CCO.DB.InnDatabase '.databaseName

dim fooDatabaseServerName as object = oInnDatabase.DatabaseServerName 'Works: Gives SBIWS457

Examining the properties in Visual Studio Watch, I found the exact place I want to be, but am unable to access the properties

olnnDatabase.ActiveInteractor.CurrentConnection.ConnectionString '(Failes)

This seems like it should be simple, but I can't seem to find any reference to functions that call back to the initiating server from the Server Side API.

Kent

Ask A Question I

Tue, 28 Sep 2021 11:37:02 GMT

Ask a question in a forum.

kkeller さんの グループ アクティビティ

Method for power deleting a bogus part

Server Side API to get connection string or URL

Ask A Question I

kkeller さんのグループアクティビティ