Sage 300

Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement. mDBLinkCmpRW.OpenView("CS0120", out csQry); sSQL = "Select Name, Description from MYDB.dbo.Table"; csQry.RecordClear(); csQry.Browse(sSQL, true); …

Up until now I've been setting my CS0120 variable to Nothing and then opening it up again like this: Dim qry as AccpacComapi.AccpacView DBLink.OpenView "CS0120", qry qry.browse "UPDATE sometable ... blah" set qry = nothing DBLink.OpenView "CS0120…

I just discovered that CS0120 has a limitation on the length of a given field name. In my query I had two formulas and I gave them friendly names: select idcust, (select xxxxxxxx) as CurrentPaymentNumber, (select yyyyyyy) as Current PaymentDate from…