Subject | Re: [IBO] Master detail problem when lenght of the link field is more than 25 chars |
---|---|
Author | Hans Hoogstraat |
Post date | 2004-08-03T19:33:11Z |
Found no problem and I'll email you my little test.
Test1: MasterDetail link via a Generator
Test2: MasterDetail link a 50 char field.
I prefer to use the Generator links and the 50 char field as a field in the
master,
since that is much faster and less prone to problems in a multi user
environment
----------------------------------------------------------------------------
--------------
Test1: MasterDetail link via a Generator
Test2: MasterDetail link a 50 char field.
I prefer to use the Generator links and the 50 char field as a field in the
master,
since that is much faster and less prone to problems in a multi user
environment
----------------------------------------------------------------------------
--------------
----- Original Message -----
From: "Mihai Chezan" <gsmcq@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, August 03, 2004 12:49 PM
Subject: [IBO] Master detail problem when lenght of the link field is more
than 25 chars
| CREATE TABLE dep (
| id_dep INTEGER NOT NULL,
| name VARCHAR(50) NOT NULL,
| CONSTRAINT dep_pk PRIMARY KEY (id_dep)
| );
|
| COMMIT;
|
| CREATE TABLE person (
| id_person INTEGER NOT NULL,
| name VARCHAR(50) NOT NULL,
| id_dep_123456789_123456789 INTEGER NOT NULL,
| CONSTRAINT person_pk PRIMARY KEY (id_person)
| );
|
| qryDep - master
| qryPerson - detail
| Master Links:
| person.id_dep_123456789_123456789=dep.id_dep
|
| When I open qryPerson I get this error:
| FieldName: MLNK_ID_DEP_123456789_123456789_0 not found
|
| I think the problem lies in the way IBO names the parameter for the
| detail:
| MLNK_ID_DEP_123456789_123456789_0 = 33 chars
| If the detail has the link field named:
| id_dep_123456789_12345678 then it works.
| So if the link field from detail has the length <= 25 it's ok.
|
| Question: Can I tell IBO how to name the master detail parameter from
| the Master Links?
|
| Test case uploaded: Problem-MasterDetail.zip
|
|
| ps: I really have fields that are more than 25 in length.
|
|
|
|
|
___________________________________________________________________________
| IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
| without the need for BDE, ODBC or any other layer.
|
___________________________________________________________________________
| http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
| keyword-searchable FAQ, community code contributions and more !
| Yahoo! Groups Links
|
|
|
|
|