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
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
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
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
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
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)
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
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
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