Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with LEFT JOIN
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Divers
Thread ID:
00978845
Message ID:
00978990
Vues:
45
>Nadya,
>
>>(BTW, why View designer puts "(" this strange way and how can I fix it?)
>>
>
>The parenthesis can be adjusted using the Pri. (Priority) column on the Filter tab in the View Designer. If you don't want any parenthesis, set all conditions to the same priority. If you want to have parenthesis around 2 conditions, give them a lower number (higher priority), and your other conditions a higher number.
>
>Sometimes I 'View SQL' and set the parenthesis how I want them, but the View Designer changes them, and I have to set the numbers manually.

I played with the Priority Order for a while but was unable to set it the way I want. So I went to View Editor, set them there, then View Designer at least had the correct order, though it inserted lots of additional parenthesis.

BTW, I have a question on the View Editor. Does it allow to save View Parameters? I set them once, but I wanted to change them lately and didn't find an option to save my new parameters.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform