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

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.

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

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

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

Question: I can’t seem to clear the default menus in a modal dialog box. I have triedall types of code in the OpenModal() method, but the default menusstill appear. How

Question: I am using the Japanese version of OPO. Occasionally, I get an error messagethat says ‘Failed to lock row.’ It doesn’t happen all the time. What makesOPO lock a

Question: It seems like I cannot define my own data structures in OPO. I want to create an variable that actually consists of different underlying variables – a string followed

Question: I want to be able to start a section of code if nothing is happening in an application. This type of ‘null’ method is useful for default tasks. How

Question: I want to manipulate a check box in a repeater control, but the check box is not bound to any data column. How can I do this? Answer: Every

Question: I want to create a list box that will contain values based on the value ofanother list box. How can I accomplish this? Answer: A list box is populated

Question: I am using custom toolbars in my application. When I call the QBF form, ithas a default menu bar. How can I get rid of this? Answer: While 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 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

Question: What are the major strengths of a RDBMS when compared to anODBMS? Answer: Most ODBMS today are still weak in the area of security, so if you are planning

Question: Under which circumstances should I consider an object database management system (ODBMS) instead of a relational database managementsystem (RDMBS)? Answer: There are some specific types of applications that are

Question: I’ve heard a lot of talk about “client-server architecture” ? is it something real, or just marketing hype? Answer: Indeed, client-server architecture is real. Put simply, the client-server model

Question: What is the OnKey() method? Answer: The OnKey() method is a new method introduced with OPO version 1.0.16. The OnKey() method is triggered for an object whenever a user

Question: When I open a session to an Oracle database, I can’t see any tables other than those owned by my user name. How can I get access to tables

Question: Can an OPO application act as an OLE client and use OLE automation with an OLE server? Answer: OPO Version 2.0 can act as an OLE server, but not

Question: I want to use a unique compound key, with a string columns and a numeric column, in my table. Since Blaze does not support compound keys, I will have

Question: Whenever I try to reference an object in a repeater, I get an error message telling me that “Repeated control can be used only in aggregation function”. How can

Question: How do I open up a blank form – a form without any values displayed? Answer: As you probably know, you can add a DefaultCondition to your form, such

Question: I am using the EXEC SQL command to insert some data into a database on the CommitForm()method of a form, but the data is not showing up in the

Question: When a user selects a value from a list box, I populate the contents of arepeater. I also want to set the focus into the repeater’s first field.How can

Question: How can I define a function that is not associated with a particular form? Answer: You can define an function that is not associated with a particular form by

Question: When I set the FormatMask property for a data field object, the value of the field is formatted when a user enters data and tabs out of the field.

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: Is there a way to send mail with a mouse click? I’m working on a Mac and in Windows. Answer: You can send mail, or do virtually anything else