As we know that in trigger definition, we can refer to columns of the row being inserted, updated or deleted. Following are the ways OLD and NEW keywords enable us to access columns − We must have to prefix the column name with a qualifier of OLD to refer ... Read More

With the help of CHARSET() function, we can check which string is returned by MySQL CHAR() function. Following result set will demonstrate it − mysql> Select CHARSET(CHAR(85)); +-------------------+ | CHARSET(CHAR(85)) | +-------------------+ | binary | +-------------------+ 1 row in set (0.00 sec)

To set all the border left properties in a single declaration, use the borderLeft property. You can try to run the following code to learn how to set the border left properties − Example Live Demo ... Read More

We can use MySQL absolute value i.e. ABS() function to select records from a table if the absolute value of the difference between two values is greater than a certain number. We are using the data from ‘Marks’ table to demonstrate it for example. Example mysql> Select * from ... Read More

You can access Class Builder by using T-code: SE24 or via Repository Browser SE80 and navigate to class you want to edit. You have to ensure that you set the below parameter to the public. It is also possible that your class implements an interface. It is also possible ... Read More

Note that parameter statement compiles into selection screen at compile team so it is not possible to declare dynamic parameters as proposed by you. Other approach would be that you could load dynpro and change the screen dynamically. You have to activate and then run the report that calls the ... Read More

If super class and sub class have same methods including name, return type and parameters, and if you try to call it using the object of the sub class Then the method in the sub class is invoked. Constructor looks like method but it is not. It does not have ... Read More

The java.io.PrintStream.println() method prints an array of characters and then terminate the line. This method behaves as though it invokes print(char[]) and then println(). Using this method you can print the data on the console. import java.io.*; public class PrintStreamDemo { public static void main(String[] args) ... Read More

Compile time errors are syntactical errors in the code which hinders it from being compiled. Example public class Test{ public static void main(String args[]){ System.out.println("Hello") } } Output C:\Sample>Javac Test.java Test.java:3: error: ';' expected ... Read More

It does not seem to be feasible to edit the report once generated. You cannot add a constraint or logic to allow your report to be editable.But there does exist a work around, what you can do is: First export the report and then you can change the mode of ... Read More