Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Vertical block chr in corrupt dbf
Message
De
14/09/2004 12:18:21
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
14/09/2004 12:09:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00941947
Message ID:
00941950
Vues:
26
>Hi,
>
>I have a table that has corrupt data in several of the fields. I'm sure this corruption is caused by my program because it reappears after repair within a few weeks. When I browse the table the corrupt data appears as vertical blocks in the field. Since as I can't find where the code is corrupting the data I thought it might be helpful to determine what the corrupt looked like but so far I have not been able to read the corrupt data. Does anyone know of a function or something that might provide a way of reading this corrupt data? So far I think the fields contain zero's (0) but I doubt that a vertical black block would be displayed if the data was just a binary 0. From the command box a left(myitem,1) will display a rectangle.
>
>TIA
>John

John,
for ix=1 to len(myItem)
 ? asc(substr(myItem,m.ix))
endfor
PS:If your primary key is integer do not make it the first field (ie: put a dummy c(1) field before it).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform