HI FOLKS,

I AM TRYING TO USE -READ BUT I AM GETTING A WEIRD CONTENT ON IT.

CAN ANYONE HELP ME?


TABLE FILE MSRSD11_PARAMETER
BY TOP 1 SRSD11_PROD_PROGRAM_C
ON TABLE SAVE AS PROGRAM FORMAT ALPHA
END

-SET &PROGRAM= '';
-RUN

-READ PROGRAM &PROGRAM.A10.
-TYPE &PROGRAM

-EXIT

RESULTS:
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1
-READ FORD_PROGRAM &FORD_PROGRAM.A10.
-TYPE 000004P822
000004P822
-EXIT

THE CORRECT MUST BE ONLY P822. HOW DO I FIX THAT?

THANKS

This message has been edited. Last edited by: Ricardo Augusto,

SRSD11_PROD_PROGRAM_C

is probably defined as a varchar such as A10V redefine it as a fix length.

Sample:

DEFINE FILE MSRSD11_PARAMETER
NEWFIELD /A10 = SRSD11_PROD_PROGRAM_C;
END
TABLE FILE MSRSD11_PARAMETER
BY TOP 1 NEWFIELD
ON TABLE SAVE AS PROGRAM FORMAT ALPHA
END

Works like a charm.

Thanks MartinY

I would suggest using -READFILE which handles the varchar.

I will read about it tomorrow Waz. Thanks

I changed it to -READFILE.

Thanks Waz.

Hi Richardo,

Please edit your first post in this thread and add add [SOLVED] to the title

Done.