General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>You would think, FoxPro would be smart enough to find the record with the Key, then check for conflicts... rather than just building such an ungly update statement.
>>>
>>>Perhaps someone close could mention this to Randay Brown or Calvin Hasia... I
>>am sure they could fix it!
>>>
>>>BOb
>>
>>
>>Thanks for the explanation.
>>
>
>So did making the WHERE type change fix your performance problem?
>
>BOb
Yes. Modifying the Where settting so only the Key is in the Where clause fixed the problem. I just wonder why it defaults to such an ugly setting. Anyway, it works great now.
Thanks,
Tom
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only