Tip Bank

DevX - Software Development Resource

ASP Error: ODBC Driver General Error

Question: I have been receiving the following (albeit general) error sporadically: “Microsoft OLE DB Provider for ODBC Driverserror ‘80004005’ [Informix][Informix ODBC Driver]General error.” This error has occurred when the code

DevX - Software Development Resource

Cursors in Informix

Question: What is the purpose of using the fetch and declare cursor in Informix.4GL?How do you use the scroll cursor, and what are its advantages? Answer: Cursors allow you to

DevX - Software Development Resource

Releasing Database Locks

Question: How can I release all existing database locks for all the sessions a specific user has started? Answer: The easiest way probably is to log that user out. Otherwise,

DevX - Software Development Resource

The hidden Collect method of the Recordset object

The ADO Recorset object exposes a hidden, undocumented member: the Collect property. This property is functionally similar to the Field’s Value property, but it’s faster because it doesn’t need a

DevX - Software Development Resource

Create a Table with Autonumbering

Question: I’ve tried to create a table (for my guestbook) with an auto increment column. Here’s my statement: CREATE TABLE guestbook(id mediumint(8) NOT NULL KEY(PRI) default(0) auto_increment, name varchar(30) NOT

DevX - Software Development Resource

Embedding Applets in XML Documents

I came across this solution while trying to embed an applet in an XSL page I was using to transform my XML source document into HTML.If you want to cut

DevX - Software Development Resource

Let the user copy floppy disks

The simplest way to help user copy a floppy disk is display the Copy Disk system dialog. You can do this with a one-line statement: Shell “rundll32.exe diskcopy.dll,DiskCopyRunDll 0,0”