Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Using method getBPLIST() to get list of all orders in SAP Business One
I would suggest using recordset with DI API −
SAPbobsCOM.Recordset rs =
((SAPbobsCOM.Company)oCompany.GetDICompany()).GetBusinessObject(BoObjectTypes.BoRecordset);
rs.DoQuery("SELECT DocEntry, DocNum, DocDate, TaxDate, CardCode, CardName, DocTotal
FROM OPOR ORDER BY DocDate ASC");
while (!rs.EoF) {
int DocEntry = rs.Fields.Item("DocEntry").Value;
//OR
DocEntry = rs.Fields.Item(0).Value;
rs.MoveNext();
}
Updated on: 14-Feb-2020
390 Views
Advertisements