Searches not returning correct results

[Chuck Neal]

Do you mean the single/double quotes are the problem?  This does not 
work in Studio.

I finally did an export and was able to get a clean import that now 
works in Director but Studio still returns invalid results

I have not been able to identify exactly why but it seems that in 
programming, over time stops and starts cause bad data in the database. 
  Often this shows with it thinking there are supposed to be more 
records than there are. Enough of these and it gets unstable and 
corrupted.  Not fun...

-Chuck
--------------------------
Chuck Neal
CEO, MediaMacros, Inc.
chuck at mediamacros.com
http://www.mediamacros.com
http://www.mediamacros.net


Ivan Smahin wrote:
> 
> On Mar 31, 2006, at 11:10 PM, Chuck Neal wrote:
> 
>> I have a program that started acting up.  I traced it down to the 
>> SELECT searches not returning the correct results.  Here is an example...
>>
>> SELECT * FROM Technique_Option WHERE option = "I2G8L5-11Q5GIK-T47Q0I-2T"
>>
> 
> But it seems the query should be next:
> 
> SELECT * FROM Technique_Option WHERE option = 'I2G8L5-11Q5GIK-T47Q0I-2T'
> 
> 
> 
> 
> Best regards
> Ivan Smahin
> 
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>