Re: C5 Error on one record

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Well, stick with the scan for now ... try to find if it's a particular record somehow ... add nofilter to all of the sql selects involved, check for triggers & screwy things like field valid functions that the dbc may be throwing in...
"Tom Libby" <tlibby@xxxxxxxxxxxxxxx> wrote in message news:%23W7OdpkHJHA.3960@xxxxxxxxxxxxxxxxxxxxxxx
It is a Parent -> Detail -> Sub Detail relationship using text boxes and combos on the header and grids for the detail and sub detail. Some times the C5 error occurred when you navigated to the header record other times it was after working with the data.

No FOR clauses on the indexes.

I wrote a routine to inspect every character in the tables and all the characters where fine, A-Z and 0-9 with a few / and #.

I did the following none of which helped:
1. Packed the tables and then rebuilt the indexes from scratch I did not use REINDEX.
2. Copied the data out to txt files. Zapped them and imported the data from the text file.
3. Deleted the tables, rebuilt them and then imported the data from the txt files.

The code was originally always crashing on the same line of code which was a SUM command, I changed that to a SCAN
and then the user was able to get further with using the form but always came back to the C5 error. This time it was not on the same line of code but just randomly.

One thing I failed to mention was the data is copied from the three tables into cursors with SQL SELECT statements so the data they are working with is in cursors and not the actual tables themselves.

I have 8 users using this form from 8:30 AM to 7 PM with no other problems. It is just this one set of data.

I do plan on getting back to this when it calms down here. I am the only developer here, and they have more pressing things for me to do.

Thanks
Tom

"Lew" <lew@xxxxxxxxxxx> wrote in message news:eX2q2XdHJHA.1156@xxxxxxxxxxxxxxxxxxxxxxx
Is the 'going to a record' in a browse window, a form or what? What happens if you delete the bad rec & pack/reindex (save your backup, of course)? Do your troubleshooting with set deleted off. Do the cdx's have for clauses? Also, kill any on error routines & triggers that might be firing behind the scenes & masking what's going on.

"Tom Libby" <tlibby@xxxxxxxxxxxxxxx> wrote in message news:O2k6YZBGJHA.2112@xxxxxxxxxxxxxxxxxxxxxxx
We have a form in VFP7 SP1 that when ever a user goes to a certain record they eventually get a C5 error, It is only happening on this one record. I have looked for data corruption, rebuilt the indexes, and copied the data out of the table and back in again. I also ran Recover form Abri and it reports no errors with the tables.

The C5 was occurring on a SUM command on a temporary cursor. I found a KB Q327858 so I changed the SUM to a scan but that had no effect.

I am planning on deleting the tables from the DB and building them from scratch and then appending the data back in.

Anything else I could/should be doing?

Thanks
Tom





.

Relevant Pages

  • Re: Slight "I have some string, how lng it it, BTW, its blue" question
    ... can you expand on what you mean by 'Using cursors to do your join'? ... As I stated before....if you can do it in SQL, choose that approach over PL/SQL. ... So if you have a view call a view, and your write SQL to reference the first view, Oracle will merge all the views into your SQL statement and then execute the entire thing as one large SQL statement. ...
    (comp.databases.oracle.misc)
  • Re: Slight "I have some string, how lng it it, BTW, its blue" question
    ... can you expand on what you mean by 'Using cursors to do your join'? ... Most every time, SQL will beat PL/SQL. ... Oracle will merge views by default. ... over documentation every time. ...
    (comp.databases.oracle.misc)
  • Re: A new proof of the superiority of set oriented approaches: numerical/time serie linear interpola
    ... a performance improvement, I'm sure that makes you feel good but you ... This one added to the hundred others taking out cursors. ... languages like T-SQL or PL/SQL are ... SQL and sets only, ...
    (comp.databases.theory)
  • Re: Migration recommendations; PRELIMINARY INQUIRY
    ... that trying to use Cursors on a RDMBS will ... never give you the performance you can get from native SQL approach. ... It is more expensive in terms of labor costs to redesign your application ... any redesign is more risky than a simple migration. ...
    (comp.sys.hp.mpe)
  • Full text search giving incomplete results
    ... I've rebuilt the index, ... don't mind if it takes more server resources, I need to be able to find all ... catalog, deleted/recreated, but it's not improving. ... Do I have to completely re-install SQL? ...
    (microsoft.public.sqlserver.fulltext)