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 derfloh 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 KarenJB

  1. KarenJB

    Index Violation - VFP 9.0

    Yes Mike, I did try that with no luck. This is just as Churchill described: a riddle, wrapped in a mystery, inside an enigma. Thank you anyway.
  2. KarenJB

    Index Violation - VFP 9.0

    No worries, I can just rebuild that index manually if the need arises. Thanks for all the ideas, keep up the fight!
  3. KarenJB

    Index Violation - VFP 9.0

    Tore, I appreciate the sentiment but out of my control.
  4. KarenJB

    Index Violation - VFP 9.0

    Mike, It can contain deleted records, I just packed the file to ensure that it didn't. The application has a procedure to pack also.On the recall I browsed the file and could identify the record it stopped at. I tried recalling all but that record and it stopped again.
  5. KarenJB

    Index Violation - VFP 9.0

    I ran the command again using CIDEMPL and found no duplicates.
  6. KarenJB

    Index Violation - VFP 9.0

    Tore, I ran that and it did find records but there can be multiple records with the same empno. It's the cidempl field that is unique.
  7. KarenJB

    Index Violation - VFP 9.0

    I even deleted all the records in the table and ran that index command successfully. When I tried to recall all, it stopped part way through with the unique error again.
  8. KarenJB

    Index Violation - VFP 9.0

    No null values in those fields.
  9. KarenJB

    Index Violation - VFP 9.0

    Thanks for the quick reply! There are no deleted records in the table, it has been packed. Also, I have checked for blanks records and there are none. I even wrote a quick program to make sure the CIDEMPL field did not have a duplicate value.
  10. KarenJB

    Index Violation - VFP 9.0

    Hello experts! I am overseeing a VFP application that was purchased from an outside vendor who is no longer available for support. The application has a reindexing procedure that bombs out with a uniqueness of index EMPNO is violated error. I can replicate that error by running INDEX ON EMPNO...
  11. KarenJB

    Retrieving Active Server Information

    Thanks Dan, just what I needed! This is the best forum on the internet!
  12. KarenJB

    Retrieving Active Server Information

    thread184-1143741 I am trying to get information from Active server and found this code in the thread shown above: strDomain = "ontario.cnty" && Your own domain name Clear On Error Public PrimDomainContr Create Cursor names (username c(30),fullname c(80),description c(80),Class...
  13. KarenJB

    Math Calculation Help... Working with stripping Minutes

    I just threw out my answer using the integer and mod functions as a quick example. I was a little hazy on what the final desired outcome was so I figured that would suffice. Int gave hours and mod gave the minutes. You can then turn the minutes into 1/4 incremental units with a case statement...
  14. KarenJB

    Math Calculation Help... Working with stripping Minutes

    This might work.... nMin = 74 ? LTRIM(STR(INT(nMin/60))) + ':' + LTRIM(STR(MOD(nMin,60)))
  15. KarenJB

    SQL Pass Thru

    Text Thank you one and all, I finally got this to work using Cetin's methodology. It was a great tip to use the Text, EndText. I could actually see what was really going on. I certainly appreciate everyone's input and timely response to this matter. I am sure I will need to call on the...
See more

Part and Inventory Search

Back
Top