>>>This form works ok in development, at runtime it displays 'record is out of range' error. The error generates after clicking a command button. The fun part is that it says 'In .CMDRUN.CLICK at line 0'. The form does not have any tables loaded.
>>>
>>>TIA
>>
>>Most case is the record pointer has jumped to EOF but you still need to show record content. This will cause problem especially at GRID. For other controls, such as textbox, it will be disabled.
>>
>>In my case, similiar when I put a command button which allow
Undo Add New>> record! That is, Tablerevert() on Grid adding new Orderline.
>>
>>Quite problem even using refresh, the grid still show
No record(s).
>>THis happen especially at last record and add new then Undo!
>>Finally, I make some tricky refresh and locate record and fix it.
>>But I don't think it is a good practice. >~<"
>
>Last sentence on my post reads "The form does not have any tables loaded".
>
>Thanks for the reply.
>
>P.S. Justok, I particularly try my hardest to stay away from the grid control. It's just a pain in the retaguard.
Sorry, ummm Let me guess! Do you have any coding like:
Clear ALL the table will be closed even you have add a DE!
2nd, try to figure out the
current working area by lSelect= select()
trace out it.
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.