Tip Bank

DevX - Software Development Resource

Deleting Fields from Recordset Object

Question: I am using a disconnected recordset (adOpenStatic, adUseClient) which is obtained by executing a stored procedure using command an object. I tried to delete some fields from the recodset

DevX - Software Development Resource

Clearing the Screen

Question: What is the “clear screen” function in C++, and which library is it in? Answer: Standard C and C++ don’t define a function that clears the screen. DOS and

DevX - Software Development Resource

Best Method for Inserting Rows

Question: From a database-efficiency standpoint, which is better for SQL when inserting new rows into a table: issuing ad hoc SQL statements in the form of “Insert Into…” or using

DevX - Software Development Resource

Pros and Cons of Extended Stored Procedures

Question: What are the pros and cons of creating extended stored procedures? Answer: The pros are that you can implement additional functionality and access data from DLLs from within SQL

DevX - Software Development Resource

SQL Summary

Question: How do I print out all of the tables, the fields the tables contain, and the datatype of the fields in my accounting database (for report creation)? I am