Tip Bank

Question: How can I hide the command window when a project is running? Answer: To hide the command window, issue the following command in your code: HIDE WINDOW COMMAND

Question: Given the XML file: Sometimes we want to display name1 and sometimes name2. We figured that perhaps we could set a parameter. Then we could pass in the name

Question: The BDC was the exchange server, and now it can’t see itself as BDC or a server. It shows on the SERVER MANAGER as a workstation. We have a

Question: Can I create a table in a stored procedure named from a parameter? Answer: You can dynamically create tables with variables, but you need to create a string and

Question: How do I get the rowseffected from the execute method of an ADO command object?The code I’ve written is: Dim Cn as New ADODB.ConnectionDim Cmd as New ADODB.CommandDim Recordset

Question: Can you use the indirection operator like a memcpy to copy the contents of a structure like this? *m_pMyInfo = stMyInfo; Or should you use the memcpy function? memcpy(m_pMyInfo,

Question: How do I count the number of duplicate items in a table? Answer: Lets break down your question into several steps.First, let’s create a sample table using the following

Question: How do I write a query that does an insert and returns the newly assigned ID from that field, all at one time? Answer: The @@IDENTITY variable returns the

Question: While converting source code from C to C++, I came up with difficulties in converting error handling routines like err_quit(),err_sys(),etc. Are there C++ versions of these functions and where