×
Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...
Duplicate data check
- ROBIUL73
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 21
- Thank you received: 1
6 years 7 months ago - 6 years 7 months ago #21321
by ROBIUL73
Duplicate data check was created by ROBIUL73
I develop a local application version R09 by using EB TABLE DEFINITION .The two filed account number and card type make unique data(this is not @ID, other field ).
My problem :To find duplicate data use here select command .that need more time .
have any method like EB.ALTERNATE.ID etc
My problem :To find duplicate data use here select command .that need more time .
have any method like EB.ALTERNATE.ID etc
Last edit: 6 years 7 months ago by ROBIUL73.
Please Log in or Create an account to join the conversation.
- silvergem
- Offline
- Elite Member
- TAFC|R12/R13, TAFJ|R20
Less
More
- Posts: 247
- Thank you received: 20
6 years 7 months ago #21326
by silvergem
Replied by silvergem on topic Duplicate data check
You may use EB.ALTERNATE.KEY table
This application is used to define an alternate key for an application (e.g. CUSTOMER, ACCOUNT etc.). Using this utility any field in an application (both system fields and local ref fields) can be set as an alternate key.
The alternate key can be used for field inputs as well as id inputs.
For example,
If a local ref field say, CUST.ALT.INDEX in CUSTOMER is defined as an alternate key field.
Id input:
In CUSTOMER application if the value in CUST.ALT.INDEX is used as id input, the corresponding customer record is displayed.
Field input:
CUSTOMER fields in applications like MM, FX (e.g. field CUSTOMER.ID in MM) will accept alternate keys.
This application is used to define an alternate key for an application (e.g. CUSTOMER, ACCOUNT etc.). Using this utility any field in an application (both system fields and local ref fields) can be set as an alternate key.
The alternate key can be used for field inputs as well as id inputs.
For example,
If a local ref field say, CUST.ALT.INDEX in CUSTOMER is defined as an alternate key field.
Id input:
In CUSTOMER application if the value in CUST.ALT.INDEX is used as id input, the corresponding customer record is displayed.
Field input:
CUSTOMER fields in applications like MM, FX (e.g. field CUSTOMER.ID in MM) will accept alternate keys.
Please Log in or Create an account to join the conversation.
- ROBIUL73
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 21
- Thank you received: 1
6 years 7 months ago #21328
by ROBIUL73
Replied by ROBIUL73 on topic Duplicate data check
I use here EB table Definition.It is not support EB.ALTERNATE.KEY.
Please Log in or Create an account to join the conversation.
- VK
- Offline
- Platinum Member
- Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
Less
More
- Posts: 1116
- Thank you received: 150
6 years 7 months ago #21331
by VK
Cheers
VK
Replied by VK on topic Duplicate data check
Hi
Then why use it at all? If you know the data structure, it takes no more than 15 minutes to create an application from template...
EB table Definition.It is not support EB.ALTERNATE.KEY
Then why use it at all? If you know the data structure, it takes no more than 15 minutes to create an application from template...
Cheers
VK
Please Log in or Create an account to join the conversation.
Time to create page: 0.104 seconds