Counting the Number of Records in
a Recordset
Editor’s Note: This tip is an update to a previous Tip of the Day. Jai Bardhan claims to have a “better solution” for counting records in a recordset. It is
Editor’s Note: This tip is an update to a previous Tip of the Day. Jai Bardhan claims to have a “better solution” for counting records in a recordset. It is
You can use the Visual Basic split function to convert a comma-separated string to an array. The function allows you to send a string as an IN parameter of a
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: 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: 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: 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 can do I write a query to retrieve a string with a specific number of characters from a field? For example, the “firstname” field has a name that
Question: I am building an e-commerce site with SQL as the database. When an order is placed, how do I have the database set the HandlingCharge column to 5 if
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