Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
>>>What is the exact difference between two?
>>
>>>I do need to set order for SQL-Select using OLD style indexes (IDX). That was discussed recently on UT and Hugo R helped me to understand that. For these tables we're using old style IDX indexes.
>>
>>I think you need to SET INDEX TO to open the .idx so it can be used for Rushmore. I can't prove that at this moment.
>>
>>I'm pretty sure you don't need SET ORDER.
>
>Let me try without, but I'm not yet sure it's relevant. E.g. with or without order it should still produce the correct result, what do you think? When why I got two wrong invoices listed as mismatch and why I can not reproduce the problem in the command window for the mismatched invoices, but do receive exactly the same two invoices as wrong. I really can not understand what's going on.
What if the .idx file wasn't updated? The query may pull the correct result, but the seek and sum while won't.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement