delete selected record ?

View: New views
4 Messages — Rating Filter:   Alert me  

Re: delete selected record ?

by Christopher Stanton-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi John,

The highlighted record is put to the user set presumably you can then  
Use Set("UserSet") to make that record the current record?

Something like this for a delete button on the form

Case of
        : (Form event=On Clicked )
               
                   `TRACE
                CREATE SET([Time Records];"Current Selection") `put current  
selection to set for later use
                USE SET("UserSet")
                DELETE RECORD([Time Records])
                USE SET("Current Selection")      `return selection for continued use
               
               
End case

Hope that helps.

Regards,



Chris Stanton



On 6 Apr 2008, at 14:01, john convey wrote:

>
>
> Hi,
>
> Is there a way to 'delete selected record' from a displayed  
> selection on a 4d table
> with one record highlighted?
>
> I have a 'delete button' at the top of a form that displays related  
> many records
> i changed the action to no action and manually code 'DELETE RECORD'  
> - (so i can filter and prevent user deleting some records re  
> business rules)
> However, the highlighted record does not seem to be the loaded  
> current record
> so the system deletes the first in the list....   er not good
>
>
> any advice appreciated - i am trying to avoid having an input  
> (detail)  and output form  - (list)
> to do this all on output/list forms
> but allow the user to 'edit inline' for speed.
>
>
> any thoughts appreciated
>
> thanks
>
> john
>
>
>
> **********************************************************************
> 4D Basics hosted by 4D, Inc.                       http://www.4D.com/
>
> An all-new List box. More features, more power.
> Headers, footers, cell formatting and other goodies.
> See it here first! <http://www.4d.com/livedemos>
>
> To Unsubscribe:                        mailto:4DBasics-off@...
> **********************************************************************
>
>
>



**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

An all-new List box. More features, more power.
Headers, footers, cell formatting and other goodies.
See it here first! <http://www.4d.com/livedemos>

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



delete selected record ?

by john convey :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message



Hi,

  Is there a way to 'delete selected record' from a displayed  
selection on a 4d table
with one record highlighted?

I have a 'delete button' at the top of a form that displays related  
many records
i changed the action to no action and manually code 'DELETE RECORD' -  
(so i can filter and prevent user deleting some records re business  
rules)
However, the highlighted record does not seem to be the loaded  
current record
so the system deletes the first in the list....   er not good


any advice appreciated - i am trying to avoid having an input  
(detail)  and output form  - (list)
to do this all on output/list forms
but allow the user to 'edit inline' for speed.


any thoughts appreciated

thanks

john



**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

An all-new List box. More features, more power.
Headers, footers, cell formatting and other goodies.
See it here first! <http://www.4d.com/livedemos>

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Parent Message unknown Re: delete selected record ?

by Cplusplus :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi John:

The User Set contains ALL records. That's why, the first record gets deleted.
Try using  GET HIGHLIGHTED RECORDS first.

Regards,
Ken Bruce


In a message dated 3/27/08 10:03:26 AM, john.convey@... writes:

>   Is there a way to 'delete selected record' from a displayed 
> selection on a 4d table
> with one record highlighted?
>
> I have a 'delete button' at the top of a form that displays related 
> many records
> i changed the action to no action and manually code 'DELETE RECORD' - 
> (so i can filter and prevent user deleting some records re business 
> rules)
> However, the highlighted record does not seem to be the loaded 
> current record
> so the system deletes the first in the list....   er not good
>
>




**************
Create a Home Theater Like the Pros. Watch the video on AOL
Home.
      (http://home.aol.com/diy/home-improvement-eric-stromer?video=15&
ncid=aolhom00030000000001)

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

An all-new List box. More features, more power.
Headers, footers, cell formatting and other goodies.
See it here first! <http://www.4d.com/livedemos>

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************



Re: delete selected record ?

by Atanas Atanassov :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

john convey wrote:

>
>
> Hi,
>
>  Is there a way to 'delete selected record' from a displayed selection
> on a 4d table
> with one record highlighted?
>
> I have a 'delete button' at the top of a form that displays related
> many records
> i changed the action to no action and manually code 'DELETE RECORD' -
> (so i can filter and prevent user deleting some records re business
> rules)
> However, the highlighted record does not seem to be the loaded current
> record
> so the system deletes the first in the list....   er not good
>
>
> any advice appreciated - i am trying to avoid having an input
> (detail)  and output form  - (list)
> to do this all on output/list forms
> but allow the user to 'edit inline' for speed.
>
>
> any thoughts appreciated
>
> thanks
>
> john
>
>
>
> **********************************************************************
> 4D Basics hosted by 4D, Inc.                       http://www.4D.com/
>
> An all-new List box. More features, more power.
> Headers, footers, cell formatting and other goodies.
> See it here first! <http://www.4d.com/livedemos>
>
> To Unsubscribe:                        mailto:4DBasics-off@...
> **********************************************************************
>
Try to use REDUCE SELECTION command, this will make your selected  
record current and you can dellted

Kind Regards

Atanas Atanassov

Technical Servece Team Member
4D, Inc

**********************************************************************
4D Basics hosted by 4D, Inc.                       http://www.4D.com/

An all-new List box. More features, more power.
Headers, footers, cell formatting and other goodies.
See it here first! <http://www.4d.com/livedemos>

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************