Scripting

BOI in C# nLogon line from Sage's samples seems to want to pop up a login box, but I need a silent server app connection. In the Sage example: oSS.GetType().InvokeMember(""nLogon"", System.Reflection.BindingFlags.InvokeMethod, null, oSS, null); I tried: oSS.GetType().InvokeMember(""nLogon"", System.Reflection.BindingFlags.InvokeMethod, null, oSS, new object[] { app..Properties.Settings.Default.SageUser, app..Properties.Settings.Default.SagePW }); The properties do have correct values. Error is the extremely helpful ""Exception has been thrown by the target of an invocation"" Any ideas on what the correct syntax is?

i'm not familiar with C# syntax so i'm a little confused reading your lines, when you are invoking nLogon, are you passing any parameters to nLogon? according to the File Layouts and Program Information, the Logon method does not take any parameters as it will set the user to the Default User,if you are trying to specify a user and password, you should be using the SetUser method.

But here is some C# code I have from notes of how to use the dispatch object using (DispatchObject oSS = new DispatchObject(oScript.InvokeMethod(""NewObject"", ""SY_SESSION""))) { oSS.InvokeMethod(""nLogon""); oSS.InvokeMethod(""nSetUser"", MASUser, MASPassword); oSS.InvokeMethod(""nSetCompany"", MASCompany); oSS.InvokeMethod(""nSetModule"", ""S/O""); Not sure this helps?

Looking back through a couple of my external scripts, I never used the Logon method, only the SetUser method as i have never tried to use the ""Default User"".

Thanks @DavidSpeckII and @ChrisMengerink ! It is nSetUser that is needed. Weird how the syntax is so different from VB to C#. Normally the online translators between the two get really close, but in this case they are useless. @ChrisMengerink - does your example include setting the field values for a write? sDiv = dt.Rows[i][""ARDivisionNo$""].ToString(); object[] divObject = new object[] { ""ARDivisionNo$"",sDiv }; ar_cust_bus.GetType().InvokeMember(""nSetKeyValue"", System.Reflection.BindingFlags.InvokeMethod, null, oSS, divObject) is failing on the last line.

@PhilMcIntosh , it might just be me but your C# looks overly complicated. Can you not just use ar_cust_bus.InvokeMethod(""nSetValue"", ""Column"", ""Value"")?

Glad you suggested that. I had problems with the Dispatch Object example from Sage City, so I dropped back to the older really verbose example. Now that I solved the initial issue, the Dispatch Object method is much closer to the VB syntax.

header example object[] curOrderNum = new object[] { ""SalesOrderNo$"" }; curOrderNum.SetValue(SalesOrderNo, 0); nReturn = (int)so_order.InvokeMethod(""NSetkey"", curOrderNum); nReturn = (int)so_order.InvokeMethod(""nSetValue"", ""ARDivisionNo$"", ""80""); nReturn = (int)so_order.InvokeMethod(""nSetValue"", ""CustomerNo$"", ""0140004""); nReturn = (int)so_order.InvokeMethod(""nSetValue"", ""OrderDate$"", created_at.ToString(""yyyyMMdd"")); detail lines example: DispatchObject so_detail = new DispatchObject(so_order.GetProperty(""oLines"")); nReturn = (int)so_detail.InvokeMethod(""nAddLine""); nReturn = (int)so_detail.InvokeMethod(""nSetValue"", ""ItemCode$"", sku);

One last (I hope) issue in translating to C#: retval = (int)sage.InvokeMethod(""nGetNextSalesOrderNo"", sOrder); It seems to increment the next order counter in Sage 100, and retval = 1, but the variable does not get populated.

before doing the nGetNextSalesOrderNo you are setting it to blank correct, I know if you don't set it to """" then it won't populate properly

Yes ,string sOrder = """"; is a previous line.

Something like this, methinks: Also what you called ""sage"", I called ""oSO"" but it's whatever is on left of the equal sign of the ""new DispatchObject"" line. Also might want to do this in a Try / Catch: string errorMsg = string.Empty; object[] parms = null; int retVal = 0; string sOrder = string.Empty; parms = new object[] { ""NextSalesOrder$"" }; retVal = (int)oSO.InvokeMethodByRef(""nGetNextSalesOrderNo"", parms); If (retVal == 1) { **sOrder = parms[0].ToString();** } Else { errorMsg = ""Error getting Next Order Number""; throw new Exception(errorMsg); }

Thank you @AlnoorCassim !

In C# BOI using the DispatchObject, how does one get the last error info? .sLastErrorMsg does not work

Sorry missed this one. So maybe like this: errorMsg = (string)oSO.GetProperty(""sLastErrorMsg""); throw new ApplicationException(errorMsg);