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

    Why forum posts are sometimes deleted

    Wait Mike, slow down. I meant no criticism to anyone. I have absolutely no knowledge of what happened, either regarding you or anyone else. However, I can see you have hurt feelings. Rest assured I don't blame you for anything nor have attributed any negativity to anyone. Believe me, you...
  2. dbMark

    Down memory lane... was it that important?

    I worked for a Fortune 200 company for some 15 years. (Not initially, but they did buy the company I worked for.) Little did I know that they had 3 divisions all with separate retirement account systems. Ours was not the latest & greatest (VFP versus Java) but it was the one home staff said...
  3. dbMark

    Why forum posts are sometimes deleted

    As someone who was once married to an acting-out personality disordered spouse, and my life forever impacted, I realize that peace-making efforts often fail. That's so sad. All I can do is let the other curse, rant and rant and I get on with my life... or not get on so much with my life. I...
  4. dbMark

    VFP temp tables not closed when EXE run as COM service on servers

    Thanks for the insight. I do recall this was the server's Temp folder where I went to clear out the old files. I had just been mystified why only certain of the report app's temp DBF/CDX remained there. Maybe I can let it go, it's all in the past now, shortly before I was let go, my employer...
  5. dbMark

    VFP temp tables not closed when EXE run as COM service on servers

    I've been away so long I don't recall if I asked this before... I was on a team with about a dozen or so VFP apps compiled and uploaded to Microsoft servers back about 2015 with WSDL for COM access. Every few days our servers would crash or hang and when we logged in we found there was no...
  6. dbMark

    Using seeking in a table with 2 items/records at the same time.

    Just a side note here... In the quote above, you specified transforming a number to character for up to 7 digits. Years from now a problem could arise where the number could grow to more than 7 digits, such as going from 9,999,999 (7 digits) to 10,000,000 (8 digits). Then your code would...
  7. dbMark

    BROWSE ... NOFOLLOW

    It' been a long time for me no visit (Get it? NOFOLLOW... NOVISIT ?) NOFOLLOW was used in BROWSE (perhaps in EDIT too?) so that you would not lose your place in the current or displayed view order and the changed field that was indexed would move it away to it's new index position. If not...
  8. dbMark

    Pls, help me with this problem... (original posted in dBase section)

    Without a sample of your code's structure in those areas, my guess is that your temp variable is declared in a subroutine, then when it returns to a higher level the variable is discarded (as out of scope) and when you go back into that subroutine it's gone. Can you declare the variable at a...
  9. dbMark

    Windows Media Player problem with Windows 10 Ver 1803

    WMP is working normal again, the album and tracks display as they did in the past. Selecting "Update album info" now works (or at least does not generate an error message) but not "Find album info" which still fails with musicmatch-ssl.xboxlive.com message "The webpage cannot be found". I'm...
  10. dbMark

    Windows Media Player problem with Windows 10 Ver 1803

    I had also posted to this MS thread and the consensus is that something in the Windows 10 Version 1803 broke the WMP Find/Update album info functionality. It appears MS changed the link/destination but never activated it. MS has been silent so far. I have a borrowed laptop that hasn't been...
  11. dbMark

    i have a table that has the wrong year in a date field

    It appears these dates were entered or added in shortened form such as "18" rather than 2018. The SET CENTURY setting should avoid defaults to 19XX that would be outside the usual range. However, don't force every 2 digit year to 20XX, there may be times you want to enter an age or event and...
  12. dbMark

    I couldn't write a code to find repeated cods.

    This is Visual FoxPro implementation, should be substantially similar to Dbase. The == operator (or = operator when SET EXACT ON) can be used when an exact comparison of character strings is needed. If two character expressions are compared with the == operator, the expressions on both sides of...
  13. dbMark

    I couldn't write a code to find repeated cods.

    USE myTable INDEX ON cod TO mySearch GO TOP tmpCodWas = cod tmpRecWas = RECNO() DO WHILE .NOT. EOF() SKIP IF tmpCodWas = cod ? cod + " duplicated in records " + LTRIM(STR(tmpRecWas,10)) + " & " + LTRIM(STR(RECNO())) ENDIF tmpCodWas = cod tmpRecWas = RECNO() ENDDO DELETE...
  14. dbMark

    OPEN DATABASE asks "Index does not match the table. Delete index file and recreate the index&qu

    >Interesting that INDEX ON reindexes I had a co-worker (who in time had become my manager) use INDEX ON daily on large files. One day I happened to notice that the index files were far larger than the tables, and growing by the day. I did some testing and confirmed that INDEX ON concatenated...
  15. dbMark

    Windows Media Player problem with Windows 10 Ver 1803

    I recently updated to Windows 10 Version 1803. A few days afterward I loaded a music CD into Windows Media Player (WMP) and though it initially displayed the track titles and other author details, after a couple minutes it cleared and just listed Track 1, Track 2, Track 3, etc. When I...
  16. dbMark

    Migrating from FoxPro 2.6

    VFP is an order of magnitude better than FP, being Windows 32-bit compatible means it will probably work reasonably well for years to come as Tamar wrote. It doesn't do 64-bit or have the latest bells & whistles for the .NET etc advances though it does have flexibility to gain access to some of...
  17. dbMark

    Determine what program has called a form

    Just a side comment about the parameters limit being 26. Years ago, back in the VFP6 days, we would successfully send over 30 parameters to a VFP COM application on a web server. (It was data on 30 data fields plus another couple values.) That was how I found it when I was hired. Even when...
  18. dbMark

    W10 upgrade from W7 starter

    A year ago I had a Windows 10 install fail going from Windows 7 (update from XP version) to Windows 10. It just endlessly rebooted. I set it aside for months. Recently I asked a high school neighbor kid to get Windows 10 on it. In short, what he did was to download Microsoft's latest Windows...
  19. dbMark

    Text editing in Windows 10---problem!

    Do you have a time frame for converting from FoxPro 2.6? Its last release was in 1994, over 20 years ago. No doubt it will function for many more years but installation and maintenance issues will not decrease.
  20. dbMark

    CDX Reindexing

    I have had rare instances where the CDX had, for whatever reason, turned into a zero-byte file. Presumably something crashed early in the update or reindex process. Of course, REINDEX won't work in such a scenario. That's where having prior backups is invaluable. Or having code or special...

Part and Inventory Search

Back
Top