The standard way to copy the contents of the screen or a window to a picture box requires you to use a lot of API functions, such as BitBlt. A

Many VB developers know that they should specify a DLL Base Address value – in the Compile tab of the Project Properties dialog box – that is different from the

Here’s a little programming tip that will save you hours of headacheslater.Most of us already indent our Ifs, Selects, Do…Loops, etc., and that is good. But suppose you have some

The Microsoft manuals preach that all the compiler options in the Advanced Optimization dialog box are to be considered unsafe, in that they might lead to incorrect results (or just

If you aren’t satisfied with the standard Beep command (who is?) you can use the Beep API function instead, that lets you control both the frequency (in Hertz) and the

VB5 and VB6 environments include a pair hidden commands that let you remark and unremark a group of statements. These commands are hidden in the sense that they can be

If you load a VB6 project file in the VB5 environment you get a warning, even though the project is correctly loaded. The cause of the warning is a VB6

At times you’d like to save all the current settings of the Visual Basic environment and restore them afterwards. For example, you may want to alternate between the MDI environment

When you close a VB IDE session, VB saves the code but doesn’t save the current set of breakpoints. If you need (non-conditional) breakpoints to persist among sessions, don’t use

Question: I just created some ASP pages that pull data from a Microsoft Access database. The new ASP pages load a lot slower than their old static HTML counterparts. What

Question: Can I set up a live ODBC link from SQL Server 7 to an Informix (Standard Engine) database? Answer: You can set up your Informix server as a linked

Question: We want to timestamp transactions on an application that is not yet using a client/server database. Is there a Windows 2000 API that programmatically gets the server time? Answer:

Question: Why does a simple program such as the following produce compilation errors? #include#includeusing namespace std;int main(){ ostream_iterator os(cout); vector vi(3,0); os=vi[0]; os++; os=vi[1]; return 0;} I use the Microsoft

Question: Can I use LIKE across all columns in a single table without having to name each column specifically? Answer: You cannot do this as a direct query against a

Question: In the following code, how do I get the address of the first character of str in the function discard? discard(string *name){ //..}int main(){ string str; cin >> str;

Question: I have to admit, I’m new to the Exchange community. After extensive reading of various books and forums I have managed to configure and setup the IMS, etc. The

Whenever you access a database field through the Recordset object you incur in a slight overhead. Take for example the following code snippet: Dim rs As New ADODB.Recordsetrs.Open “SELECT au_lname,

Question: To make a long story short, we have a copy of the private and public EDB files. Is there a way to get the data out of at least

If you wish to retrieve from the department table all the department numbers that have at least one employee assigned to them, write the query as: select deptno, deptname from

Oracle8i provides a standard package, DBMS_PROFILER, which facilitates performance and code coverage analysis of your PL/SQL application. This package provides functions for gathering statistics, such as total number of times

Oracle8i has introduced database-level and system-level triggers. They can track events in the database such as logon/logoff from a schema, startup and shutdown of a database, and response to a

A temporary table has a definition or structure like that of a regular table, but the data it contains exists for only the duration of a transaction or session. Oracle8i

Oracle comes with a PL/SQL wrapper, which converts the PL/SQL source code into an intermediate form of object code. By hiding application internals, the wrapper prevents the misuse of your

If you have a table whose columns always are queried together, maybe you should store them as an index-organized table (IOT). An IOT is indexed on one or more columns

If you have a database function that has multiple return statements, try to minimize the exit points. I will explain with the following example: create or replace function getStatus(p_status_code in

Question: How do I make a beep in C++? I’d like to make my program alert the user in case of errors. Answer: Use the ‘a’ escape sequence to emit

Question: How can I run an Informix SQL Script from the Linux Operating System command line directly? Answer: Use this format: dbaccess The is the name of the database and

Question: Why doesn’t the datatype called sysname show up in all the tables’ dropdown lists of datatypes? Answer: The sysname datatype is a system datatype used to store database object

Question: I was trying to test a base class and I came across an unusual question: in the below code, why doesn’t the compiler complain about the return code type