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 Mike Lewis 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: *

  1. NollaunoUK

    Rounding in webfocus

    Have not used FOCUS for a long time but try the following instead. TOT_DATA_VOL1 /D13.4 = ROUND( (TOT_DATA_VOL / 1024), 4, TOT_DATA_VOL1); Regards
  2. NollaunoUK

    FOCUS Users Locations?

    Where are most of you programmers and users of Focus bases. I have programmed in Focus for eight years and love the language, SQL is so clumsy by comparison. I am based in the UK. Where are you lot from?
  3. NollaunoUK

    Variable Filtering Not Working

    jcollier3, Also DISABLED might be a reserved word (need to check this). DEFINE FILE <FILENAME> CLEAR DIS_FLAG /I1 = IF ((UPCASE(NSACCOUNTLOCK) EQ 'TRUE') THEN 1 ELSE IF ((UPCASE(NSACCOUNTLOCK) EQ 'FALSE') THEN 0 ELSE 2; END TABLE FILE <FILENAME> WHERE (DIS_FLAG EQ '&DIS_FLAG') END...
  4. NollaunoUK

    Multiple Reports in one Spreadsheet

    We used to extract data from the databases and store the output in csv file. e.g. Year, Month, Day, YTD_Target, Actual_Amount, Branch 2010,10,05,5000,4500,124567 2010,05,05,4000,10,123456 Then you import the data into a spreadsheet such as excel and store each column as a separate column. Then...
  5. NollaunoUK

    Multiple Reports in one Spreadsheet

    Output the reports as csv files and write an import macro into a master spreadsheet, this way you can format the output of the report as you wish.
  6. NollaunoUK

    Who is running the report - USERNAME

    You should be able to extract the information from the OS and session that your running. Put the resulting query into && variables, then you will be able to manipulate the resulting output. Regards Andrew
  7. NollaunoUK

    Help with a master file please

    Why don't you hold the file as like the following . ... ON TABLE HOLD AS MY_FILE FORMAT FOCUS INDEX ID_ONE ID_TWO END You would have to look up the syntax as I'm rusty on FOCUS (10+ years) Regards Andrew
  8. NollaunoUK

    PC Focus v 6

    Does anyone know if IBI would still supply this? As I used to program in this for about 8 years and now work for a school and would like to supply them with a suite of programs to help streamline there functions. As schools have a tight budget I just wanted to know if there were still copies...

Part and Inventory Search

Back
Top