Subject | Possible Bug in MLNK_xxxx Fields ... |
---|---|
Author | dchri2000 <dchri@internet.gr> |
Post date | 2003-02-26T13:33:23Z |
Hi all,
i don 't know if this is a bug or the right behavior, i just post
this for your comments ...
I use polish notation so it's very possible to end up using
field's names like this :
"WareHouseTransSub_WHTrans_ID"
it has 28 chars so i thought it's ok ...
When i used that field on MasterLinks to do some Master/Detail
the IBO ( 4.2.Ib ) create a "MLNK_WareHouseTransSub_WHTrans_ID_0"
column adding 7 chars to the field name. This is wrong size for the
FireBird so the column name is truncated to 31 hars resulting the
name to be "MLNK_WareHouseTransSub_WHTrans_I".
But when i run the programm and the Query's become active the
Master/Detail cannot be established and i get an error that
the "MLNK_WareHouseTransSub_WHTrans_ID_0" Field cannot be found !!!
The IBO is using the "MLNK_WareHouseTransSub_WHTrans_I" as the
field name and not the "MLNK_WareHouseTransSub_WHTrans_ID_0". So i
think that must be done some checking before the creation of the
"MLNK_WareHouseTransSub_WHTrans_ID_0", and truncate the original
field name before the addition of the "MLNK_ _0" and not after ...
Dimitris
i don 't know if this is a bug or the right behavior, i just post
this for your comments ...
I use polish notation so it's very possible to end up using
field's names like this :
"WareHouseTransSub_WHTrans_ID"
it has 28 chars so i thought it's ok ...
When i used that field on MasterLinks to do some Master/Detail
the IBO ( 4.2.Ib ) create a "MLNK_WareHouseTransSub_WHTrans_ID_0"
column adding 7 chars to the field name. This is wrong size for the
FireBird so the column name is truncated to 31 hars resulting the
name to be "MLNK_WareHouseTransSub_WHTrans_I".
But when i run the programm and the Query's become active the
Master/Detail cannot be established and i get an error that
the "MLNK_WareHouseTransSub_WHTrans_ID_0" Field cannot be found !!!
The IBO is using the "MLNK_WareHouseTransSub_WHTrans_I" as the
field name and not the "MLNK_WareHouseTransSub_WHTrans_ID_0". So i
think that must be done some checking before the creation of the
"MLNK_WareHouseTransSub_WHTrans_ID_0", and truncate the original
field name before the addition of the "MLNK_ _0" and not after ...
Dimitris