The following code prints out an error report to NotePad. Private sub cmdPrintError_Click Dim curDB As Database Dim rs As Recordset Dim lSQL As String Dim retVal As Variant Open
Use this code to obtain the rowcount in JDBC without looping through the resultset. try { // Create a scrollable result set. stmt = conn.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); // Set a
Oftentimes, when I’m creating stored procedures, I forget to grant execute permissions to my user(s). Here is a stored procedure that will do this for you by simply passing in
String processing in VB is usually a very slow task. Often, people process strings letter by letter and construct a larger trinf afterwards from small bits. A better way would
The problem with the collection API is that you cannot put primitive data types into it. Instead, you must use their object counter parts. For instance, you have to use
Arrays are similar to ideas in mathematics. An array stores many values in memory using only one name. “Array” in programming means approximately the same thing as array, matrix, or
Suppose a class requires a “springboard” for calling a set of member functions which share the same signature. For example, the springboard might create some parameters to pass to these
This is required in B2B integration when one vendor logs into a system and upon validation a success message needs to be displayed and depending upon user’s request, the user
User language settings can be detected in one of the two following ways: Using the cultureinfo class current culture property: Using the request object’s userlanguages collection: Note: The UserLanguages collection