Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Hi nadya,
>Is it changed when you do requery() ?
When you do a requery you'll have to specify the where condition in the cWhere variable. If is very powerfull as the alternatives of having the switches in the fixed whereclause are seldom rushmore optimizable.
With in the requery routine, you can construct the whereclause any way you like: You can even incluse subqueries if you like. However one note: Though this works fine for local views, this is not supported for remote views :(
Example: SELECT * FROM maindata!s_audit WHERE ?&cWhere
>It doesn't allow me to do it. I open ViewSQL, remove my where condition and put &cWhere instead of the whole where clause. It produces an error and reverts back to original filter. What can I do?
There is a little workarround you'll have to know. You can put anything in the SQL window and don't click to the GUI window, but inmediately click close on the GUI window. It will bypass the checking and saving the definition. when reopening the view, you will get a syntax error, but it will open the SQL window, so you can change it.
Walter,
Précédent
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