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: Does Informix 9.20 have a memory leak? We’ve doubled our physical memory since upgrading, taken a number of tuning actions, but the product keeps grabbing more memory. No appreciative
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 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: 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 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: When I use the BROWSE command it always displays the results in a normal window. Is there a command to maximize the browse window in the program? Answer: The
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 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