>>Gerhard,
>>
>>the Init event is to late. The data is open there. The OPEN_TABLES ist the event where you should place your code.
>>
>>Note also that a SQL SELECT (a view is one) on SET DELETED OFF will get all records, even the deleted ones as non deleted. IOW a record marked as deleted on the source will becom not deleted on the result.
>>
>>Posibly you might run a REQUERY against your view in INIT like
>>
>>SET DELETED ON
>>REQUERY()
>>
>>
>>This will not work if the view is cascaded.
>
>Hello Lutz,
>
>Thank you!
>I moved SET DELETED ON to the BeforeOpenTables of the DE of the report. Now I can use a private datasession without problem.
>
>But :-))) :
>This is only possible in the Developement environment. I can not set this in the runtime environment. Is there a way to change this setting in runtime?
>
>Gerhard
I do not understand
If you put the code in the DE OPEN_TABLE it should run at runtime? Just put it in and leave it there by default? Whether or not in Private DE ...
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]