Hi!
Just check befor tablerevert() if there are records and after Teblerevert() - if you have an eof(). If yes, then you have that situation (no other situation might cause eof() in gri'ds record source). To fix it, add a new record manually - just APPEND BLANK command. Then refresh the grid.
>I am trying to develop an entry form with two DBF
>SALEMAST.dbf(parent) and SALEDET.dbf(child) with
>joining field INVOICENO and Child table contain another field Itemcode
>
>The SALEDET is attached to GRID but the grid contains no column with
>INVOICENO field. and Allownewreocrd property is set to .T.
>
>At the begining when I add record to parent I append a blank record
>to the child and replace child INVOICENO field with Parent INVOICENO
>field.
>
>And when entering record in GRID with DOWN ARROW, I again replace the
>child INVOICENO field value with parent INVOICENO field.
>
>Upto this, it is working fine.
>
>But I don't what any record in child table with blank Itemcode
>Now when I am at the last row of GRID with blank Itemcode column -
>if I key in UPARRROW - I use tablerevert(.f.,'saledet')
>and record pointer move to the above row.
>
>But if I key-in DOWNARROW, then again tablerevert remove the record
>with blank itemcode but record pointer move to EOF() and
>grid contains no row.
>
>
>Suggest me some solution.
>
>Aritra
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.