Tip Bank

DevX

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

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

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

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

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

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

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

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

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