![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Guru |
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? THANKSThis message has been edited. Last edited by: Ricardo Augusto, WebFOCUS 8.1.05 / APP Studio | ||
|
Virtuoso |
SRSD11_PROD_PROGRAM_Cis 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 | |||
|
Guru |
Works like a charm. Thanks MartinY WebFOCUS 8.1.05 / APP Studio | |||
|
Expert |
I would suggest using -READFILE which handles the varchar. Waz...
| |||||||||||||||||||||||||||
|
Guru |
I will read about it tomorrow Waz. Thanks WebFOCUS 8.1.05 / APP Studio | |||
|
Guru |
I changed it to -READFILE. Thanks Waz. WebFOCUS 8.1.05 / APP Studio | |||
|
Expert |
Hi Richardo, Please edit your first post in this thread and add add [SOLVED] to the title Waz...
| |||||||||||||||||||||||||||
|
Guru |
Done. WebFOCUS 8.1.05 / APP Studio | |||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|