>what I really want is an updatable SQL cursor, but the best I can figure is to create a view, and use the view. however, once the view is used, the result does not seem to go away when I close the form that uses it. the source tables get updated, but the view does not reflec the changes.
>
>here is my SQL, I need to be able to untag users, I am using a grid.
>
>SELECT DISTINCT .T. AS mgtag, Wilog.lguid, Wilog.lgusrnam, Wilog.lgstano;
> FROM whoin!wifls INNER JOIN whoin!wilog ;
> ON Wifls.flkey = Wilog.lgflkey;
> WHERE fltag = .T.;
> AND lgdtt >= flldtt
>
>Carl
Did you REQUERY the view??
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
