First, thank you for your message.
The approach with zapping the cursor won't work. This is a buffered cursor and you can't zap it. And you can't Delete All and Pack it either because it is a remote table.
If I understand you correctly and you mean "setting record source = space(0)" of the grid, I think this will make the grid lose all its properties.
What I don't understand is that there is no "new data" for the grid, the RecordSource of the grid does not change.
>This has been this way since I can remember. One possibility is to set the recordsource = space(0) before the cursor closes and the setting record source = "yourcursor" after the new data arrives. If this doesn't work then you can zap the cursor and load the new data into another cursor and then append from new cursor into old cursor.
>
>>I have a form with pageframe. On page 1 fields are bound to a view/cursor A. On Page 2 there is a grid bound to a view/cursor B.
>>If the code closes cursor A and gets a new one from SQL Server (based on some user defined conditio), the grid on page 2 loses all properties. Actually the grid on Page 2 becomes blank (no columns, no rows). Note that cursor B has nothing to do with cursor A.
>>
>>Is this a bug or this is the way it is supposed to work?
>>
>>Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
