November 20, 1998

DevX - Software Development Resource

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

DevX - Software Development Resource

Rich Text Edit – Syntax Highlighting

Question: I’m building an application where the user can type several lines of text and save it to disk (as plain text). It would be nice if some words appeared

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

Using a stored procedure like a subquery

Question: I’m trying to get something like this to work. How can I take the output of a stored procedure and use it in a subquery? create procedure pcore asselect

DevX - Software Development Resource

Cannot index

Question: SQL Server 6.5 does not allow an index to be placed on the bit datatype. Does this affect performance when doing queries that filter on the bit, or are

DevX - Software Development Resource

Sort by date

Question: In a project tracking database, one of the columns in a table contains the date in this format: MM/DD/YY. I would like to be able to see a listing