Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by Sai Subramanyam
Page 4 of 7
Creating orders in SAP system using .Net
You can handle it by creating an array and insert an object into Array. Bapisdhd1 order_header_in = new Bapisdhd1(); order_header_in.DocType = "OR"; order_header_in.CollectNo = "111022"; order_header_in.SalesOrg = "11011"; order_header_in.DistrChan = "100"; order_header_in.Division = "000"; order_header_in.DlvBlock = "010"; order_header_in.PurchNoC = "TEST ORDER"; newOrder.OrderHeaderIn = order_header_in;
Read MoreUsing ABAP, changing a value in itab by getting data from database table
You should do this using a Modify statement as in below − LOOP AT itab. SELECT SINGLE matnr INTO itab-matnr FROM zlldet WHERE palet = itab-palet. MODIFY itab. ENDLOOP. Also note that when you have an internal table itab with a header line, it means that you have a table itab and structure itab and usage of this depends on the situation. Few of the commands like MODIFY and LOOP AT uses both at the same time. DATA itab TYPE TABLE OF [something]. DATA wa ...
Read MoreHow to show if...else statement using a flowchart in JavaScript?
The if statement is the fundamental control statement that allows JavaScript to make decisions and execute statements conditionally. Let’s see how to show if…else statement using flowchart in JavaScript.
Read MoreHow do we connect SAP Business One with Ubercart?
This can be done using SAP DI server as it is using XML based format for importing data and more suitable for external data exchange. You can refer to below documentation for more details on SAP BI DI Server. https://archive.sap.com/documents/docs/DOC-7699 The DI Server enables business partners to develop SOAP-based solutions to read, write, update, and remove data objects on the database level. It provides a suitable infrastructure for server-oriented partner solutions. SAP Business One Web Services wrapper (B1WS) exposes the DI Server functionality as Web Services to provide a better usability. Developers only need to add the web references to ...
Read MoreHow to change the look of Python operators?
Python and most mainstream languages do not allow changing how operators look. If you're trying to replace something like a == b with a equals b, you can't do that. In Python the restriction is quite intentional — an expression such as a equals b would look ungrammatical to any reader familiar with Python.
Read MoreWhat would be the effect on MySQL output if we have the combination of NULL and other values in the list of strings, provided as arguments in FIELD() function?
There will be a significant change in the output if we have the combination of NULL and other values in the list of strings, provided as arguments in FIELD() function. Following example will demonstrate it Example mysql> Select FIELD('good', 'Ram', 'is', 'good', 'boy'); +---------------------------------------+ | FIELD('good', 'Ram', 'is', 'good', 'boy') | +---------------------------------------+ | 3 | +---------------------------------------+ 1 row in set (0.00 sec) ...
Read MoreHow to show a while loop using a flow chart in JavaScript?
The purpose of a while loop is to execute a statement or code block repeatedly as long as an expression is true. Once the expression becomes false, the loop terminates. Let’s see how to show while loop using flowchart in JavaScript −
Read MoreHow can we create a MySQL view with GROUP BY clause?
We can use GROUP BY to group values from a column, and, if we want, we can perform calculations on that column. You can use COUNT, SUM, AVG, etc., functions on the grouped column. To understand GROUP BY clause with views we are creating a view named ‘Info’ using the base table ‘Student_info’ having the following data − mysql> Select * from Student_info; +------+---------+------------+------------+ | id | Name | Address | Subject | +------+---------+------------+------------+ | 101 | YashPal | Amritsar | History ...
Read MoreWhat are the drawbacks of using test database?
There is a database named test in the list of databases displayed by the statement SHOW DATABASES. We can use test database but the main disadvantage is that anything created in this database can be removed/changed by anyone else with access to it. To avoid this we should take permission from MySQL administrator to use a database of our own. For taking permission following command must be run − mysql> grant all on tutorial.* to root@localhost; Query OK, 0 rows affected (0.10 sec) In the above command, I am taking permission for the tutorial database. Root is the ...
Read MoreHow can I update MySQL table after quoting the values of a column with a single quote?
As we know that with the help of QUOTE() function we can put the values of a column in single quotes. By using QUOTE() function with UPDATE clause we can update the table having quoted values. We need to give column name as the parameter of QUOTE() function. Following example will update the table ‘examination_btech’ after putting the values of column ‘Course’ in single quotes. Example mysql> UPDATE examination_btech SET Course = QUOTE(Course); Query OK, 10 rows affected (0.05 sec) mysql> Select * from examination_btech; +--------+----------+----------+ | RollNo | Name | Course ...
Read More