Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trouble with a field of my table
Message
From
26/06/2000 15:37:16
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Trouble with a field of my table
Miscellaneous
Thread ID:
00384737
Message ID:
00384737
Views:
57
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
Next
Reply
Map
View

Click here to load this message in the networking platform