Tip Bank

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

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

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,

Question: I have about 50 users on an “old” Exchange Server (version 5.0 SP2), and I need to move them to a new server. The problem is that the new

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

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

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

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”

If you want to execute an application and waiting for its termination, you can follow two approaches. The “classic” approach is based on API functions such as OpenProcess, WaitForSingleObject and