Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trouble with a field of my table
Message
De
26/06/2000 15:37:16
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Trouble with a field of my table
Divers
Thread ID:
00384737
Message ID:
00384737
Vues:
59
In my table, I have a field named iCodeTerm. This field is integer type, with values varying between 0 and 99. A problem appears from nowhere. When I do a very simple SQL query, like the following:

SELECT * FROM MyTable WHERE iCodeTerm=0

I got a fatal error (Exception Code C0000005).
But, if I change the WHERE clause by EMPTY(iCodeTerm)
or if I try iCodeTerm>0, I don't have this problem.

Is my table corrupted?
Marc Levesque
La Prairie, Quebec (CANADA)
marc.levesque@videotron.ca
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform