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

    Help with a master file please

    Let's say I have two sets of data relating to the same population of individuals. DATASET1 has a 6 character ID as the identifier, DATASET2 has a 12 character ID as the identifier. The data files do not contain demographic info. So lets say we have someone called SMITH,JOHN and his ID in...
  2. sagobogger

    Help with a master file please

    I need a simple (I think) master file but I'm just stuck :( I have three fields: ID_ONE/A6 ID_TWO/A12 NAME/A40 I need to be able to join to either ID_ONE or ID_TWO and get the NAME, so ID_ONE and ID_TWO both need to be indexed. (ID_ONE is in legacy data, ID_TWO is in current data.) I'll...
  3. sagobogger

    Mixed Case Data - Help

    Hmmm, seems we discovered something that works differently in a saved .fex and entered directly at the >>
  4. sagobogger

    Mixed Case Data - Help

    I'm sure I'm missing something obvious but I need to buy a clue. Someone decided it would be nicer to have some data feeds in mixed case instead of upper case, so before we got e.g. SMITH,JOHN and now we are suddenly getting Smith,John Previously WHERE NAME LIKE 'SMITH%' or WHERE NAME EQ...
  5. sagobogger

    Can't update a key field with a MODIFY

    The answer appears to be by using SCAN.
  6. sagobogger

    Can't update a key field with a MODIFY

    I need to change one field in a few records in a large .FOC table. Normally I would do that by creating a hold file with the corrected data, and then use a MODIFY to UPDATE the field in the .FOC. But this time it is an indexed field and I have run into the "A key field cannot be updated using a...
  7. sagobogger

    EXL2K saves as .XLS but format is really webpage/.mht

    Unless I'm missing something I don't think FORMAT EXCEL will produce a compound/multitab report. (I didn't mention it above but it also has formulas.)
  8. sagobogger

    EXL2K saves as .XLS but format is really webpage/.mht

    I'm having a problem with a Managed Reporting (web client) compound EXL2K format report that saves as a .XLS suffix file, but is really a "single file webpage" format file. This is transparent to later versions of Excel on the PC but causes problems on mac. I can fix it by opening it in Excel...
  9. sagobogger

    Graphing beyond Excel ?

    Thank you lionelhill, I'll look at sigmaplot, I'm not familiar with that one. "if you want a graph exactly 100 by 70mm, you just have to type in 100 and 70. This sort of thing ought to go without saying, but making a publication-quality figure with Excel is a nightmare." Yup, my thoughts exactly.
  10. sagobogger

    Graphing beyond Excel ?

    I'm interested to learn what programs folks are using when they need more sophisticated/flexible graphing than Excel can provide.
  11. sagobogger

    .htaccess redirect for a single file

    RewriteRule will also work. The difference is that a Redirect will cause the browser to display the target URL in the address box, but with a RewriteRule the displayed URL is the original one.
  12. sagobogger

    .htaccess redirect for a single file

    The big dog has the answer, it needs a full URL as the target. Thanks!
  13. sagobogger

    .htaccess redirect for a single file

    I added that redirect line to my .htaccess and the whole site became unreachable with a 500 error.
  14. sagobogger

    .htaccess redirect for a single file

    I need to redirect the url for one file e.g. http://www.mydomain.net/dir/thatfile.gif to a different file http://www.mydomain.net/dir/thisfile.php No wildcards/regex, just one defined URL to another defined URL. Could someone please show me the RewriteRule for that? Thanks!
  15. sagobogger

    Dead Hard Drive

    Does anyone still use SpinRite? It was great back in the days of small disks, but the last time I tried it for a dodgy 20 gig one it was going to take about 200 hours to process. I guess if you have critical data and no backup that would be worth a try.
  16. sagobogger

    Any HP E-PC C10 Experts? Re: Keyboardless Boot

    Why? Usual reason for wanting a headless box, it's going to live in a remote location with very little space and just a network connection. It's managed via VNC. I couldn't find a BIOS option that worked, so in the end I made a keyboard stuffer by taking the encoder chip/board out of an old one...
  17. sagobogger

    Any HP E-PC C10 Experts? Re: Keyboardless Boot

    Sorry for a 20th century PC question, but does anyone know how to set an HP E-PC C10 to boot without a keyboard? I find old reviews and specs for this machine showing this as a feature but can't figure out how to do it. This is a very tightly locked down little box with very few BIOS options.
  18. sagobogger

    USE with indexed .FOC files

    I'm wondering if anyone is else having trouble with USE concatenated, indexed, .FOC files under Focus 7.6? We recently updated from 4.3.x to 7.6.x and our reporting is in now big trouble because we use USE to concatenate multiple .FOC files for different years to allow multi year reporting...
  19. sagobogger

    File Search Question

    It's a difference between 2000 and 2003 with a fix http://support.microsoft.com/kb/309173/en-us
  20. sagobogger

    File Search Question

    Is there a setting somewhere that determines what types of files the file search function will search for text? I'm suffering with an application that was moved from Server 2000 to a new Server 2003 machine. We have program routines in plain text files, but with a .fex suffix. On the old box I...

Part and Inventory Search

Back
Top