Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
'Not a table' error message
Message
De
10/07/2000 11:38:33
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
 
 
À
10/07/2000 11:14:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00390028
Message ID:
00390254
Vues:
9
Louis,

First of all, make a copy of your form (scx and sct) and play with the copy. Nothing you do with the copy will hurt the original. When you've got the copy right, make another copy of the bad original and then overwrite the bad original with the file that works.

The HexEditor dowsn't care about the extension of your file. You don't have to rename as dbf. Also, you can say USE? and then change "Files of type" to "All files" and FoxPro will attempt to treat anything you choose as if it were a table. (DBF, SCX, FRX, PJX are all just tables.)

Now, with the HexEditor running,
Left side is Address, middle has 0-F and right side has Text. The text is only FoxPro's attempt at treating the bytes as text, and they are not always text. You need to work with the 0-F area.

Hopefully you learned some Hexidecimal arithmetic in school. It is base 16 so after 9 comes A, B, C, D, and E. The next number is 10, which corresponds to a decimal 16.

The 4th byte is under the "3" column since the columns start with 0. You need to subtract 1 from this. IF it says "2E", change it to "2D". Note that if it says "20" you need to change it to "1E" since that is the next smaller number in base 16!!!



>Hi Cindy,
>
>Let me back up a little. The corrupted file I had was an .scx file which has a corresponding .sct file. I had come back to modify the form (scx), the file that is corrupted, after saving it a few hours before. When I hit the modify button on the Project Manager I didn't get a response at all. I then press on the Run button and I got the "Not a table" error message (I was devastated). Someone had told me that scx files are actually dbf files. What I did was to make a copy of it and then renamed the extension of the scx file to dbf and the sct file I renamed fpt. I double clicked on the dbf file and I got the same message “Not a table”.
>
>You suggested that I open up the dbf file with the HexEdit program. When I opened the dbf file with the HexEdit program all I got was bunch of zeros under the 0 – F columns and a bunch of little squares under the ‘Text’ column. I also tried opening the file as an scx file under the HexEdit program I get the same zeros and sqares. Does this mean that I lost this file for good? :(
>
>I haven’t tried subtracting a 1 from the 4th byte because I don’t know which is the 4th byte. If you need me to, I can send the two file to you.
>
>I hope you have some good new for me.
>
>Thanks for your help and kindness,
>
>Louis
>
>Some extra information:
>The scx (dbf) file is 16k
>The sct (fpt) file is 118k
>The form had a formset with 3 forms.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform