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 13:54:55
 
 
To
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:
01050011
Views:
18
YEAH!!!

>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.
Groet,
Peter de Valença

Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
Previous
Reply
Map
View

Click here to load this message in the networking platform