Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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,
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