>I have been adding records to my test SQL Server table all day. Now I noticed that after I add a record (from VFP app), I go to Enterprise Manager, open the table, and select to Return All Rows, I don't see the new records. It looks like that PK value got stock on 9384. Yet, I can retrieve the newly added record from my VFP app.
>
>What am I missing? Or do I need to refresh something in the Enterprise Manager to see the new records?
>
>Thank you.
I just noticed that the newly added records are somewhere in the middle of the table, not at the end. Why? In what order does Enterprise Manage show the records when you open a table?
"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