Ever worked with frx's?
Look into reportdesigner if you like to see cruel code ...
(^_^)
>Rule # 1: Never make an application where the record number is important, use index tags instead.
>Rule # 2: If the record number is important, rethink your design and see rule # 1.
>Rule # 3: There are NO exceptions to these rules.
>
>>ok Sorted this.
>>It appears that if the table has any index file associated (even though you have not Set Order to) , it always appends the row
>>If all Indexes are removed from the table, it works fine
>>
>>
>>>Hi.
>>>I have a small basic DBF with a few fields and I want to insert a row
>>>I position myself on the 3rd row OF 10
>>>No indexes are on
>>>
>>>INSERT BLANK BEFORE
>>>
>>>but it appends a row at the end (i.e. 11th record instead of being the 2nd record)
>>>I know I have done this in the past , but cant get it to work today.
>>>What am I missing ?
>>>
>>>Tia
>>>Gerard
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]