Since 1998, DevX has helped people start businesses, build websites, and provide enterprise technology to people globally. Interviewing the likes of Microsoft’s co-founder, Steve Ballmer, the publication brings comprehensive, reliable, and accessible insights to the Internet.
xtensible Stylesheet Language (XSL) has slowly been gaining a reputation as the SQL of the hierarchical data world. Even with only the partial implementation that Microsoft’s XSL offers, you can
ven though the Java Virtual Machine performs automatic garbagecollection, you can’t completely forget about memory managementissues. How and when garbage collection is performed isimplementation dependent. Some JVMs will wait until
n last month’s 10-Minute Solution, you learned how to display selective data from a database based on the user’s choice. This time you’ll see how to improve and optimize this
n designing a relational system, the simplicity of each individual relation belies the complexity engendered by the multiplicity of tables created by implementing that model. However, simply by observing “good
y now I am sure that many Visual Basic developers are leveraging their Visual Basic skills to do some Web development. In this Solution, I’ll cover DHTML Behaviors, a new
isual Basic offers many methods for sharing data within an application. When we talk about sharing data, there are several possible levels of sharing: Within a procedure Within a form/code
Question: How do I design a matrix using XML? This matrix needs to be a separate tree from the main XML tree. How do I communicate between the two trees?
Question: I am using the XMLHTTPRequest object in Visual Basic to invoke an async call. How do I register a complete event handler of the XMLHTTPRequest object? Answer: You’re not
Question: I’m using MSXML to create a DOMDocument and add nodes and attributes. When I’m done, I’d like to save the XML text into a string. Unfortunately, the Save method
Question: I’m looking for sample database in a form of Create Table statement+Insert statements and beginner-level assignments using this database. Do you know where I can find something like that?
The new FlatScrollbar controls expose the ability to selectively disable their arrows. This is useful, for example, when the thumb indicator is at its minimum or maximum: Private Sub FlatScrollBar1_Change()
Most VB controls don’t let you determine whether they should display a scrollbar or not. For example, a VB ListBox control displays a vertical scrollbar only when the number of
The VB CommandButton control supports neither the ForeColor nor the BackColor properties. If you want to create colorful buttons without resorting to 3rd party controls, you can use an OptionButton
By default, VB’s CheckBox controls automatically toggle their Value property when the user clicks on them. This is usually the desired behavior, but at times you may want to be
The ComboBox control doesn’t expose any property that lets you to control the width of its list area, but this can be easily accomplished by sending it the CB_SETDROPPEDWIDTH message,
Unlike the TextBox control, the ComboBox control doesn’t expose any MaxLength property, so you have no means of limiting the numbers of characters typed by the end user in the
Contrary to common belief, Debug.Print statements are not always removed from an executable. This behavior can be demonstrated easily. Open a new project, place a single CommandButton on the default
It’s possible to streamline some calculation procedures in Excel and add calculation capabilities that don’t exist in Word. Unfortunately, most textbooks on VB for Office 97 are focused on nonmathematical
Because server/client round-trips are inherently inefficient, you should try to eliminate the need for excessive round-trips. When you design a class or a user-defined interface, you should never expose three
In C, algorithms that rely on pointers such as bsearch() and lfind() return a null pointer to indicate that the sought after element wasn’t found. Unlike a pointer, a reference
Enhancements to the lock manager in SQL Server 6.5 provide row-level concurrency for INSERT operations. Properly implemented rowlock increases the speed of multi-user INSERT operations. Insert rowlock (IRL) is OFF
Similar to GzipServlet, this tip uses header information for tuningoutput of our servlets; this one allows you to check the header ‘Accept-Language’. If your user has set some language preferences
You can mark an ASP page with a transaction support property, just as you can do with a registered MTS component. An ASP scripting object thus can serve either as
Question: I’m having a problem writing a SELECT statement that will compares a date stored in a table against the current time. This is for a calendar on a Web
Question: I am using Exchange Server 5.5 and Outlook 97 on about 30 workstations. I use a public folder to store shared contact info. On all but two of the
Question: In Microsoft Access you can use a query as the source for a select in a second query. Additionally, you can use two queries as the source by utilizing
Question: I have a Visual Basic project about a video store, for which I have to produce a report that includes the following: Top 10 movies last month Number of
Question: I have a Web page that lets the user query my database and return results in groups of 50 records. I know how to do the first SQL statement
Question: How do you list available tables and their schemas from an SQL query? Answer: There is an owner in the database called INFORMATION_SCHEMA who has a bunch of objects
Question: How do I convert a character string into a time field? Data is being read in as 12:10 and I need to calculate response times based on this field.
