You right, there is a table named LMM.CATEGORY, but in our system, this table is empty, I dont know why. Are you sure Concat table is not like a view in other DBMS ???
You said Concat table not like View in other DBMS, but someone in above said: "T24 will automaticallly store the LD Contracts against Categories" if I can create a concat . Does he right? I know LD is system table, very important, it should not be changed by any reason, I dont want to change FIELD.DEFINITION this table. No my question only is: IF I CREATE A CONCAT TABLE WITH @ID IS CATEGORY.IDAND CONTENT IS LIST OF THIS CaTEGORY.ID'S LD.ID. DOES T24 AUTOMATICALLY INSERT DATA TO THIS TABLE (like a View in SQL)? If everybody said no, I must write a Routine to insert data, or use EB.ALTERNATE.KEY. Many thanks 2009/9/22 Rashid K.P <[email protected]> > Concat table is not like a view in other DBMS . It is a separate table in > itself and data needs to be inserted into it. In this case when an LD > is created in T24 , core system itself will insert values into this table > (If I'am not wrong the Table name is LMM.CATEGORY im not sure !!). > > > On Tue, Sep 22, 2009 at 6:15 AM, Phuong Do Duc <[email protected]> wrote: > >> >> >> Hi all, thank you for reply me. The reason for my question are: >> >> 1) I want to know: How many LD contract are created with CATEGORY number1, >> number2, ... >> 2) I want to know how to create concat table and how to store data to. >> >> I have Template "T" file, but I dont know how to attach to >> FIELD.DEFINITION of table LD.LOANS.AND.DEPOSITS. Please show me details. >> >> "T24 will automaticallly store the LD Contracts against Categories": >> THAT'S ALL I NEED. I can coding to insert data to any table but with concat >> table, I dont want to coding anything, I think concat table same with VIEW >> in SQL2000, Oracle,... or some others DBMS... Am I right? >> >> Thank you very much. >> >> >> >>> >EB.ALTERNATE application can do for you. >>> >Create a alternate key based on CATEGORY field. >>> >>> > You only need to create a new template with Type 'T' and attache in >>> > FIELD.DEFINITIONS file of LD.LOANS.AND.DEPOSITS. T24 will >>> > automaticallly store the LD Contracts against Categories. If you dont >>> > have the LD's FIELD.DEFINITIONS file then you will have to do this by >>> > a routine. >>> > >>> > Regards, >>> > >>> > Faisal >>> >> >> >> >> > > > > -- Đỗ Đức Phương Mobile: 84 904 302 898 Home phone: 84 4 5543349 --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
