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 usharani
Page 4 of 6
In ABAP, How to select all the data into my internal table using loops?
In ABAP, there are different ways to select data into internal tables using loops and joins. Understanding the performance implications of different approaches is crucial for efficient programming. Using JOIN Statements with Internal Tables One approach is to join all tables in a single SELECT statement. Here's an example − SELECT t11~orgeh t11~msty t11~mshort t12~position t13~job t14~job_grade t14~scheme INTO gt_my_combined_table FROM zgerpt_rnk_min as t11 JOIN hrp1001 as t12 ON t11~orgeh = t12~objid JOIN hrp1001 as t13 ON t12~position = t13~objid ...
Read MoreLimitation on number of columns in Visual Studio 2008
Visual Studio 2008 has a limitation on the maximum number of columns that can be displayed in certain contexts, particularly in DataGridView controls and query result sets. This limitation can affect applications that need to display large datasets with many columns. Understanding the Column Limitation The column limitation in Visual Studio 2008 typically manifests when working with − DataGridView controls − Limited display capacity for numerous columns Query result visualization − Database query results with excessive columns Designer view − Form designers struggling with wide datasets ...
Read MoreGetting age of tracefiles in SAP HANA database
In SAP HANA database, you have diagnosis files that include log and trace files, along with a mixture of other diagnosis, error, and information files. These files can be checked for diagnosis to find errors in SAP HANA database. In HANA database, trace files are stored separately per host, so to get access to the trace files of a multi-node system you have to check for each host individually. Finding Trace File Location To find the location of trace files in SAP HANA, ...
Read MoreUse of String.compare for a varchar field in SAP
The article you've provided appears to be mismatched with the topic. The existing content discusses SqlFunctions.DateDiff for date operations in Entity Framework, but the topic is about String.compare for varchar fields in SAP. Using String.compare for Varchar Fields in SAP In SAP development, comparing varchar fields requires careful handling to ensure accurate results. The String.compare method provides a reliable way to perform string comparisons in SAP systems, particularly when working with database varchar columns. Basic String Comparison Syntax The basic syntax for string comparison in SAP ABAP is as follows − ...
Read MoreActivation of ABAP table failing with reference error
When activating ABAP tables, reference errors commonly occur when quantity fields or currency fields are defined without proper reference configurations. This issue arises because SAP requires explicit references to determine the correct units and formatting for these special field types. Understanding Reference Fields In ABAP Data Dictionary, quantity and currency fields must reference other fields that define their units of measure or currency codes. This ensures proper display formatting and calculation accuracy throughout the system. Solution Steps To resolve the activation error, follow these steps − Step 1: Identify Problem Fields Check your table ...
Read MoreHow to clear HTML form fields with jQuery?
With jQuery, you can easily clear HTML form fields. For this, jQuery: reset Selector is used. This will clear the HTML form fields.ExampleYou can try to run the following code to clear form fields with jQuery − $(document).ready(function(){ $(":reset").css("background-color", "#F98700"); }); Student Name Student Subject
Read MoreHow to use labels in Java code?
Java provides two types of branching/control statements namely, break and continue.The break statementThis statement terminates the loop or switch statement and transfers execution to the statement immediately following the loop or switch.ExampleFollowing is the example of the break statement. Here we are trying to print elements up to 10 and, using break statement we are terminating the loop when the value in the loop reaches 8.public class BreakExample { public static void main(String args[]){ for(int i=0; i
Read MoreHow do I write class names in Java?
While writing class names you need to keep the following points in mind. You shouldn’t use predefined or existing class names as the name of the current class. You shouldn’t use any Java keywords as class name (with the same case). The First letter of the class name should be capital and remaining letters should be small (mixed case). class Sample Likewise, first letter of each word in the name should be capital an remaining letters should be small. class Test Keeping interface names simple and descriptive is suggestable. Better not ...
Read MoreWhat is the difference between compile time polymorphism and runtime polymorphism in java?
If we perform (achieve) method overriding and method overloading using instance methods, it is run time (dynamic) polymorphism. In dynamic polymorphism the binding between the method call an the method body happens at the time of execution and, this binding is known as dynamic binding or late binding. Example class SuperClass{ public static void sample(){ System.out.println("Method of the super class"); } } public class RuntimePolymorphism extends SuperClass { public static void sample(){ System.out.println("Method of the sub class"); ...
Read MoreHow to use MySQL DISTINCT clause on multiple columns?
We can use the DISTINCT clause on more than columns in MySQL. In this case, the uniqueness of rows in the result set would depend on the combination of all columns.ExampleConsider the following table ‘testing’ having 10 rows −mysql> select * from testing; +------+---------+---------+ | id | fname | Lname | +------+---------+---------+ | 200 | Raman | Kumar | | 201 | Sahil | Bhalla | | 202 | Gaurav | NULL | | 203 | Aarav | NULL | | 204 | Harshit | Khurana | | 205 | Rahul ...
Read More