Subject | Newbie TIBOTABLE master-Detail |
---|---|
Author | chirug2003 |
Post date | 2004-07-10T19:11Z |
I've just started evaluating IBO and bought the 'Getting started
Guide'.
I've previously used Paradox.
I'm having difficulty with a simple test database I constructed to
learn
IBO.
Database contains 2 tables
MASTER
DETAIL
MASTER has 2 fields
ID Filled with a Generated value and required. Primary Key
CODETYPE VarChar(2) required with a default of 'PE'
DETAIL has 2 fields
ID Primary Key and Foreign Key on MASTER.ID required
COMMENT VarChar(20) not required
Set up a test form containing
TIBODatabase connected to TestDatabase
TIBOTable.MASTER with a Delphi VCL datasource (since I want to
use
InfoPower)
Keylinks: MASTER.ID
I have also set the Generator and Default values for the
MASTER.
TIBOTable.DETAIL with a VCL datasource
Keylinks: DETAIL.ID
MasterSource: MASTER
MasterLinks: DETAIL.ID=MASTER.ID
NavigatorBar connected to TIBOTable.MASTER datasource
Dripped simple VCL data-aware editing fields on the form for all the
fields
in MASTER and DETAIL.
Put MASTER into insert mode - MASTER.ID and MASTER.CODETYPE fill
automatically as expected
Start entering values into fields of DETAIL and DETAIL.ID fills with
the
value generated for MASTER.ID - fine so far DETAIL is automatically
going
into insert/edit mode. Once all DETAIL fields have been completed I
Press
the Post key on the navigator bar (which is attached to MASTER).
This is where my understanding of what should happen breaks down:-
MASTER posts correctly and remains displayed with it's values
DETAIL goes blank - all fields - with no error or other
messages. If I look at the table through a SQL utility it confirms
that no values are in DETAIL.
What has happened?
Peter
Guide'.
I've previously used Paradox.
I'm having difficulty with a simple test database I constructed to
learn
IBO.
Database contains 2 tables
MASTER
DETAIL
MASTER has 2 fields
ID Filled with a Generated value and required. Primary Key
CODETYPE VarChar(2) required with a default of 'PE'
DETAIL has 2 fields
ID Primary Key and Foreign Key on MASTER.ID required
COMMENT VarChar(20) not required
Set up a test form containing
TIBODatabase connected to TestDatabase
TIBOTable.MASTER with a Delphi VCL datasource (since I want to
use
InfoPower)
Keylinks: MASTER.ID
I have also set the Generator and Default values for the
MASTER.
TIBOTable.DETAIL with a VCL datasource
Keylinks: DETAIL.ID
MasterSource: MASTER
MasterLinks: DETAIL.ID=MASTER.ID
NavigatorBar connected to TIBOTable.MASTER datasource
Dripped simple VCL data-aware editing fields on the form for all the
fields
in MASTER and DETAIL.
Put MASTER into insert mode - MASTER.ID and MASTER.CODETYPE fill
automatically as expected
Start entering values into fields of DETAIL and DETAIL.ID fills with
the
value generated for MASTER.ID - fine so far DETAIL is automatically
going
into insert/edit mode. Once all DETAIL fields have been completed I
Press
the Post key on the navigator bar (which is attached to MASTER).
This is where my understanding of what should happen breaks down:-
MASTER posts correctly and remains displayed with it's values
DETAIL goes blank - all fields - with no error or other
messages. If I look at the table through a SQL utility it confirms
that no values are in DETAIL.
What has happened?
Peter