Skip to Content
0
Former Member
Sep 20, 2005 at 12:17 AM

Cannot DataBrowse oQuotation document

38 Views

Hi, I am unable to browse through quotations with the below code - I get the following error (in the last line of code below): cannot use results from OQUT table with this object, however the exact same code using the BoObjectTypes.oOrders and using an ORDR selection works???

(I am using patch 29...)

SAPbobsCOM.IDocuments doc = (SAPbobsCOM.IDocuments)pCmp.GetBusinessObject(BoObjectTypes.oQuotations);

SAPbobsCOM.IDocument_Lines lines;

SAPbobsCOM.Recordset rs = (SAPbobsCOM.Recordset)pCmp.GetBusinessObject(BoObjectTypes.BoRecordset);

string quoteQuery = @"

select *

from OQUT

where DocEntry in (

select distinct DocEntry

from QUT1

where QUT1.LineStatus = 'O'

and QUT1.U_PriceUpd = 'Y'

and trgetEntry is null)

";

rs.DoQuery(quoteQuery);

doc.Browser.Recordset = rs;