Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Numeric field cannot be sorted
Message
From
19/09/2008 06:10:53
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Numeric field cannot be sorted
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01348846
Message ID:
01348846
Views:
54
Hi,
I made a select sql like this:

Select * from temp;
where temp.total >= 40000;
into cursor temp2

temp.total is a numeric field(9,3) and although this select sql's always worked correctly and there are records which meet the condition, now it results none.

Any help

Tamas
Next
Reply
Map
View

Click here to load this message in the networking platform