November 30, 1999

Using a String as Part of a SELECT Statement

Question: Can I take a string that is held in a table and use it as part of a SELECT statement? I need to do this because I have a query that has been generated dynamically from a Web page and it has created a SELECT statement in a strange

Linking Two Databases in a SQL Query

Question: I have two databases, each on a separate machine in a network. I want to generate a report extracting data from table1 in database1 and table2 in database2. How do I link the two databases in my SQL query? Answer: First you have to identify the servers to each

SQL Using Like to Search for

Question: I have created a database of journal articles and want to offer users the ability to search the Author field for the surnames of authors. Most of the articles have more than one author so the Author field usually contains more than one surname. I set it up so

Can ADO Read and Write XML Files as Recordsets?

Question: Can the latest version of ADO (ActiveX Data Objects) read and write an XML file as a recordset? Answer: Ah, let me qualify that: ADO 2.1 can currently produce an XML file from a recordset using the IStream .save method, but it lacks the ability to write an XML

Modify XML Using DCOM From the Cache

Question: How can I modify and update XML docs that are stored in the cache using a DCOM model (client side)? Answer: Given that caching is an IIS (Internet Information Server) function, there are a couple of different ways that you can do a “simple” workaround, without having to write

Truncating the Last Five Characters in a Field

Question: How do I truncate the last five characters in a field? (The string length varies from row to row.) Answer: Try something along these lines: select left(myfield, datalength(myfield)-5)

Forcing a Linefeed in SQL

Question: How do I force a linefeed character using SQL? I created a report (see below) but when I e-mailed this report from Unix the carriage return was not interpreted correctly. I want the results to look like the following: Invoice Number: 123456Order Number: 444422222Customer Number: abc123 When I e-mail

Select Statement Not Working

Question: I am trying to code an event that will transfer information from the current form into the display of another form. Information like company name and address, and contact information. This should be done when I double-click on the DBGrid, which opens another form where I will have the

Using XML Within VBA

Question: Does XML work with VBA (Visual Basic for Applications)? I’m looking for a quick and easy way to store variable information that will be static once it has been entered. I’m currently using Microsoft Excel. The user enters information that is specific to themselves, and then my VBA app

No more posts to show