ActionJavaScript Delete

[johnfletchertt]

I have a grid and I want to add an actionJavaScript button that will delete the row of data it's on. How do I do that? Checking the checkbox "Allow delete" in the Update Settings is breaking the grid for some reason and you get the error

     
Fatal error running a5_ajax_grid(): Property not found tmpl.preCalc.Javascript.GridRow_To_EditMode subelement not found. on line 1642 in 1000199:pl

How do I add an action javascript button to delete the row of data in the grid?

[johnfletchertt]

Re: ActionJavaScript Delete

Okay I added a button and have defined the following onClick event;

 var row = {grid.Object}.getSelectedRow();
{grid.Object}.deleteRow(row);

But I get an error message saying 'Grid does not allow deletes'. What do I do?

[-Jinx-]

Re: ActionJavaScript Delete

Is it a simple grid? Can you remake it? It sounds like there may be a glitch somewhere. Sometimes that happens and remaking the component fixes it, at least in regards to your first error.

If that's not the problem, then there must be something simple that's wrong. For instance, you can't allow CRUD operations on a grid unless you include the primary key in the query.

An example of what you've got would be helpful for someone to solve your problem. There are several types of grids and several ways you could set this up so it will take forever for anyone to figure out exactly what you've got going on.

[johnfletchertt]

Re: ActionJavaScript Delete

Primary key has been specified. This grid has a parent or displays when you click the small + sign on the Parent. Any idea at all on why that error would occur when I check the 'Allow delete' checkbox would be greatly appreciated. Give me all the reasons you can think of.

[-Jinx-]

Re: ActionJavaScript Delete

I don't know what would be causing the error. It sounds like a bug to me. If you can make a sample component and get it to reproduce the error (using northwind db or static data so it can be tested) you can upload that here for us to look at or send it in as a bug to alpha.

If you need it to work NOW, you could write Xbasic to delete it instead through an Ajax callback.

[GGandhi]

Re: ActionJavaScript Delete

http://screencast.com/t/zvJRhQyZBKia

are you doing this way? from the description it does appear to me.

[johnfletchertt]

Re: ActionJavaScript Delete

What's the Xbasic code?

[johnfletchertt]

Re: ActionJavaScript Delete

This solution is not very clear. I am using a grid and I previously attached an ActionJavaScript onClick definition that says;
var row = {grid.Object}.getSelectedRow();
{grid.Object}.deleteRow(row);

Where would I put the {controlDef.system:Delete}? I am using a grid so the only way to add something new is by clicking the 'Insert' link, choose button and then go define it. This solution is very vague and I guess assumes the user is an expert in Alpha. I am no expert.

[johnfletchertt]

Re: ActionJavaScript Delete

One thing I left out but I don't think it's critical. The table from which the grid is pulling info has a primary key and a foreign key. The binding section only asks for a primary key so I specified only one key and yes, it is an auto_increment.

[johnfletchertt]

Re: ActionJavaScript Delete

Okay I got things working. One last problem, how do I refresh the grid in Xbasic? Instead of using Action JavaScript, I defined the onClick event as an Xbasic Function. The record in the table deletes fine but now you won't know it unless you click the 'Refresh' button. So from the Xbasic Function definition, how do I refresh the grid for the user?

[-Jinx-]

Re: ActionJavaScript Delete

What does your Xbasic look like?
At the end of your Xbasic function do something like this.

dim jscmd as c = "{grid.Object}.refresh();"
YourXbasicFunctionName = jscmd

That will pass some javascript back to the client. You can build any javascript you want this way and send it back.

Also, please share how you fixed your problem so that this post is useful to other users.

[johnfletchertt]

Re: ActionJavaScript Delete

Thanks much. Did not use it exactly as you have it here. The Xbasic Function option for an onClickEvent is called;

function serverside_b12cbbafda284b90b709994bed9b8c7a as c (e as p)

so I defined the return value like this, which is at the top of the function definition window;

serverside_b12cbbafda284b90b709994bed9b8c7a = "{grid.Object}.refresh();"

Once again thanks. If anyone is really interested in the xbasic code I used let me know and I'll post it here.

[-Jinx-]

Re: ActionJavaScript Delete

Ah, I see. You are using the Xbasic tab inside the button instead of an Ajax callback. I was envisioning a callback and the code being in the Xbasic functions on the left side of the builder.