Question: We have Informix-Online Dynamic Server Version 5.1 running on Sun 4 architecture machines (Sparc 4, Sparc 5, etc.). We plan to upgrade some machine to Ultra 2. I just

Question: I’m using Web Datablade and IIF to develop Web pages. I need validation (other than JavaScript) on date inputs. How can I validate dates on IIF, using SPL or

Question: I am trying to install Informix on Windows NT Server. After installation, I get the following error (after restarting): Columns: 80 Keyboard rate: 31 Keyboard delay: 1 Code page:

Question: I have a bad chunk in a dbspace that is bad and marked “down” by Informix. I don’t really care about the data in that chunk anyway, so I

Question: I am quite new as an Informix DBA. Our company is currently running the Informix 7.31 32-bit version on a 64-bit processor. They are thinking about upgrading to a

‘ Evaluate the number of business days between two dates” Note that it doesn’t take Christmas, Easter and’ other holidays into accountFunction BusinessDateDiff(ByVal StartDate As Date, ByVal EndDate As Date,

While VB Timer functions is sufficiently precise for most tasks, it doesn’t provide the highest possible resolution most modern computer can provide. If your hardware supports high-resolution counters, you can

The Timer control is great when you want to periodically execute a piece of code while the program is doing something else. However, it also has a couple of shortcomings:

The GetTimeZoneInformation API returns a TIME_ZONE_INFORMATION variable that contains several pieces of information about system’s time date and time setting. The first Long value in this structure holds the “distance”

‘ add or subtract a number of business days from a date” Note that it doesn’t take Christmas, Easter and’ other holidays into accountFunction BusinessDateAdd(ByVal days As Long, ByVal StartDate

Question: Can I have multiple line headers on grids? Answer: No, you cannot have multiple line headers on grids in VFP, but you can simulate them by overlapping a shape

Question: I am new to VFP. I want to create a unique number for a customer ID field in a table. The VFP sample program “tastrade” simply uses NEWID() as

Question: I’m getting the first “page” of data from a table and I’m wondering about getting the next page… I’m using the query: SELECT TOP 50 ID, Name, Address, Phone,

Question: Why can’t I run an application like ws-ftp from SQL with xp_xmdshell? ws-ftp will start, but it’s not visible on the screen. Answer: xp_cmdshell runs in the space of

Question: I am using SQL Server 7 and would like to convert an uppercase string to proper case. Is there an easy way to do it? Answer: SQL Server has

Question: What is the best way to backup and/or unload a table and restore/reload to a new dbtable with new extents? Answer: If you have enough drive space, do an

Question: I have code in Visual Basic that allows a user to search the Registry and return a value from the passed key and path. Can you show me a

Question: I have a listbox with two properties called DisabledItemBackcolor and Forecolor. How can I disable single items in the listbox? List.Enabled(ItemID)=.F. disables all items (like the Enabled-Property itself). You

Question: I want to construct an SQL query or stored procedure that will order its result set based on a query parameter. Something like: SELECT *FROM customersORDER BY ? Unfortunately,

Question: How do I combine multiple text fields into a single field? For example, combining someone’s first, middle, and last name into a field called “full name”. I’ve done a

Question: When in production (several users), my Web application starts getting empty cursors when querying the Informix server. I’m sure the ‘right’ results are not empty. Also, I’ve seen, using

Question: How do I create a stored procedure to obtain a substring of a char field from the first “[” encountered until the last-1 character? For example, I have a

Question: How do I set up a field in a table to accept the current date and time? And how do I insert the current time/date into this field? Answer:

Question: I am using Hyperscript Tools for Informix on a Unix platform. To receive the current date and time, the NOW() function is used to get a value between 0

Question: I’ve written several dynamic queries in VB importing a recordset from an Informix DB. The isolation level shows “Committed Read.” Does this place locks on the DB? Answer: Committed

Question: Is there a command in Visual FoxPro 6.0 that is similar to the Microsoft Access “AutoNumber” feature? The field automatically generates a record number for each record. Answer: There

Question: Can I compare the DATE field with Visual FoxPro? How would I structure a query to select all records in a table that had a date value after 02/08/99?

Question: How can we specify in a select statement to get first “n” records from the result set? E.g., select * from employee order by emp_num I just want the

Question: I’m trying to install the of Informix for WinNT and during the process I get error number 126? Answer: Have you rebooted your system after installing the ODBC? It