dbTalk Databases Forums  

QUESTION ON V/CORR DICTIONARY ITEM IN D3

comp.databases.pick comp.databases.pick


Discuss QUESTION ON V/CORR DICTIONARY ITEM IN D3 in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bishop
 
Posts: n/a

Default QUESTION ON V/CORR DICTIONARY ITEM IN D3 - 11-03-2008 , 11:47 PM






Good evening,

I was wondering if someone could tell me if this is even possible. I
used to do multiple translates using in-line EVAL statements for
JBase. Is something like this possible in an A or F type correlative?

EVAL
"OCONV(TRANS(PAYPLAN,TRANS(DEBTOR,@RECORD<5>,'48', 'X'),'11','X'),'D2-')"

I know I can translate from B to A below. Can a D3 dictionary item
translate from A to B even though the attribute I'm hoping to
translate to isn't the key of the table? File B has multiple instances
of the account number so I guess my next question is if I could only
translate to the first or first match.

FILE A
ACCOUNT # IS IN ATTRIBUTE 0 (UNIQUE KEY)

FILE B
ACCOUNT # IS IN ATTRIBUTE 4 (NON-UNIQUE)

F;4(TFILE A;X;;3)

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.