I-DESC

Hi,

What is I-DESC?
Whats it use?
What are the advantages and disadvantages of having this?

Your answers are more valuable?
_________________
King Arthur

it is a dictionary item.

allows you to use more than one data field to display what you would like.
for example - if you have field 3 with an amount and field 6 with an interest rate then you use an i-type to calculate and display to you the daily interest.
this is information not in the physical file. it can also be used to display information from another file in the database.
]
_________________
takoor

Hi takoor,

Can you give me an example for this?

Let us take the ACCOUNT file. In ACCOUNT we have WORKING.BALANCE and OPEN.ACTUAL.BAL. Let us try to create a virtual field TODAY.TRANS. = WORKING.BALANCE - OPEN.ACTUAL.BAL.

How to create?
How to query?

Sorry for asking too many Qs.
_________________
M A L A I

create a record in the dictionary of file of FBNK.ACCOUNT as follows


NEW *File DICT FBNK.ACCOUNT , Record 'TODAY.TRANS' Insert 10:10:21
Command-> FI
0001 I
0002 WORKING.BALANCE-OPEN.ACTUAL.BAL
0003
0004 Todays trans
0005 15L
0006 S

---

End Of Record

---

LIST FBNK.ACCOUNT WORKING.BALANCE OPEN.ACTUAL.BAL BY.DSND TODAY.TRANS

This will produce a report for you which looks as follows


@ID............. WORKING.BALANCE.... OPEN.ACTUAL.BAL.... Todays trans...

GBP148400066 0
GBP148400067 0
GBP148400100 0
GBP148400101 0
GBP148400102 0
GBP148400103 0
_________________
takoor