devxlogo

Tip Bank

Listviews Item Selection

Question: How can I select the whole row (with a bigger blue line) in a listview control? The default selects just the item located in the first column. Answer: That

RAND Function

Question: I’m doing a select statement within a stored procedure, which returns several columns. I would like to assign a random number to each column, but when I use the

Changing the current directory

Question: How does one change the current working directory of a Java program or a java.lang.Process? The equivalent of the Unix chdir system call seems to be absent. Answer: There

pass variables to a pb app

Question: My PowerBuilder application is a contact system. It includes a case-based reasoning system that uses customer account numbers to guide users through actions. I need to be able to

Socket Buffer Size

Question: How do I set the socket input and output buffer sizes in Java? Answer: You cannot set the socket input and output buffer sizes in Java versions prior to

Exporting Select Query to CSV File

Question: Using the following SQL statement, I could export a select query into a dbf file at c: emp est.dbf INSERT INTO test IN ‘C: emp’ ‘DBASE IV;’ SELECT *

Documenting my tables, triggers

Question: We use SQL Server 6.5 (7 in a few weeks). I’m looking for a good tool to generate ERDs and overviews of my database tables. Which software can you