Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]-READ FROM HOLD
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]-READ FROM HOLD
 Login/Join
 
Guru
posted
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
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 2193 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
Works like a charm.

Thanks MartinY


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
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

 
Posts: 6124 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
I will read about it tomorrow Waz. Thanks


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
I changed it to -READFILE.

Thanks Waz.


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
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

 
Posts: 6124 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
Done.


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]-READ FROM HOLD

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.