IOM Factory (VBA)
I want to update part bom quantity based on the data in Excel I registered the IOM.tdl in the VBA tool and wrote the following VBA code (based on the manual): Dim f As New IomFactory 'must use the New keyword Dim innov As Innovator 'Establish User Credentials URL = "">localhost/.../InnovatorServer.aspx" db = "API12" user = "admin" pw = "innovator" Dim conn As HttpServerConnection Set conn = f.CreateHttpServerConnection(URL, db, user, pw) ' create a connection Dim result As Item Set result = conn.Login If result.IsError Then MsgBox result.getErrorString Exit Sub End If However, I am encountering an error stating that CreateHttpServerConnection is not registered. Does anyone have any suggestions on how to fix it? * P.S. I also tried OData to try to get the part bom data, but the http result is 'no data found'Not able get value using RequestState
Hi, I have created one method called set_project_name in VB and run this method on OnAfterLock of "GRIL Project" ItemType Dim inno as Innovator = Me.getInnovator() Dim projectID as String = Me.getID() Dim AML_to_getProjectName as String = "<AML>"+ "<Item type='GRIL Project' action='get' select='_project_name'>" + "<id>"+projectID+"</id>" + "</Item>" + "</AML>" Dim ResultProjectName as Item = inno.applyAML(AML_to_getProjectName) Dim projectname as String = ResultProjectName.getItemsByXPath("//Result/Item[@type='GRIL Project']").getProperty("_project_name").ToString() RequestState.Add("projectname", projectname) Return Me and I want that value on other ItemType called Document on the event called "OnAfterAdd" like this: Dim inno as Innovator = Me.getInnovator() Dim projName As String projName = DirectCast(RequestState("projectname"), String) Return Me But I got the Null Object. Whether It is possible to get RequestState value on another ItemType? Thanks in Advance. Regards, Maddy.[ApplySQL] not allowed for userPrivileged [ApplySQL] not allowed for user
Hi, I am designing a small Windows Forms application, which will allow users to add/delete/view an item to/from Innovator database directly. From this application I can add Document and its attachment, now I want to open that document, and for that I write a sql query, but I get an error like this: [ApplySQL] not allowed for userPrivileged [ApplySQL] not allowed for user Regards, Maddy.