Recent content by KarenJB

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.

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

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

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.

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

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.

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.

No null values in those fields.

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.

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

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

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

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

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

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