Delete Record Button - Error Message

[bavism]

I have created a dialog that I am using to edit records in a grid. I successfully added a submit button to the dialog that will save the record. I tried adding a delete button but when I click on the delete button, I recieve a message that says " Error - You have not loaded primary keys for the Dialog. Therefore, you cannot delete this record"

The delete button event is {dialog.object}.deleteRecord();

Any help would be appreciated.

Matt

[bavism]

Re: Delete Record Button - Error Message

Any ideas? My key fields are on the form. Is it not possible to delete a record from a dialog?

Matt

[agillbb]

Re: Delete Record Button - Error Message

Check your dialog's datasource definition and make sure that you have defined the primary key(s).

[bavism]

Re: Delete Record Button - Error Message

Check your dialog's datasource definition and make sure that you have defined the primary key(s).

It is showing the correct column as a key. I am new to Alpha so to make sure I am checking this correctly, I went to Data Binding and chose "Specify Primary Keys and Sequences". In Table Properties the primary key field(s) is set to the correct column.

[PaulAmmoun]

Re: Delete Record Button - Error Message

Hi,
Did you find what was the problem?
I am having the same issue when trying to navigate a record (Next or previous).

Thanks

[ibliving]

Re: Delete Record Button - Error Message

I wasn't really looking for this but I think this might hold the answer to your problem.

http://http://msgboard.alphasoftware...ht=primary+key

[PaulAmmoun]

Re: Delete Record Button - Error Message

Thank you very much. This is exactly the solution.

Paul

[mvaughn]

Re: Delete Record Button - Error Message

I have exactly the same problem. Grid with row expander (Dialog2) used to update/delete record. Update works, but delete button says: " Error - You have not loaded primary keys for the Dialog. Therefore, you cannot delete this record".
I would like to add that in my onDialogInitialize event, I do not have the action script option for loading keys from parent table... only populate

[PaulAmmoun]

Re: Delete Record Button - Error Message

Add this in the on dialog initialize
ExecuteServerSideAction("Get Primary Keys for Parent Table::Load_Primary_keys_for_Parent_Table")
You should have it in the action script search for it...

[mvaughn]

Re: Delete Record Button - Error Message

That command is missing from my action script choices... see image below. What am I supposed to do now?
When I paste the above command anyway and try to edit it, I get Action Not Found.
actionscripts.gif

[-Jinx-]

Re: Delete Record Button - Error Message

I had nothing but problems with this as well. I added the action scripting, I rearanged the action scripting, I updated my table scheme in the bindings and so on. In the end I just wrote a deleteRecord xbasic function in my dialog. WAY easier than trying to get this built in fuction to work.

I'm actually deleting from multiple bound tables. Here's version 1.0 of my code if it helps:

function deleteCurrentRecord as c (e as p)
	dim recid as n
	recid = e.dataSubmitted.UNIQUE_ID
	'debug(1)	
	dim vjsdel as c
	dim con as SQL::Connection
		if con.open("::Name::MVWKS")	then
			dim sqlDeleteCmd as c = "DELETE FROM machlayoutdetail WHERE layoutmaster_id = :recid"
			dim args as SQL::Arguments
			args.add("recid",recid)
				'Delete Detail Record
				con.Execute(sqlDeleteCmd,args)
				vjsdel = js_escape(con.callResult.text) + js_escape(con.CallResult.RowsAffected) + ": Rows Deleted From Detail\n"
					sqlDeleteCmd = "DELETE FROM machlayoutsubprograms WHERE layoutmaster_id = :recid"
					'Delete Sub Programs Record
					con.Execute(sqlDeleteCmd,args)
					vjsdel = vjsdel + js_escape(con.callResult.text) + js_escape(con.CallResult.RowsAffected) + " : Rows Deleted From Subs\n"
						sqlDeleteCmd = "DELETE FROM machlayoutmaster WHERE unique_id = :recid"
						'Delete Master Record
						con.Execute(sqlDeleteCmd,args)
						vjsdel = vjsdel + js_escape(con.callResult.text) + js_escape(con.CallResult.RowsAffected) + ": Rows Deleted From Master\n"
		else
			vjsdel = "alert('Connection Error: Error returned was: " + js_escape(con.CallResult.text) + "');"
		end if
	vjsdel = 	"{Dialog.Object}.newRecord();setTimeout(function(){alert('"+vjsdel+"')},500);"
	'debug(2)		
deleteCurrentRecord = vjsdel
end function

If you've only got one table to worry about you can get rid of half of the above.

[Progytech]

Re: Delete Record Button - Error Message

Hi AH,
One question, what parameter are passing to this function when you are calling it? deleteCurrentRecord(xxxx?)

[-Jinx-]

Re: Delete Record Button - Error Message

I'm not passing any parameters into the function during the onclick event for the ajax callback. I am getting the unique_id of the record from the e.dataSubmitted object during the actual function itself.

recid = e.dataSubmitted.UNIQUE_ID

That's how it knows which record to delete (the current one) and all of my tables have the unique id from the header in them.

To tell you the truth I don't really know what (e as p) means. I just followed an example for making a function and coded it to my use.

Maybe it sets the type of the "e" object? I'd like to know for future reference.

[Progytech]

Re: Delete Record Button - Error Message

Hi Jinx,
Thanks for the clarification, so this is handle by the A5 callback. The (e as P) is a Pointer variable that can have many properties each with its own value like this:

dim colors as p
colors.Blue = 1
colors.White =2
colors.Red = 3

[agillbb]

Re: Delete Record Button - Error Message

I don't use the built-in delete function either. Before this function was even available I coded my own generic xBasic function that took parameters like:
- tablename (e.g. "Customers")
- whereclause (e.g. "CustomerID = 234")
- returntype (e.g. "ALERT" which tells the function what javascript should be used to indicate success or failure)

You get the idea....