Tip Bank

DevX - Software Development Resource

How do I add sound to my app?

Question: I have searched high and low and cannot seem to find a code example of how to add sound (attach a WAV file) to the opening of my application.

DevX - Software Development Resource

Application Versioning

Question: Is there an easy way for Powerbuilder developers to version their apps for releases (Major.Minor.Revision)? Is this built into PB? Answer: No, you have to do this manually with

DevX - Software Development Resource

Order by

Question: I can’t sort by the second-last digit of a number (for example, sorting the numbers 4491, 1195, and 1364 by the third digit). Answer: Try using the “RIGHT” function

DevX - Software Development Resource

Timeouts on Socket Creation

Question: I am trying to open multiple sockets at differing IP addresses. Is there a way to make it so that the open socket call will wait for only two

DevX - Software Development Resource

Maximum SQL database size recommendations

Question: Are there specific recommendations for the maximum size of any database? For instance, does performance suffer if the database size is too large? Answer: Certainly, the amount of data

DevX - Software Development Resource

Character Sets Available in SQL 6.5

Question: We’d like to find a table or listing of all the character sets available in SQL Server 6.5. Is there any way to get this from the Charset files

DevX - Software Development Resource

Migrating to SQL Server and Keeping Novell 4.1

Question: Our business expects to migrate to a SQL Server base. We have two servers&#151the platform is Windows 95/Novell 4.1. Our manufacturing vendor application is upgrading, and it requires a

DevX - Software Development Resource

SQL 6.5 Stored procedure

Question: Is it possible in SQL 6.5 to write a stored procedure that has an ARRAY as an input parameter? I have done this with Oracle using Oracle Objects for

DevX - Software Development Resource

Check contraints

Question: I have a primary key (client id) of five characters which contains: character # 1: A-Z character # 2: 0-9 character # 3: 1-9 character # 4: blank or