Basic FoxPro SQL
Question: I’m trying to retrieve eight fields from four FoxPro tables via on-the-fly SQL from an ASP page… and I’m not familiar with FoxPro SQL. The following doesn’t work, but
Question: I’m trying to retrieve eight fields from four FoxPro tables via on-the-fly SQL from an ASP page… and I’m not familiar with FoxPro SQL. The following doesn’t work, but
Question: Is it possible to count the number of records and, when that count is reached, insert a header/footer to an exported text file using VBScript in DTS? If so,
Question: I want to change the format of the default e-mail message (IPM.Note). I have created a new form, but want it used whenever the user selects “New Message.” (I
You’ve probably wanted to limit the normal operations of a form, such as resizing it, preventing it from being minimized or maximized, or allowing it to be closed only when
This great add-in lets you analyze one or more VB projects, and lists all the dependencies from each other and from other DLLs and type libraries. This is an exceptional
If you want to play a track of an audio CD from VB you can use MCI functions. The main MCI function is mciSendString, that sends command strings to the
With MCI functions you can play an AVI movie into a PictureBox. All you need to do is open the file with a special procedure: Declare Function mciSendString Lib “winmm”
You can use MCI functions if you want to record a WAV file. The main MCI function is mciSendString, that sends command strings to the system and execute them. Declare
If you want to play a MIDI file from VB you have to use MCI functions. The main MCI function is mciSendString, that sends command strings to the system and
To retrieve the original size of an AVI file that you’ve already opened with the mciSendString API function you can use this command Dim RetString As StringRetString = Space$(256)CommandString =
If you want to play an AVI movie from VB you can use MCI functions. The main MCI function is mciSendString, that sends command strings to the system and execute
Java bytecode contains information in your Java source files. This byte code is generated by the java compiler as per an explicitly documented specification. It is not impossible to reverse
Javadoc is a program shipped with JDK that you can use to run over your source code to produce documentation of your classes in the same type of HTML files
Above IE 4.0, you can use a different syntax for importing the contents of a .css file. The general way is to link to the external .css file. However, when
HTML DIV tags can be used to center a table within a page. DIV tag Related Posts DevOps Tool Vendor Chef Raises $40 MillionPaytm reshuffles executive roles for strategic boostUsing
Object size can be used to display an image in a Web page. However, when using the Object element to display an image, an image size is necessary. The code
Version 1.3 of Java 2 platform, currently in Beta, has a new java.awt.Robot class that lets you generate mouse and key events at system level. You can use this to
Snapshots are faster to open and scroll through than dynasets. Dynasets are updateable result sets whereas snapshot record sets are not updateable. However, you should not use dynasets if you
If a computer running SQL Server is running too slowly, then the SQL Server Profiler may have too many traces or it may have a complex trace running. To improve
The memory for the temporary copy of an exception that is being thrown is allocated in a platform-defined way. Note, however, that it may not be allocated on the free
Find function is used to locate a particular string in a dynaset or snapshot type recordset using a comparison operator. In general, it is better to create a new query
You can take the addresses of a class’s static and non-static member functions. However, the class’s constructor(s) and destructor are an exception to the rule. You cannot take their addresses
You can optimize data access to remote servers by adjusting the size of the network packet. Configuring the packet size provides a choice between responsiveness and overall throughput. Larger packets
You can enable the “Boost SQL Server Priority” option, to allow SQL Server threads to run in the real time priority class. When running at this priority level, SQL Server
You can set SQL Server to display information regarding the amount of disk activity generated by T-SQL statements. This option displays the number of scans, the number of logical reads
You can create an aggregate column in a SQL 7.0 table by specifying it during creating the table itself. This is useful if you want that aggregate column to be
This T-SQL command can be used to display the number of milliseconds required to parse, compile, and execute each statement. When SET STATISTICS TIME is ON, the time statistics for
In DAO recordset, there is no separate refresh command to refresh the current recordset. However, you can call Move member function to position the recordset lRows records from the current
In standard C++, declaring arrays with zero elements is illegal: int n[0]; //illegal However, certain compilers do support arrays of zero size as non-standard extension. In contrast, dynamic allocation of
While the overhead of returning an ordinary object by value may be acceptable in most cases, returning a container by value is much more expensive in terms of performance. For