Re: OO4O Data Control: NOT READY FOR PRIME TIME

Here are the details for reproducing error 1407 with the Oracle data control:

Create 2 tables in Oracle:

TABLE: PEOPLE

ID		NUMBER(8) Primary key NOT NULL
NAME		VARCHAR2(20) NOT NULL
FLAVOR	NUMBER(8)

TABLE: FLAVORS
FLAVOR	NUMBER(8) PRIMARY KEY NOT NULL
FLAVORDESC	VARCHAR2(20) NOT NULL UNIQUE

Populate the tables (e.g. 1, Bill;2, Tom; etc) and (100, Chocolate; 200, Vanilla; etc)

Create a VB(4)/32 form with two Oracle data controls.

dcPEOPLE:	(select * from people)  UPDATABLE
dcFLAVOR:	(select flavor, flavordesc from flavors order by flavordesc) READ

ID		bind to dcPeople		ID
NAME		ditto			NAME

Put a DBCombo on the form:
Bind it to dcPeople FLAVOR and get the data to populate the dropdown list from dcFLAVOR. FLAVORDESC is the LISTFIELD and FLAVORS.ID is the list field that gets bound to PEOPLE.FLAVOR.

I trust the example is largely self-explanatory: you're simply going to associate a flavor with a person by storing a key from FLAVORS in a row in PEOPLE. Open the form. Choose a flavor from the combo. Try to move to the next record using the data control's VCR button. This is where error 1407 occurs.

Tim Romano
Swarthmore PA Received on Fri Jun 13 1997 - 00:00:00 CEST