XLATE with control=C" (AREV Specific)
At 17 SEP 2002 09:32:43AM Jenna Pederson wrote:
My ARev 2.1 book says that when using "C" as the control value in the XLATE function, the record key will be returned if the record does not exist.
My code looks like the this:
VIEWED.DATE=XLATE("IMPORT.TABLE",@ID,"VIEWED.DATE","C")
If the record exists, a date or "" should be returned (this part is working). But if the record does not exist, "" is returned. This appears (to me) to be the same functionality as when the "X" control is used. With "C" as the control, shouldn't @ID be returned?
Has anyone had any issues with this, or am I just not understanding how it works?
At 17 SEP 2002 11:23AM Gray Cunningham wrote:
Jenna,
My understanding is that it will return the key value. I don't have 2.1 anymore, but I just tried it in 3.1 and it did return the key. Are you sure that the contents of @ID is in fact the key to IMPORT.TABLE?
At 17 SEP 2002 11:35AM Jenna Pederson wrote:
Small details like that make a difference! Thanks.