Recent content by JoaoPinto

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...

Hi Big foot could you send your project to me as well? stephenhughes@hotmail.co.uk PankajBanga when I use that Method my form collaspes with 'No Symbols Displayed errors'

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?

The master file below FILE=ISSUEUPDATES, SUFFIX=SQLMSS ,$ SEGNAME=ISSUEUPDATES, SEGTYPE=S0 ,$ FIELD=UPDATENUMBER ,UpdateNumber, I11 ,I4 ,MISSING=OFF, FIELDTYPE=R,$ FIELD=ISSUENUMBER ,IssueNumber, I11 ,I4...

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...

Thanks that has solved the issue. Is there a limit to the amount of RECAP statements you can have in a focexec file? I get a error "number of RECAP statements has exceeded 7" if i have more than that number.

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...

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,

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...

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...

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...

Perfect, thanks.

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

I've managed to get it working DEFINE FILE TFINAL THISCNT/I9 = 1; END TABLE FILE TFINAL PRINT MYDATE AS 'Weekly Totals' LOA_ROLOC AS 'Total Sites' NOTFOR AS 'Total Not Forwarding' COMPUTE AVEAPY/I9 = TOT.NOTFOR/TOT.THISCNT; NOPRINT COMPUTE AVELOA/I9 = TOT.LOA_ROLOC/TOT.THISCNT; NOPRINT ON...

Well I can get Totals written out in the SUBFOOT section and I'm using a round about way to count the number of records: DEFINE FILE TFINAL THISCNT/I9 = 1; END TABLE FILE TFINAL PRINT MYDATE APY_ROLOC LOA_ROLOC ON TABLE SUBFOOT &quot;Average: <TOT.APY_ROLOC <TOT.LOA_ROLOC <TOT.THISCNT&quot...