Tip Bank

DevX - Software Development Resource

DeleteRow(0) in DW

Question: Does DeleteRow(0) delete the current row or the row at the bottom of the datawindow? Answer: It deletes the current row.

DevX - Software Development Resource

Retrieving database table names using SQL

Question: I’m a database administrator for a medium-sized company. I would like to be able to retrieve the names of the tables within the company’s database using SQL so that

DevX - Software Development Resource

Resources on Compatibility Across Browsers

Question: I am involved in a project that requires the client-side embedded scripts to be compatible down to version 3 of Internet Explorer and Netscape Navigator. So far I have

DevX - Software Development Resource

Record Locking using LockEdits

Question: I am developing a multiuser application in Visual Basic 4.0 and wish to restrict users from editing Open or Locked records. Having successfully set up user security access and

DevX - Software Development Resource

SQL 6.5 or 7.0 Identity Problem

Question: I want to use replication between two SQL servers in which I used Identity properties in some tables. How can I preserve data integrity and maintain my application functionality

DevX - Software Development Resource

Find() function matching date values

Question: I am trying to use the find function using three char expressions and one date expression. I am using PB 6.5 with Oracle as the database. The following is

DevX - Software Development Resource

Table Name Substitution with a variable

Question: I have data that is broken into multiple tables depending on the month. For example: 99jan table99feb table These tables are all built the same and are very large

DevX - Software Development Resource

Shifting the Focus in a JavaScript Rollover

Question: I am creating a complex table of images, each with its own rollover effect. The problem I’m experiencing is that after the user clicks on the image, it retains

DevX - Software Development Resource

Slow view with lots of calculations

Question: I created a view that does a lot of calculations and references several tables. If I do a select * from linkview everything comes up instantaneosly. However, if I