March 24, 1997

Selecting multiple rows

Question: I want to let the user select more than one row in a repeater so my application can act on all of them at one time? Answer: A repeater

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

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

Dates in String Variables

Question: I want to use a string variable with the date in it (format would be 02/22/96). How do I accomplish this? Answer: You’ll need to first convert the date

Embedded SQL

Question: What is Embedded SQL, and howis it used with the C language? Answer: As the name implies, Embedded SQL describes SQL statements that are embedded in a host language.

Simulating Multiple Outer Joins

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

Combining Columns of Different Types

Question: I am doing a select from a table where I want to combine two fields. Specifically, I have the StreetNumber andthe StreetName stored separately. I would like to beable

Inserting rows

Question: When I insert a row into a table, the results from the query that come after the row don’t show up. If I re-fetch the results, I can get

Flushing and Locking

Question: How can I set the flushing of rows to the database or the locking strategy used by Power Objects? Answer: Oracle Power Objects ‘supports’ two ways that rows can