Search results for query: *

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

The connect worked....

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

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

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

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