Tip Bank

DevX - Software Development Resource

Outlook Web Access

Question: When trying to create an e-mail from OWA the following error message appears: ‘Your message body is too large. OWA only supports message bodies up to 100K…’ This message

DevX - Software Development Resource

FoxPro Syntax

Question: I was told that aMemo and alines are FoxPro commands but I can not find them in FoxPro help. Is my version of FoxPro too old? I am on

DevX - Software Development Resource

Locking Rows

Question: We are developing an intranet application using visual interdev on windows 2000 and our informix database is on unix. We are using stored procedures and the ‘begin work’ and

DevX - Software Development Resource

Creating Tables in a Stored Procedure

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

DevX - Software Development Resource

RecordCount Property-ADO

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

DevX - Software Development Resource

Indirection Operator

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,

DevX - Software Development Resource

Counting Duplicate Rows

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

DevX - Software Development Resource

Return ID in Same Query as Insert

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

DevX - Software Development Resource

Error Handling Routines

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