Tip Bank

DevX - Software Development Resource

SQLCODE Error -0000019514

Question: When I do aDECLARE CURSOR FOR SELECT, it returns a SQLCODE = 0. When I do an OPEN CURSOR, it also returns a SQLCODE = 0. But I have

DevX - Software Development Resource

Validation of Textbox

Question: How do I validate a textbox, which doesn’t have any control source, so if it’s empty it should not lose the focus until the user enters some value? Answer:

DevX - Software Development Resource

Insert and Amend Datestamps

Question: I have a table in Informix that is changed regularly. The records have no datestamp, so how do I get the date/time of amends and inserts to this table

DevX - Software Development Resource

Exchange 2000 and Multiple Domains

Question: How do I get multiple domains in Exchange 2000? Answer: I’m not sure what you mean by multiple domains in Exchange. Exchange 2000 allows you to have only a

DevX - Software Development Resource

Multiple Inserts Error

Question: What does the following Informix error message mean, and what can I do to prevent it: “could not position within a file via an index” It happens when I

DevX - Software Development Resource

Alternative Sharing for Outlook Folders

Question: Can we publicly share Outlook folders in Outlook 97, without using Microsoft Exchange Server? Answer: The easiest solution for you would be to upgrade to Outlook 2000 and use

DevX - Software Development Resource

Get SQL Before Execution

Question: Is there any way to capture SQL at the transaction object level? Answer: If you are using a datawindow/datastore object, then you can add code to the SQLPreview event

DevX - Software Development Resource

No Soctcp Option

Question: I’m installing IDS 7.3.x on Sol 2.6 with Connect 2.01, and when I attempt to initialize through onmonitor, I do not get an option for soctcp. I’ve even tried

DevX - Software Development Resource

BUILD Date

Question: How do I capture the build date in PowerBuilder 6.5 and put it in an instance variable? Answer: Yes. You need to declare a constant integer variable and assign