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 Chriss Miller 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. 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...
  16. KarenJB

    SQL Pass Thru

    The connect worked....
  17. KarenJB

    SQL Pass Thru

    This code runs in SQL Query Analyzer just fine..... SELECT OffenderEvent.PersonId, EventInfo.Comment, EventInfo.StartDate, EventInfo.TypeDescription FROM OffenderEvent INNER JOIN EventInfo ON OffenderEvent.EventId = EventInfo.Id WHERE OffenderEvent.PersonId=180197 How do I 'punctuate' it for...
  18. KarenJB

    SQL Pass Thru

    Mike, I took the ? out and still get the same results, Alias 'Results' is not found. JRBBldr, I created a query in Access 2000 that show this code and works fine. I wasn't sure what to add to it to put the data in a table. SELECT dbo_OffenderEvent.PersonId, dbo_EventInfo.Comment...
  19. KarenJB

    SQL Pass Thru

    I am trying to gather information from a SQL Database using SQL pass thru. Here is the code that I am attempting to run using VFP 9..... SQLEXEC(lnHandle,"SELECT dbo_OffenderEvent.PersonId, dbo_EventInfo.Comment, dbo_EventInfo.StartDate,; dbo_EventInfo.TypeDescription; FROM dbo_OffenderEvent...
  20. KarenJB

    Traffic Question

    Thanks everybody for the input. The users are all local with a fiber connection so things run just fine. The guy that said this is just anti-Foxpro and knows nothing about web-based applications to begin with. I just wanted some reassurance and you have provided that. I have written several...

Part and Inventory Search

Back
Top