Glad you got it working, Gerard. I used the syntax I did in my suggestion just based on what you had posted earlier. The MyDataSet.MyTable.DefaultView syntax works fine if you're using Typed DataSets. If you're not (which I guess you're not, but I assumed you were based on what you posted earlier), then yeah, you need to use the syntax of MyDataSet.Tables["MyTable"].DefaultView.

But, anyway, glad you got it working now!!

~~Bonnie




>Hi Bonnie.
>Just to let you know I tried out waht you suggested and it worked fine.
>
>I just made one change to the syntax:
>this.dsIFSR.Tables["IFISR"].DefaultView[recnum].Delete();
>
>(If I used just IFISR, without the Tables[" "], I was getting an error.
>
>Regards,
>
>Gerard
>
>
>>Hi Gerard,
>>
>>Did my reply to you for your question in the other thread (Message #965561) not help at all?
>>
>>~~Bonnie
>>
>>
>>
>>>Hi.
>>>
>>>I have a two page Pageframe with:
>>> Page 1: Has a Dataset which lists all records
>>> Page 2: Has each field for a particular record.
>>>
>>>I am trying to set up two buttons which
>>> 1) Deletes the highlifhted record from the Dataset and persists this back
>>> to the database when I Save
>>> 2) Button which adds a blank record -- I then want focus to be set to
>>> Page two
>>>
>>>I have an Update button working fine now for 'amended' records but am unclear how to tackle Deletes or New records.
>>>
>>>Any help or pointers in the right direction much appreciated.
>>>
>>>Regards,
>>>Gerard