Tip Bank

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

Question: Our business is just starting to look at using a relational databasemanagement system. We are currently using computers, but the usershave their own copies of whatever data they need

Question: I need to query a database with outer joins on more thanone table, and am finding that my database doesn’t support it.Is there any way to work around the

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