Hi,
I am trying to read a value from CAR file in Infoassist.Code in OTHER section is as :

  
-DEFAULT &TEMP = '';
TABLE FILE CAR
PRINT SEATS
BY COUNTRY NOPRINT
WHERE COUNTRY EQ 'ENGLAND'
WHERE RECORDLIMIT EQ 1
ON TABLE SAVE AS HLD
END
-RUN
-READ HLD &TEMP.I2.
-TYPE &TEMP

I want to use the &TEMP value to Compute new field in my reporting object master file. But I am getting below error :

 
Code: 1067 Type: xPropertyValueQuery
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: CAR
BYPASSING TO END OF COMMAND
0 ERROR AT OR NEAR LINE     15  IN PROCEDURE abs_by_country_ctd
(FOC339) DIALOGUE MANAGER -READ FAILED: CHECK FILEDEF OR ALLOCATION FOR: -READ
HLD &TEMP.I2.

When I remove -READ line this code works. Can anyopne please suggest where I am going wrong. Please help.

Thanks in advance.

This message has been edited. Last edited by: Kerry,

With the code supplied, my guess is that CAR master file is not in the path.

Also the value stored will be an alpha field, use &TEMP.A2.

Not sure if this was in by 7.6.11, but try this -

APP PREPENDPATH IBISAMP
TABLE FILE CAR
PRINT SEATS AS TEMP
BY COUNTRY NOPRINT
WHERE COUNTRY EQ 'ENGLAND'
WHERE RECORDLIMIT EQ 1
ON TABLE HOLD AS HLD
ON TABLE SET ASNAMES ON
END
-RUN
-READFILE HLD
-? &TEMP

T

Bonjour,
Please, dear Focus users, don't use a semi-column with -DEFAULTS. -SET and -DEFAULTS are not to be melt in your bains.
-SET needs a semi-column in the end and just sets the value of a single DM variables.
-Defaults provides a value to a DM Variable, if nor previously setted. You may -Defaults more than one DM Variable on a single line, Comma will separate the different affectations by Default :

-DEFAULTS &QUAL1 = 'OLD', &QUAL2 = 'BORING'  

One may be imprecise when playing with Focus, but, sometimes, one may pay the price for it. At least, it's my point of view
Cordially and Focusely