Tip Bank

DevX

How can I create VRML pages?

Question: What can I use to produce VRML, or can I write it like HTML? Answer: It is possible to write VRML as a purely text-based language, using a regular

DevX

Creating Views

Question: I’ve got a “new user” question for you. Some of the tables in our databaseshave several columns containing data that’s not used very often. When I’musing ad-hoc queries, it

DevX

Data Replication as a WAN Solution

Question: I have nine offices. I want each office to connect across aWAN and run client/server applications with all datacontained on one central server. However, we are finding the delays

DevX

Adjusting for Deleted Rows

Question: How do I create a column with a row ID that adjusts if a row is deleted?That is, if I had numbers 1,2,3,4,5,6 and I delete record 3, record

DevX

User changes

Question: I want to be able to take an action when a user changes the value of a data field, but not when the value of the field is changed

DevX

Forms without MDI

Question: I want to have a form that does not appear in a MDI (multiple document interface) frame. Can I do this? Answer: In Version 2 of Power Objects, you

DevX

Tables in a session

Question: When I open a session to my Oracle database, I can only see tables that are owned by my user name. How can I get to see other public

DevX

Stored Procedures

Question: What are the common uses of stored procedures? Answer: Many databases use stored procedures and/or triggers to implementreferential integrity [ensuring that data referenced by another tabledoesn’t get deleted or

DevX

Delimited Data

Question: Is there a quick and dirty way to export a delimited datasetvia a simple query? I would like to get something like: value1,value2,value3(The delimeters could be commas, semi-colons, etc.)