| View previous topic :: View next topic |
| Author |
Message |
P.S.Bell
Guest
|
 Posted: Tue May 04, 2004 8:00 am Post subject: String+Integer compound index not supported for master-detai |
 |
|
Ihave a compound primary index (licNo (3 char)+jobNo and InvNo
(integers)). On master and the same plus LineNo (integer) on the
detail table.
But the detail refuses to show anything at all even though when
unlinked I can see matching records. The fields are identically
defined, both case sensitive and the fields comprising both
indices are in the same order.
If I remove the first string value from the index detail records
are shown, including the ones with the correct LicNo value
Is there something about mixed type compound indices that I
should know about?
What can be preventing the detail records from showing?
Pat Bell
|
|
| Back to top |
|
 |
Bill Todd (TeamB)
Guest
|
| Posted: Tue May 04, 2004 1:24 pm Post subject: Re: String+Integer compound index not supported for master-d |
|
|
It is very difficult to answer database questions when you do not tell
us what database and version you are using.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
|
P.S.Bell
Guest
|
| Posted: Thu May 06, 2004 8:00 am Post subject: Re: String+Integer compound index not supported for master-d |
|
|
In article <VA.00000492.00173872 (AT) patbell (DOT) co.uk>, P.S.Bell wrote:
| Quote: | Ihave a compound primary index (licNo (3 char)+jobNo and InvNo
(integers)). On master and the same plus LineNo (integer) on the
detail table.
But the detail refuses to show anything at all even though when
unlinked I can see matching records. The fields are identically
defined, both case sensitive and the fields comprising both
indices are in the same order.
If I remove the first string value from the index detail records
are shown, including the ones with the correct LicNo value
Is there something about mixed type compound indices that I
should know about?
What can be preventing the detail records from showing?
Pat Bell
|
Sorry,
Using DBISAM 4.24 with Delphi 6
Pat Bell
|
|
| Back to top |
|
|
Jan Ferguson
Guest
|
| Posted: Thu May 06, 2004 9:53 am Post subject: Re: String+Integer compound index not supported for master-d |
|
|
P.S.Bell wrote:
| Quote: | In article <VA.00000492.00173872 (AT) patbell (DOT) co.uk>, P.S.Bell wrote:
Ihave a compound primary index (licNo (3 char)+jobNo and InvNo
(integers)). On master and the same plus LineNo (integer) on the
detail table.
But the detail refuses to show anything at all even though when
unlinked I can see matching records. The fields are identically
defined, both case sensitive and the fields comprising both
indices are in the same order.
If I remove the first string value from the index detail records
are shown, including the ones with the correct LicNo value
Is there something about mixed type compound indices that I
should know about?
What can be preventing the detail records from showing?
Pat Bell
Sorry,
Using DBISAM 4.24 with Delphi 6
Pat Bell
|
Possibly DBIsam v3.24? They are currently only up to version 4.05.
--
Regards,
Jan Ferguson
|
|
| Back to top |
|
|
P.S.Bell
Guest
|
| Posted: Fri May 14, 2004 8:00 am Post subject: Re: String+Integer compound index not supported for master-d |
|
|
Yes, 3.24 d'oh
Pat Bell
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
