Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL select brings record over even when not match
Message
From
15/09/2005 12:30:17
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01049862
Message ID:
01049977
Views:
19
Okay, you get a star too. ;-)
It was a combination of everyone saying that the one line should work in a where and me trying to do a quick fix, that I spotted the real problem and fixed it.

Have a great weekend.
>For ONE time I was quicker than Sergey. Nevertheless you gave him a point and none to me. It just isn't fair. You spoiled my day. <g>
>
>>Found it. The .NULL. in that field were causing the problem. Converted them to "" and It works now.
>>
>>Thanks for the Help.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform