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!

Recent content by tedbain

  1. tedbain

    syntax error in SELECT

    the first two snippets from command window do not work (giving 'syntax error') but the third and fourth do... sele desc from plans sele desc,km1 from plans sele km1 from plans sele km1,desc from plans On a similar vein, some years ago, amongst other items, I had a query that failed to...
  2. tedbain

    Foxdoc... any updates?

    New year's greetings from Australia !! Have been using FPW2.6 since it was new and have added a couple of patches but to the best of my knowledge FoxDoc has not been patched or updated. There a few undesireable quirks in FoxDoc, the worst (for me) being the reporting of spurious...
  3. tedbain

    hide/show window

    some funny things can happen with modal screens when trying to hide something. I solved my problems by moving screen to some out-of-sight address (eg to 0,-500). Ted
  4. tedbain

    screen size in foxpro 2.6 for windows

    Steve we're both partly wrong. Multiply font size but not field/box size because latter depends on font size. Box size actually depends on Fontmetric so solution not always exact. Also your approach needs modification if it has to deal with a range of font types, styles and sizes Ted PS think...
  5. tedbain

    display problems using fpw2.6 with Matrox G450 dual display video card

    these cards are beaut... you can have so much open and see it all without juggling screens but there are some silly things... 1. In preview of reports (both full page and zoomed in) there is a horizontal compression of at least 70% (very hard to read, if you can even do that) 2. working in...
  6. tedbain

    output from select, display structure under windows 2000 professional

    Rick.. all was not well with the printer until I figured that it didn't recognise 'courier' but it did recognise 'new courier'. the things nobody tells you !!!! Ted
  7. tedbain

    reordering tables

    Scott .. thanks for your effort but that was where I started from and it gets very laborious with 100 cols. Tesar .. tried what you said. Just what I wanted except I think you dropped a line. I found that the recreation ignored indexing but having been given the right pointers by you, I used...
  8. tedbain

    output from select, display structure under windows 2000 professional

    thanks Rick... just changed PrtFontName to 'courier' and all's well. It's weird that use of a non-proportional font should cause the insertion of numerous extra spaces but that's Microsoft for you. Ted
  9. tedbain

    Moving databases between FPW2.6 and excel

    First a warning... when moving from excel to fpw, column widths are chopped back if they are partly obscured. Haven't checked to see what happens if they are hidden. Question is: Does anybody have some tricks for maintaining column widths when one goes from FPW to excel and back to FPW ? any...
  10. tedbain

    output from select, display structure under windows 2000 professional

    forgot to say I'm using 2.6FPW Ted
  11. tedbain

    reordering tables

    forgot to say I'm using 2.6FPW Ted
  12. tedbain

    reordering tables

    I have some tables with around 100 fields and am thinking of reordering the columns. Does anybody have any tricks for doing this?? again any help appreciated Ted
  13. tedbain

    output from select, display structure under windows 2000 professional

    when running under windows 98 the output (to printer or file) from SELECT (columns from table) or DISPLAY STRUCTURE only had a couple of spaces between each column of output but under 2000 lots of spaces are inserted (not tabs). eg with display structure there are about 20 spaces before the...
  14. tedbain

    screen size in foxpro 2.6 for windows

    Kimsue further to mine (prev message)the resize equation should be RESIZE=iif(sysmetric(1)=640,1,1.25) also you will need to add the "*RESIZE" to the locations ie above should have @ 3.769*RESIZE,0.400*RESIZE GET xxx if you are using non-scalable font (such as MS sans serif)...
  15. tedbain

    screen size in foxpro 2.6 for windows

    kimsue centering the screen usually makes things look better but a more sophisticated solution is to redefine or resize window in the setup code either (can use variables, expressions and can make use of functions such as Scols() )to make whatever size window you want. You will need to make sure...

Part and Inventory Search

Back
Top