Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by simaccs

  1. simaccs

    SQL syntax

    try to change your request such this. SQL SELECT field1, field2 FROM filename WHERE criteria; TABLE ON TABLE HOLD AS table FORMAT FOCUS INDEXfield END this will work fine.
  2. simaccs

    Field as Column Title

    It is possible to use heading as title. TABLE FILE CAR HEADING &quot;<COUNTRY<CAR&quot; PRINT MODEL AS ' ' SEATS AS ' ' ON TABLE SET STYLE * TYPE=HEADING,HEADALIGN=BODY,$ ENDSTYLE END this works fine in my report.
  3. simaccs

    join versus match

    Hi Try this way. SET ALL=PASS JOIN fieldname1 IN file1 TO fieldname2 IN file2 and in following table request WHERE file2.fieldname2 EQ ' ' OR MISSING this can work same as 'OLD-NOT-NEW'
  4. simaccs

    Wildcard with Parameter

    Hi, Try this. WHERE LAST_NAME EQ '&LNAME.EVAL$*' or WHERE EDIT(LAST_NAME,'9') EQ '&LNAME' Can these work in your enviroment? sim
  5. simaccs

    Default values

    Hi try this value. '1 OR (1 EQ 1)' this can work in your program?
  6. simaccs

    RADIO BUTTON

    Hi do you want to execute a focexec in stylesheet? you must use javascript. cannot use 'FOCEXEC='. it is so hard. DEFINE FILE CAR RADIO1/A49='<input type=radio name=ARG1 value=0 checked>TEXT1'; RADIO2/A41='<input type=radio name=ARG1 value=1>TEXT2'; SCR/A200='<script>' |...
  7. simaccs

    RADIO BUTTON

    Hi DEFINE FILE CAR RADIO1/A49='<input type=radio name=ARG1 value=0 checked>TEXT1'; RADIO2/A41='<input type=radio name=ARG1 value=0>TEXT2'; END TABLE FILE CAR HEADING &quot;<RADIO1 <RADIO2&quot; PRINT CAR MODEL SEATS BY COUNTRY END Do you need this?
  8. simaccs

    AYMD problem

    Hi jimster Any change can not get '20031231'. so we changed program. -SET &NDATE = AYMD(&TYYMD,&ADATE,'I8'); -SET &NDATE = IF &NDATE EQ 0 THEN '20031231' ELSE &NDATE; thanx all.
  9. simaccs

    AYMD problem

    Hi thank you jimster but -* start -RUN -SET &TYYMD = '20030803'; -RUN -SET &NDATE = AYMD(&TYYMD,150,'I8'); -SET &NDATE2= AYMD(&TYYMD,149,'I8'); -SET &NDATE3= AYMD(&TYYMD,151,'I8'); -TYPE NDATE='&NDATE' -TYPE NDATE2='&NDATE2' -TYPE NDATE3='&NDATE3' -* end result---------------- NDATE='0'...
  10. simaccs

    AYMD problem

    Hi -* start -SET &TYYMD = '20030803'; -SET &NDATE = AYMD(&TYYMD,150,'I8'); -SET &NDATE2= AYMD(&TYYMD,149,'I8'); -SET &NDATE3= AYMD(&TYYMD,151,'I8'); -TYPE NDATE='&NDATE' -TYPE NDATE2='&NDATE2' -TYPE NDATE3='&NDATE3' -* end I can got without only '20031231'. NDATE='0' NDATE2='20031230'...
  11. simaccs

    AYMD problem

    Hello! Anyone know why this return 0? -* start -SET &TYYMD = '20030803'; -SET &NDATE = AYMD(&TYYMD,150,'I8'); -TYPE '&NDATE' -* end in WEBFOCUS 4.3.5 thanx via
See more

Part and Inventory Search

Back
Top