devxlogo

The Latest

Conversion From Numeric to String

#include void main(){ char cBuf[96]; float fVar=5.678; int nVar=78; //Conversion from float to char* sprintf(cBuf, Related Posts Masdar Acquires Hybrid Renewable Projects in PolandHarnessing AI, data, and cloud for growthApple

Fast Execution of SQL Statements

Let’s start with a code fragment: Statement stmt;Connection con;Class.forName( Related Posts Why TDD Is KeyCan’t use the “Between” Keyword in a LINQ QueryBranson’s brave sale of Virgin Records safeguarded Virgin

Handling Data Inconsistency

Many times in DB programming, a situation occurs when one operation, depends on the result of the other, but there is no way to communicate that result to the first

Determining the Last Date Of a Month

It’s common when working with dates to be able to determine the last date of a particular month. I’ve seen solutions to this problem that range from using arrays or

Encrypting Stored Procedures

When creating stored procedures, there will be occasions where a certain procedure definition should not be viewed. Using the WITH ENCRYPTION clause stores the procedure definition in an unreadable form.

Encrypting Database Views

Using the WITH ENCRYPTION clause when creating views ensures that they remain secure by keeping the view definition hidden. Sample code:————— Create view Procedure ————–create view Related Posts Revolutionary US

A Beginner’s Checklist

Beginners and even experienced programmers who switch to a new compiler suddenly discover that their programs don’t compile anymore. Sometimes the programs compile but produce numerous warning messages. In most

MS Default Pointer Value

Don’t forget that MS compiler initiates pointers with 0xCCCCCCCC value. In this case: void *p; … //do something here… if (p!=NULL) delete p; // Memory violation The right way void*

I/O Formatting With Stringstream

The sprintf() function isn’t type-safe, it doesn’t support user-defined types and it’s a common source of buffer overflow bugs. In C++, there’s a better alternative to sprintf(), namely stringstream objects.

Different Uses For Sizeof Operator

Sizeof is a useful operator because it reports both the amount of memory that data items take and the number of bytes that data types. For instance: cout

Make A More Efficient Split Function for VB4 and VB5

This is a fast, efficient way to make a split function. For longer strings, performance can be improved by enlarging AllocUnits. Public Function Split(strText As String, _Optional Byval Delimited As

Extract the Extension of a Filename

Extracting the extension of a filename is a requirement in many file searches and file I/O related applications. A simple way to do this is to use the split function.

Create a Linked Server in SQL Server

You can establish a link to the remote SQL Server using this code: Sp_addlinkedserverSyntax :SP_addlinkedserver[@Server]=’server'[,[Srvproduct=]’product_name'[,[@provider=]’provider_name’][,[@datascr=]’data_source’][,[location=]’location'[,[@provstr=]’Provider_string'[,[@catalog=]’catalog’]server: Name of the linked server to createproduct_name: Product name of te OLE DB data sourceProvider_name:

Why Static Methods Can Only Make Calls to Static Methods

Write the following code, compile it, then try to run it: class TstApppublic static void main (String args[])Next_Level(args[0]);}public void Next_Level(String Incoming_String)System.out.println(Incoming_String);}} It is very simple code but it will not

Retrieving the Date From lastModified()Method

The lastModified() method in java.io.File returns a long datatype. Thislong datatype represents the date and time when the file was last modified.The value does not carry any usage unless it

Counting the Occurrences of a String

Counting the occurrences of a string can be useful when you Related Posts MSAL: New Authentication Library from MicrosoftSony Begins Selling Developer Preview of SmartEyeglassKEMP Technologies delivers dynamic approach to

Create a Shortcut Key For a TextBox

Associate a label that describes what the text box is meant for.For example, a label with the caption ‘Name’ would be a good pair for a text box wherein you

Add Multithreading to Your VB.NET Applications

evelopers have been requesting that Microsoft add more threading functionality to VB for some time?it will finally happen with VB.NET. VB6 does have support for building multithreaded EXEs, DLLs, and

Understanding and Calculating Dates

QL Server provides many sophisticated functions to calculate dates. But knowing how to use them can often be a challenge. Suppose you want to calculate when a package is due

Cloning Data Accurately and Randomly

ecently I encountered a couple of Oracle-tuning projects that required me to evaluate the performance of PL/SQL and SQL code. I had to generate a substantial amount of data from

Creating Clickable Appointments

onsider the scenario in which you are building a Web application that displays events or appointments for different dates. If you want your users to remember this event within their

XML Parsers: DOM and SAX Put to the Test

ML is becoming increasingly popular in the developer community as a tool for passing, manipulating, storing, and organizing information. If you are one of the many developers planning to use

Choose Your Java XML Parser

he XML parser world is a dynamic one. As standards change, the parsers change as well–XML parsers are becoming more sophisticated. For most programming projects, the parser, at minimum, must

Show the List Box of a Combo Box Using SendKeys

It’s possible to show the list box of a combo box, with focus, using SendKeys “{F4}”. It Related Posts Create a Snapshot of Your DatabaseMusk and LeCun clash over xAI

Use Early Binding to Speed Up Procedure Calls

Use early binding by declaring variables as the correct object/interface. This will speed up procedure calls. Example: * Create a new Standard EXE Project * Add a list box to