Tip Bank

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

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

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

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.)

Question: [Joe Celko’s Consultants Puzzle]Brian K. Buckley posted a version of the following problem on the PowerSoft CompuServe forum in the WATCOM SQL section in 1994 November requesting assistance. He

Question: How would I change the following statement to yieldonly unique values? select * FROM WEBDBASE where ST = ‘#State#’ AND #SPECIALTY# = ‘x’; Answer: You can’t get unique values

Question: What are the differences between LEFT, RIGHT, INNER and OUTER JOINS? Answer: An INNER JOIN is the most common type: It combines all the data from the tables specified

Question: I’ve been trying to construct a query on the databaseto see if the value in a particular field matches a long list of correct answers. For example, I would

Question: I want to use many instances of a class in my form, but can’t seem to figure out an easy way to check on the status of all the