Delete from list control using button

[gregincolumbus]

I have looked for this in the videos and documentation, but I can't find what I need. I want to have a button in a list control that deletes the selected record. I have used:

{dialog.object}._listRemoveSelectedRows('Contact');

And that temporarily removes the row from the list, but it does not actually delete the record. Do I have to use a popup UX component and delete it from that or is there a method that allows a delete by clicking a button in the list? I am using MySQL as my backend.

Thanks
Greg

[Davidk]

Re: Delete from list control using button

The List control is more of a Read-only control... than an editing control. I believe more is coming for the List control that will allow a detail view of the record selected without going to a separate UX. I don't think it's all wired up yet.

You could open the record selected in a UX and delete it there... or fire off an ajax callback which would delete the record at the sql level.

[gregincolumbus]

Re: Delete from list control using button

Thanks David

I thought that was the case, but figured I would ask just to make sure.

[dantum]

Re: Delete from list control using button

In theory you can do this.

You can great an action that deletes a records. And put a button on the list control to delete it. You will need to do it all behind the scenes and then refresh the list.

One way would be to pass a SQL statement which would just fire a delete action. Or you can put a dialog that will not be navigated to and fire a delete action via predefined control. When it's done it can bring up a popup dialog box and then refresh list. Sorry I generalised it all but there are ways of doing it.

[mixter]

Re: Delete from list control using button

Yes what DavidK and Dan said (fire off an ajax callback)

Create a Button control

Javascript Click event >>

choose Server-side XBasic

and it will make some SuperLongServerSideRandomFunctionName for you

add some code along the lines of this (I just tweaked some of my code as an example, this is not strictly tested code, and I am using SQL Server not MySQL, so the MySQL call to execute your Stored Procedure might be slightly different... post back your code here if you go down this path!)

function serverside_25e008027bbc4499a84542214401afb2 as c (e as p)

	dim cn as sql::connection
	cn.Open("::name::MyNamedDatabaseConnection")

	dim strSP as c
        dim strID2delete as c

        strID2delete = e.dataSubmitted.buttonList1      

' NOTE: the right side of strID2delete  will be different for you
' because you have to get your row ID data some other way from the e.dataSubmitted object
' use FireBug in Firefox to inspect the  e.dataSubmitted  that is passed from the browser to the server
' when you click your delete Button 
' (see Selwyns videos on using Firebug, there are several examples in his v12 UX videos)

' I was just using a bound buttonList control to get the ID variable to pass to the Stored Procedure, 
' in my particular example


' create our string which is the Stored Procedure we want to execute on the server, 
' followed by ID2delete parameter

	strSP = "spDeleteRecordFromXYZtable '" + strID2delete + "'"

' or maybe just

	strSP = "spDeleteRecordFromXYZtable " + strID2delete


' then run your stored procedure on the server, 

	cn.Execute(strSP)

' now you have to make sure you have written a 
' Stored Procedure in the SQLServer (or MySQL) back end database
' that will delete a row from your table when the ID is passed in as a parameter


' and if your stored procedure outputs anything back, then add this bit:

	rs=cn.ResultSet

	dim strAnswer as c
	strAnswer=rs.ToString()

' do whatever you want with strAnswer, display to user in a DIV, or whatever...
' see below in next section of code

' create a character variable e.g. named jsToRunIntheBrowser  which is used to 
' output a javascript string created in this function 
' and sends it back to the browser to be run as the output from this Ajax callback function


        dim jsToRunIntheBrowser as c


'write all your javascript code that refreshes your UX, and add it to this string variable

        jsToRunIntheBrowser = "{dialog.object}.whatever;"
        jsToRunIntheBrowser = jsToRunIntheBrowser + "{dialog.object}.somemorestuff;"
        jsToRunIntheBrowser = jsToRunIntheBrowser + "etc..."


' Return Javascript code to be run in the client, whatever is in the string variable

        serverside_25e008027bbc4499a84542214401afb2 = jsToRunIntheBrowser


end function

[mixter]

Re: Delete from list control using button

If you don't want to write a stored procedure that is run via server side xbasic ajax callback,

then an easier way might be deleting your record as shown in this video:

http://www.viddler.com/v/c6e39bf7