Question: Is there a way to capture the last value (digit) of the system clock number and use that to generate a random number? Or look at system clock–find last

Question: Where is the best place to store .property files and .xml files for servlets/jsp? Right now I am using “user.home”, but there is a problem when you have multiple

Question: Can I cast an unsigned integer to an enumerator? If so, could you provide an example? Answer: You can use static_cast to cast an int to an enumerator. However,

Question: With the following: friend int operator == (const cs303Point& point0, const cs303Point& point1); in my .h file, how should the first line of the function definition look in the

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