>Sometimes the following does not return any data for me:
>
>CREATE TABLE MyTable (MyField C(10))
>APPEND BLANK
>REPLACE MyField WITH "TEST"
>SELECT * FROM MyTable WHERE MyField = "TEST"
>
>Any ideas why this sometimes fails to return anything?
>Note: If I Issue a GO RecNo() just after the REPLACE command, it works. But in my application MyTable is a huge File and I aam worried this will reduce performance if I Have to issue a GO RecNo() After every replace.
You mean, it's inconsistent?
I cut and paste the exact code you posted and it works fine here. Is the file have relationship to other tables?
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."