>I am having a hard time for the past few hours figuring out a problem.
>
>The question is..
>
>Could VFP be picking up the old cursor with the same name from my disk cache somehow... If it is I have deeper problems...
>
>
>Here's what happens...
>
>I am doing a very special query for a customer...
>-I run a SQLEXEC() to oracle and return a cursor called MERCHSHEET.
> *There are 4 variables in the where calues I enter on a form...
>-Then I select the sheet and create a cursor with afields called tmpqry.
>-Then I loop through the merchsheet and do some special processing putting
>completed records in the tmpqry...
>-Then I
>use in merchsheet
>use tmpqry again in 0 alias merchsheet
>use in tmpqry
>select merchsheet...
>
>Now I have my new merchsheet and everything is cool until..
>
>I run the new query with new parameters. Every time I still get my old results...
>
>I'vd stepped through and can't see any problems.
>
>The only thing that fixed it was using create table to create tmpqry instead
>of create cursor then it works great. But I have problems cause it's a citrix app...
>
>???Anyone now what could be wrong?
Tim,
Actually I don't have a clear idea.
Instead of :
use tmpqry again in 0 alias merchsheet
use dbf('tmpqry') again in 0 alias merchsheet
might help. Second (I don't know Citrix so don't know what would it make a difference) 'create table' and 'create cursor' doesn't have a difference except automatic cleanup of cursor files. Both at the end write to disk.
Cetin