Did you tried to defined in the Init of the cursor?
Is is defined Local or Private in the other places?
My self, I do open the tables of the DE in the load of the form and make the variable Private if I a have a view
before the opentables(). The AutoOpenTables properties is False.
Hope it help.
Steve
>Hi all,
>
>I have a view with this code,
>
>SELECT DISTINCT *;
>FROM jbfic!familias LEFT OUTER JOIN jbfic!familiascli ;
>ON Familias.c_codigo = Familiascli.c_codigo;
>AND Familiascli.c_codcli = ?codcli;
>ORDER BY Familias.c_codigo
>
>In form DE i have noDataOnLoad=.t. but when i run the form it ask me to enter the value for codcli.
>
>I set this value for ex. in BeforeOpenTables and it ask again, and the same if i do it in the form load event.
>
>Any ideas,
>
>Thank's in advance,
>
>João Batista