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 DO.T 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@lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
_______________________________________________
Valentina mailing list
Valentina /AT/ lists DO.T macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2006 Chuck Neal |
