View previous topic :: View next topic
|
Author |
Message |
Paresh0459
New User
Joined: 22 May 2007 Posts: 8 Location: Mumbai
|
|
|
|
Hi,
I have a secondary index defined for database. the secondary index has two fields Record number and date. Record number is also part of primary index.
The date is not always present in input so I need to get records that match record number. A search with Record number alone can get multiple records and same might happen when both record number and date are given. This is possible because record number has suffix which varies for multiple entries for a particular date.
I want to know how can i access database through secondary index/key when i only have record number. What do I need to specify for date so that I get all the record numbers?
Thanks in advance.
Paresh |
|
Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
So, record number comes before date? |
|
Back to top |
|
|
Paresh0459
New User
Joined: 22 May 2007 Posts: 8 Location: Mumbai
|
|
|
|
Yes..record number is first entry. |
|
Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
Can you post your SSA and your key fields? Where are you getting your record number? |
|
Back to top |
|
|
Paresh0459
New User
Joined: 22 May 2007 Posts: 8 Location: Mumbai
|
|
|
|
Thats what my questions is about.
I'm not sure how can I can access database using secondary key, so wanted to know how should i build up my SSA.
Thanks. |
|
Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
Yes - you can. You need to show us what your key fields look like.
A few years ago I built a system with 5 secondary indices. I built many online functions around those keys. |
|
Back to top |
|
|
|