On BeforeCursorRefresh , i write:
LPARAMETERS cSelectCmd
cSelectCmd = [SQLscript]
VFP ignore [SQLscript] and send the input cSelectCmd.
Result:
- BeforeCursorRefresh is little useful ( can cancel the process only )
- If on BeforeCursorFill i put a not parametric SQLCmd,
i cannot refresh the cursor with a new SQLCmd.
I understand that who has constructed the CA has left from the RV,
where "SQL" it is ReadOnly,
but does not have to render also the design errors compatible.
With this limit, the CA forgiveness 50% of their potential one.
Compliment!
Fabio