Search results for query: *

Hi I am trying to create a new opportunity with the associated products in ACT using C#. Please help. kwagz

Hey guys I would like to get distinct values from a specified field in the SQL database using Accpac. What I'd like is Accpac to return a recordset with distinct values of a specific field. Your help will be highly appreciated. kwagz

I am trying to update a Product with data that is read from SQL database. When i use code below it returns "Application error" error. I am coding this application in C#. Please help. ... ... ProductList pLookup; pLookup = ACTAPP.ActFramework.Products.GetProducts(null); pLookup[index].Name =...

Well, I think I'll go the COMAPI route. How do I get data into the view, and use the .MoveNext to loop through it? This is my AccpacCOMAPI code: AccpacSession cSession; AccpacDBLink dbLink; AccpacDBLink sysLink; AccpacView cView = null; AccpacViewField cViewFld; cSession = new...

This is the code for printing to a file, and still not getting output. Am I missing something else here. FilePath = "C:/file.csv"; System.IO.StreamWriter csvFile = new System.IO.StreamWriter(FilePath, true); cView.Init(); cView.Order = 0; cView.Browse("", 0)...

This function returns a recordset from Accpac: public xapiView GetItemPrice(string UsrID,string PwdID,string CompName) { xapiSession cSession = new xapiSession(); xapiView cView = new xapiView(); cSession.Open(strUsr, strPwd, strCo, Date, 0); cView = (xapiView)...

Hi zemp I am still using xAPI views to get data from accpac and treating it as a recordset. Now, what i'm trying to do is print view fields to a file like in the above example, but nothing is printed. I can see the number of records from the recordset, though. Do you have an idea of why does...

zemp Thank you for responding. I am using XAPI to access Accpac data. Please help me with steps of going about reading data from XAPI views into recordset then print it to a file. If there are other methods of doing that, it would be highly appretiated if you would help. Thank you kwagz

Hey there I am trying to open a recordset in .net c# for Accpac and not sure what to parse on the first two parameters. ADODB.Recordset tmpRs = new ADODB.Recordset(); tmpRs.Fields.Append("FIELD",...); tmpRs.Open(...); //??? tmpRs.AddNew(...) Please help. kwagz

Hey Guys I am quite new to tek-tips. I have a question and I dont know how to post it. Please help kwagz