Question: How do I prevent corrupt indexes or automate the rebuilding of corrupt indexes? Answer: Prevent corrupt indexes by taking steps to prevent the crash of an application: 1. Consider

Question: I am generating Active Server Pages using Visual InterDev and VBScript. I have fetched all my records from the database through my ActiveX DLL into a collection variable. Can

Question: Is there a simple way to ascertain the names of all the controls on a particular form at run time? Answer: Every TComponent descendant has two properties, ComponentCount and

Question: I am trying to create a setup.exe for VFP 5.0, using the setup wizard. After I installed the application using the setup.exe and ran the program, I got error

Question: I have a Delphi 3 application running on a Novell network, that uses Paradox tables. For some reason, some of the users get the following message every once in

Question: I need a summary-select which summaries cumulative values. This one works in Microsoft Access: SELECT s.nl_item_id, s.nl_value, ( SELECT sum(sub.nl_value) FROM TABLE1 sub WHERE sub.nl_item_id

Question: Is there any way to fire a file deletion from inside an ASP page while the page is being unloaded? I am creating a file on the fly using

Question: How do I typecast text to LPARAM? LPARAM is supposed to be an integer, but clearly the API call wants text. I’m assuming I missed some pchar>string or pointer

Question: When the browser is pointed to a directory with no default HTML page then, in most cases, it shows the directory contents. Is it possible to create an HTML

Question: My executable takes almost a minute to run. How can I speed up the process? I am not running any queries at this point?I wait until I actually show

Question: How can I put a variable in a SQL string? For example: input:=edit1.text;query1.sql.add(‘select * from address where name like ‘); Answer: Since SQL.Add takes a string, all you need

Question: I need to create an onscreen invoice. I can figure out Supplier name, Customer name, and so on. But I can’t figure out how to do the body?for example,

Question: How do I add two label values together and submit the answer to another label? Label19.Caption := FloatToStrF(Table1Standard.AsFloat,ffCurrency,15,2)Label20.Caption := FloatToStrF(Table1Zero.AsFloat,ffCurrency,15,2)Label21.Caption := StrToFloat(????????? Answer: This is one of those things

Question: How can you convert Delphi to C++? Answer: I don’t know of any conversion tools out there that do this, though I could be wrong. If you’re using both

‘———————————————————‘ OverwriteHandler class” you can associate this class to a form, using the’ Form property, and all the textbox controls in the’ form will support insert/overwrite mode switching” Usage: Dim

You can create “polymorphic” routines that work with any type of array (except arrays of fixed-length strings, or UDTs) by using Variant parameters. Take for example the following code: Function

Many programmers don’t realize that it is perfectly legal to use the name of a function inside the Function itself, as if it were a local variable. This trick often

If you need a quick-and-dirty About dialog box for your application, that maintains a consistent look with other Windows applications, look no further than the ShellAbout routine in SHELL32.DLL. Using

At times you may want to return a Dos ErrorLevel when closing your VB application. This can be necessary, for example, if the EXE is meant to be called from

The Swing package, which is now a standard API package in Java 2, offers a new timer utility. This utility is implicitly threaded and lets you create as many timer

The SELECT element includes an options array that is accessible from JavaScript. You can use a loop to iterate through this array and count how many choices the user has

In Standard C and C++, the address of the first element past the end of an array can be used in pointer arithmetic. Thus, you can initialize a vector with

The Standard defines a side effect as a change in the state of the execution environment. Modifying an object, accessing a volatile object, invoking a library I/O function, or calling

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(); //

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