A common mistake is to initialize static class members inside the constructor body or a member-initialization list like this: class File{ private: static bool locked; private: File(); // Related Posts

One of the most frustrating aspects of debugging is detecting memory overruns. Some compilers (MS Visual C++ for instance) automatically add “sentry bytes” at the ends of every memory block

The conditional operator,?, is a shorthand for a sequence of if-else statements. Although it has legitimate uses, in many cases programmers tend to misuse it, thereby producing unintelligible and buggy

When you’re working with QueryDef (SQL instructions stored on an MDB database) and open it, DAO loads all the QueryDefs. For example, if you have an MDB with five QueryDefs

These several database functions work together and perform various utility functions, such as checking if fields and tables exist, creating fields and tables, and so on. The interface hides all

For simple Microsoft Access security, set the database password from the Security item under the Tools menu in Access, select Set Database Password, and enter a password. To use the

This code helps test SQL functions or other string-manipulation routines so you can generate random strings. You can generate random-length strings with random characters and set ASCII bounds, both upper

When executing an Oracle stored procedure, use the named parameter convention. In place of this code: OraDatabase.ExecuteSQL _ (“Begin Employee.GetEmpName (:EMPNO, :ENAME); end;”) Use this code:OraDatabase.ExecuteSQL (“Begin Employee.GetEmpName _ (empno=>:EMPNO,

Question: How can I check if the password that a user inputs has at least one numeric character? Answer: The best way to check whether what the user has entered

Question: I want to use a form that contains a set of textboxes and a set of buttons. When I push a button, I want to manipulate the last active

Question: I am developing an application using VBScript and ASP. I wrote this HTML code to be executed on a client’s machine:

Question: I have added a data connection in Visual Interdev. In the Data View I can see all my tables, fields and so on. My database resides on a SQL

Question: When I add a hyperlink to an ASP page, the link appears underlined. How can I remove the underline from the link? I only want the line to appear

Question: We are only able to add one row in the database, using forms in HTML. How can we do multirow operations on the HTML before sending it to the

Question: I am getting this error message: Invalid operator for data type. Operator equals subtract, type equals varchar. What does this mean? Answer: It means you are doing subtraction on

Question: Is there a script that can gauge site visitors’ net connection speed and route them to the proper link? In particular, I’d like to “auto link” my real video

In SQL Server 7.0, dynamic resource allocation lets disk and memory usage scale to meet changing database demands. This flexibility lets SQL Server provide better performance and simplifies managing the

Internet Explorer 5.0 makes printing pages from within your code simple. The print() method is now exposed off the window object in IE5. It presents the print dialog for the

Java uses a big endian data structure, but Intel-based computers and some others use a little endian format. You may run into problems reading binary data saved in little endian

Question: What is the difference between NT servers and NT workstations? Are they different machines or just different operating systems? Answer: NT servers and NT workstations run the same operating

Question: How can I execute an existing DTS package from Visual Basic? Answer: Get an object reference to the package. I do this in Visual FoxPro: loxx=createobject(‘DTS.Package’,’CmdExample’) Then I ask

Question: I am new to SQL. I need to use Oracle 7, but I need a user name and password. How can I get started? Answer: You need to ask

Question: I need to get a handle on my choices for a SQL reporting tool for ad hoc reports. The quick-and-dirty requirements are that it must be able to develop

Question: We are currently running SQL 6.5 and want to upgrade to SQL 7.0. The machine hosting SQL 6.5 is not robust enough to handle SQL 7.0. We are running

Question: I have three databases in SQL Server 6.5. All have the same structure of tables and stored procedures, but whenever I change stored procedures in one I must do

Question: What is the data type for time? Example: 8:45 am Answer: What you really have is the tail end of a datetime data type. You can get it back

Question: I am writing an application that needs to be able to shut down any NT workstation or server remotely. Do you have any ideas on how to do this

Question: When I run SQLMaint to update statistics on one of our SQL 6.5 servers, the table statistics get updated but it returns an error message: [4] Update Statistics…[Microsoft SQL-DMO]

Question: What situation produces incorrect results in an uncontrolled shared update? Answer: I’m not certain what you mean; however, reading uncommitted (i.e., dirty) data springs to mind. Are you trying

Question: How do I display a column from a database in a list box? Answer: This presumes you have a view defined somewhere, either remotely or on the server as