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!

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

Search results for query: *

  • Users: JoaoPinto
  • Content: Threads
  • Order by date
  1. JoaoPinto

    File Input type setting initial value

    Hi, I have a question about using the file input object. Is there any way of setting the initial value of the text box associated with the browse button to something? i.e if you have a form with user info including a file associated with that user, I want to allow him to edit the file path...
  2. JoaoPinto

    Extracting from a HYYMDS field

    I'm trying to extract the day, month and year from a HYYMDS field (from Oracle). But the normal Date functions don't see to work. Is there a different way to handle this type?
  3. JoaoPinto

    Printing TX50 fields

    Does anyone know if there are any known issues when doing this in webfocus 5.2? No matter what way I print, I only ever get the first instance of a TX50? All other instances are blank. Here is the code TABLE FILE ISSUINFO HEADING CENTER "PSDB Reporting" PRINT UPDATEDETAILS ** Text file one BY...
  4. JoaoPinto

    Using Recap

    Is it possible to use recap or compute on a subfoot at bottom of a table? I am writing a report that uses recap/subfoot on a sort field (works ok) but then I want to use it on a subfoot for the overall table. Is this possible? TABLE FILE SQLHOLD PRINT COMPUTE COUNTER/I5=1; NOPRINT...
  5. JoaoPinto

    Border around Image Links

    Does anyone know how to take the border of a link when that link is an image within a focus stylesheet? i.e what you'd use ALINK, VLINK etc.. for in HTML? Thanks,
  6. JoaoPinto

    SQL with fields that have spaces in the title

    Hi Can anyone help. I have a database table with fields like this RouterCallKey, DateTime, Time in Q, TalkTime, After Call Work How do I refer to 'Time in Q' and 'After Call Work' within WebFOCUS SQL? In SQL Server I would use [Time in Q] and [After Call Work] this way does not work in...
  7. JoaoPinto

    Collapsing a File

    Hi, Currently I have a report that looks like this Reg Terr Mar Agent Name Days 002 2 04 DAN FINN MONDAY TUESDAY WEDNESDAY THURSDAY...
  8. JoaoPinto

    Count instances of a BY

    Hi, I have the following output Region State Location Number of Calls 002 IL 00201E 1 00203A 1 002064 2 002078 4 00207F 1 00209A 2 MN 00210B 1 00214C 2...
  9. JoaoPinto

    No Page Break

    Is there anyway to stop HTML output splitting and putting in the headings etc.. on every page?
  10. JoaoPinto

    Averages

    Is there a way to display averages when using SUMMARIZE? I currently have this output Report from 02/01/03 to 02/10/03 REGION #loc #oflonotfor %notforw 002 616 43 6.98 003 711 17 2.39 006 781 94 12.04 007 498 19 3.82 008...
  11. JoaoPinto

    Unique Count

    Is there anyway to count unique instances? Other than doing DEFINE FILE WEEK1 COUNTNUM/I9 = IF LAST ROLOC NE ROLOC THEN 1 ELSE 0; END And summing COUNTNUM?
  12. JoaoPinto

    Remote Stored Procedures from SQL pass through

    Hi, I am trying to call a stored procedure from SQL in webfocus. My code is as follows ************************************************************ REMOTE DEST=******** -MRNOEDIT BEGIN -REMOTE BEGIN SET SQLENGINE=SQLMSS SQL SQLMSS USE PEDAHR EXEC getWeek; TABLE FILE SQLOUT PRINT * ON...
  13. JoaoPinto

    Remote & Non Remote join

    Hi, I was wondering if anyone could help me out with the following. I am trying to retrieve data from a remote SQL server database and a non remote Oracle database, then combine the results. So far I've done it like so ****************************************************** REMOTE...

Part and Inventory Search

Back
Top