Namely, I have a view defined which is the final result of many complicated queries. To the definition of this view, I added two parameters in the "where" clause, limiting the date range of the resulting data from the bottom and from the top. Everything works as it should if I open the table means view in edit mode and then run it. The parser asks for parameters and everything is OK, but if I immediately run this view (double click on the view name) the parser does not ask for parameters and shows the result window without any data....
Did I miss any option or is this a design assumption or maybe a bug....?
View SQL content:
Code: Select all
select ..... from ..... WHERE "v_wynik1"."data_pobytu" BETWEEN :DataStart AND :DataStop
In this example, the conditions look like this:
Code: Select all
select ..... from ..... WHERE "v_wynik1"."data_pobytu" BETWEEN :DataOd AND :DataDo
Anyway, it behaves similarly (meaning stupidly) if I want to modify these names by inserting the "_" sign between that is "Data_Od" and "Data_Do"