RE: VFP 9: Peculiar Query Behaviour

2015-04-20 Thread Gene Wirchenko
At 12:30 2015-04-20, Richard Kaye wrote: Gene, If I'm reading this right, you are running a query without specifying an "INTO" clause? When you do this, VFP will call its result cursor QUERY which Yes. describes the behavior you are seeing. (SQL passthrough will call its result curso

Re: VFP 9: Peculiar Query Behaviour

2015-04-20 Thread Gene Wirchenko
At 12:22 2015-04-20, Fred Taylor wrote: Unless you specifically close the cursor named"Query" or re-use it's workarea for another table/cursor, it will remain open. Not sure I really understand the problem. Well, I use this pattern a lot, and I do not recall ever seeing this. Observer

RE: VFP 9: Peculiar Query Behaviour

2015-04-20 Thread Richard Kaye
Gene, If I'm reading this right, you are running a query without specifying an "INTO" clause? When you do this, VFP will call its result cursor QUERY which describes the behavior you are seeing. (SQL passthrough will call its result cursor SQLRESULT if you don't specify an alias.) Closing the b

Re: VFP 9: Peculiar Query Behaviour

2015-04-20 Thread Fred Taylor
Unless you specifically close the cursor named"Query" or re-use it's workarea for another table/cursor, it will remain open. Not sure I really understand the problem. Fred On Mon, Apr 20, 2015 at 11:40 AM, Gene Wirchenko wrote: > Dear Vixens and Reynards: > > I am digging into the guts of