Question: Can I find information regarding the user and 4GL program or process that is locking an SE database record? I am using SE 5.08. Answer: I’m not sure about

Question: How do I find the top n records within a table for version 7? I have seen some similar SQL queries but cannot adapt them to version 7. Answer:

In the olden days, the use of floating point numbers imposed a significant computation and speed overhead compared to integer arithmetic. For this reason, many optimization guidebooks and IT veterans

A CPU cycle is roughly equivalent to the time needed for performing one instruction. On modern CPUs, a cycle takes about a nanosecond. In other words, a Pentium III 900

Although the Standard Library doesn’t define functions that convert Fahrenheit degrees to Celsius degrees and vice versa, you can implement them by yourself. These functions are particularly useful in localization

Some applications have special memory requirements. For example, they allocate large amounts of memory at once and then use it in parts, or they allocate only objects of the same

Many believe that a byte is by definition, an eight-bit data unit. Technically, this definition isn’t correct. A byte is a data unit with an unspecified number of bits. Indeed,

Question: I know there are two ways to insert a new record. One way is to execute a Insert statement, the other way is use the recordset.AddNew method. In terms

Question: I am developing a s/w with an Access database, using ADO. Now, I want to search a table with multiple columns. As in find method (ADO), it allows only

Question: I hope you can help me. My company is looking for training classes for XML on the West Coast (preferrably Portland, Seattle, or San Francisco area) I have been

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