Tip Bank

Prompt is a dynamic property that OLE DB providers can use to allow the user to input customized initialization information, typically through a dialog box. The OLE DB provider may

Question: What can I use in SQL that does the same thing that IIF(test,TruePart,FalsePart) does in Access? Answer: You can achieve the same result using the aggregate function COUNT and

Question: How do I convert Informix data under Unix to a text file? Answer: You can do this by using a SQL UNLOAD command: UNLOAD to textfilename.unl SELECT * from

Question: Is it possible in VB 6.0 to include pieces of code through an include- or importstatement like the C #include-preprocessor command or the Cobol copy-statement? Answer: You can add

Question: How do I convert Informix Database to SQL Server 7, or even to Access? Answer: First, you need to create the identical database in SQL7 or Access (same field

Question: My SQL statement at the moment is: SELECT * FROM NewsItemsHow do I sort the dates in descending order? Answer: Use the ORDER BY clause to sort the results

Question: Can you put a variable within quotations?For example: Shell “Explorer.exe (?var)” Answer: You have to concatenate the two strings together. If your variable is named var, you would call

Question: Is there an ODBC driver that can connect our existing Informix database on Unix to SQL Server 7.0 on NT 4.0? Answer: Yes. You need to run the Informix

Question: How do I create a simple WML application with JSP and Beans? Answer: Be sure to set your content output type appropriately and just have it generate the WML.