Focal Point
[SOLVED]-READ FROM HOLD

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4537058876

October 14, 2015, 03:08 PM
Ricardo Augusto
[SOLVED]-READ FROM HOLD
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,


WebFOCUS 8.1.05 / APP Studio
October 14, 2015, 03:13 PM
MartinY
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



WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
October 14, 2015, 03:25 PM
Ricardo Augusto
Works like a charm.

Thanks MartinY


WebFOCUS 8.1.05 / APP Studio
October 14, 2015, 05:55 PM
Waz
I would suggest using -READFILE which handles the varchar.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

October 14, 2015, 07:44 PM
Ricardo Augusto
I will read about it tomorrow Waz. Thanks


WebFOCUS 8.1.05 / APP Studio
October 15, 2015, 06:51 AM
Ricardo Augusto
I changed it to -READFILE.

Thanks Waz.


WebFOCUS 8.1.05 / APP Studio
October 15, 2015, 06:27 PM
Waz
Hi Richardo,

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


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

October 15, 2015, 08:34 PM
Ricardo Augusto
Done.


WebFOCUS 8.1.05 / APP Studio