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
-
Economics & Finance
Articles by varun
Page 4 of 7
Which PHP function is used to release cursor memory associated with MySQL result?
PHP uses mysql_free_result() function to release the cursor memory associated with MySQL result. This function is part of the original MySQL extension (now deprecated) and returns no value. Syntax mysql_free_result(result); Parameters Parameter Description result Required. Specifies a result set identifier returned by mysql_query(), mysql_store_result() or mysql_use_result() Example Here's how to use mysql_free_result() to free memory after processing a MySQL query result − Modern Alternative Since the original MySQL extension is deprecated, use mysqli_free_result() with MySQLi or PDO instead − ...
Read MoreHandline #Multivalue Error in SAP BO Webi report
This error occurs when your formula returns more than one value and WebI report doesn't know how to aggregate those values. The #MULTIVALUE error can appear in several scenarios − #multivalue in aggregation − When a formula returns multiple values without proper aggregation #multivalue in breaks header or footer − When break sections contain non-aggregated multi-value data #multivalue in section level − When section calculations encounter multiple values Understanding the #MULTIVALUE Error The error occurs because WebI cannot determine which value to display when multiple values ...
Read MoreConnecting SAP B1 via DI API takes too much time
When connecting to SAP Business One via DI API, you may experience slow connection times. This performance issue is commonly caused by accumulated log files that build up over time during DI API operations. Solution To resolve this connection speed issue, delete all files under the following location − %UserProfile%\AppData\Local\SAP\SAP Business One\Log\DIAPI Step-by-Step Process Follow these steps to clear the DI API log files − Close all SAP Business One applications and DI API connections Navigate to the log directory using Windows Explorer or Run ...
Read MoreGenerate Database diagram within SAP
Generating complete database diagrams in SAP, as typically generated in SQL Server or other DBMS systems, is not directly possible. However, there are several approaches that can help you visualize database structures and relationships within the SAP environment. Method 1: Using SAP Object Model Guide You can refer to the Object Model Guide available in the SAP Marketplace. This comprehensive guide explains the most common relationships between popular and frequently used business objects in SAP. While it doesn't cover every aspect of the database structure, it provides detailed coverage of the most commonly used and critical business objects ...
Read MoreAdding a text plus and text written from a parameter type C in ABAP
This can be achieved by using String Expressions or by using the CONCATENATE keyword. With the use of the concatenation operator && you can combine text and parameter values effectively. String Concatenation Methods in ABAP There are several ways to concatenate text with parameter values in ABAP. The most common approaches include using string expressions with the && operator and the traditional CONCATENATE statement. Using String Expressions with && Operator The modern approach uses string expressions with the concatenation operator && − ...
Read MoreViewing an ABAP program outside customer space.
When you encounter an ABAP program prefixed with "AQZZ", this indicates that the program was created by the SAP Query via transaction SQ01. While you might not be able to directly view the query, you can identify the Infoset on which the query relies. You can then enter the Infoset in SQ02 and when you click on 'Description', you can find more details about the program structure and data sources. Ad-hoc Queries T-Code: SQ01 You can use this transaction to create ad-hoc queries (SAP Queries) for reporting ...
Read MoreIdentify the program to edit an ABAP code
There are several ways to identify the program for editing if you know the transaction code in advance. Each method has its own advantages and use cases in ABAP development. Method 1: Using Transaction SE93 The most reliable method is to use SE93 (Maintain Transaction Codes) for identifying the program based on the transaction code. This transaction allows you to view the program associated with any T-Code. In SE93, simply enter the transaction code you want ...
Read MoreWorking on a cost center report in SAP
Generating a cost center report in SAP is straightforward, even for beginners. If you need details about how work orders are related to cost centers, this guide will help you understand the relationship and access the necessary data. All orders, whether they are internal orders or work orders, are linked to a specific cost center. Each order will have an associated cost center, and you can find this relationship by referring to the following Controlling tables: Key SAP Tables for Cost Center Reports COEP Table ...
Read MoreChange leaves duration from hours to days in SAP Fiori app
In general, customizing Fiori applications involves customizing the parent SAP application. So, if in the application, it defaults to hours then the Fiori app will also inherit the default behavior and show it in hours. Go ahead and change it to days, it will impact your Fiori app and the app will also start showing in days. In case you cannot afford to make a change in SAP application, then you need to handle it in a custom manner which will require you to ...
Read MoreWhat is the difference between method overloading and method hiding in Java?
method hiding − When super class and the sub class contains same methods including parameters, and if they are static and, when called, the super class method is hidden by the method of the sub class this is known as method hiding. Example class Demo{ public static void demoMethod() { System.out.println("method of super class"); } } public class Sample extends Demo{ public static void demoMethod() { System.out.println("method of sub class"); } public ...
Read More