Re: OO4O Data Control: NOT READY FOR PRIME TIME
Date: 1997/06/13
Message-ID: <01bc784d$6b9c1fa0$73f0eac7_at_haven>#1/1
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) READONLY Put two text controls on the form:
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