set delete with views

[CJ CraigMoore'DSIgroup.com]

Hi all,

I have a view that comes from two related table on a database. i want to
be able to mark one of the base table for deletion and requery the view to
to remove the marked records, however when ever i try this i still get all
records in my view(i have got set dele on), i have tried trying this with
a new view and it does remove the marked records, i have got a filter on
the view. can anyone tell me why i am still getting the marked records in
my view, i know thaat any kind of index command ignores dele marks, but is
there something similar for views.

many thanks,

CJ

[Anders Altberg]

Hi
You will not see the modifications until after a TableUpdate(1, .T.,
'viewname') call. If the data is in a grid it's likely even table buffered.
-Anders

<CJ CraigMoore'DSIgroup.com> wrote in message news:3b8f9fdf@news.devx.com...
>
> Hi all,
>
> I have a view that comes from two related table on a database. i want to
> be able to mark one of the base table for deletion and requery the view to
> to remove the marked records, however when ever i try this i still get all
> records in my view(i have got set dele on), i have tried trying this with
> a new view and it does remove the marked records, i have got a filter on
> the view. can anyone tell me why i am still getting the marked records in
> my view, i know thaat any kind of index command ignores dele marks, but is
> there something similar for views.
>
> many thanks,
>
> CJ

[CJ]

Thanks Anders,
I worked out what was going wrong, i was still getting the marked records
even once i had issued the tableupdate command. i was setting dele on in
my main prog, but when stepping throught i noticed that when i launched one
of my forms the set dele was being set back to off. the form had a private
data session, sorry for wasting your time. i will try not to be so stupid
next time.

many thanks,

Craig

"Anders Altberg" <anders.altberg@swipnet.se> wrote:
>Hi
>You will not see the modifications until after a TableUpdate(1, .T.,
>'viewname') call. If the data is in a grid it's likely even table buffered.
>-Anders
>
><CJ CraigMoore'DSIgroup.com> wrote in message news:3b8f9fdf@news.devx.com...
>>
>> Hi all,
>>
>> I have a view that comes from two related table on a database. i want
to
>> be able to mark one of the base table for deletion and requery the view
to
>> to remove the marked records, however when ever i try this i still get
all
>> records in my view(i have got set dele on), i have tried trying this with
>> a new view and it does remove the marked records, i have got a filter
on
>> the view. can anyone tell me why i am still getting the marked records
in
>> my view, i know thaat any kind of index command ignores dele marks, but
is
>> there something similar for views.
>>
>> many thanks,
>>
>> CJ
>