Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Chr(0) problem - please help ...
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00486496
Message ID:
00486734
Vues:
13
Hi Andreas,
A lot of people use SQL-Server with VFP6 (although not everyone has upgraded to SP5 yet). Check out the records/fields with NULL values in your SQL-Server. I've found that moving NULL values into VFP cursors will sometimes cause the problem you're seeing. I use NVL() on every field that might be NULL and it seems to work.

HTH
Barbara

>I think, I'm the first software developer who uses Visual Foxpro 6.0 (SP5) with SQL-Server 7 (SP3). Therefore I want to ask, if someone else uses this combination (or does everyone uses foxpro tables)?
>
>When deleting a row-bufferd view in a transaction, I have the reproduceable problem, that in some cases the cursor get curropt (vertical lines = chr(0) in each field of the cursor). The data on sql-server isn't corrupt. This problem was solved by requering after deletion (a solution, but not the best one).
>
>Today I have the problem, that updating a cursor corrupts a cursor. The
>largeness of the cursor can't be the problem, because there are 10 or 20
>records in the test cursor.
>
>Does anyone have the same problems and / or know a solution?
>
>Thank you
>Andreas
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform