OnPush copy then delete a record.

[Bruce Isaacson]

Need help or a better idea.

I would like to copy a record that I have open in a form to another table and then delete it.

I have tried the following:

OnPush
Run a saved operation current record.

I had made an operation to copy records from one table to another. It works when I test it under the operations tab. When I employ it from the form I get the following:

Scruot: OnPush line:16
Copy.run(operation_name,query.filter,query.order)
Object does not support requested interface.


I would appreciate a work around for this.

Thanks in advance

Bruce

[Stan Mathews]

RE: OnPush copy then delete a record.

The only thing that makes sense to me is that you might have renamed/redone the saved operation since the time you created the button?

The button push would then be trying to run an operation that no longer existed/had a different name.

Another possibility would be that you specified filtering on some field or variable that is not available when you push the button.

Go to the form in design mode, right click on the button, choose the onpush event, select the action script the runs the operation, right click and select "view xbasic". You should see something that resembles

query.filter = ""
query.order = ""

DIM operation_name as c
operation_name = "some operation name here"
If operation_name "" then
copy.run(operation_name,query.filter)
End if

See if everything looks ok there.

[Stan Mathews]

RE: OnPush copy then delete a record.

There is also a fairly new xbasic command tbl.move_record_to()


used thusly it moves the current record to a named table

dim tbl_source as P
tbl_source = table.current()
on error goto failed_to_copy
result = tbl_source.move_record_to("yourdestinationtable")
on error goto 0
if result then
ui_msg_box("Result","Record was moved")
end if
end

failed_to_copy:

ui_msg_box("Record not moved.",error_text_get(error_code_get()))

end

Substitute your target table for yourdestinationtable

[Bruce Isaacson]

RE: OnPush copy then delete a record.

Stan,

Awesome fix the last one worked great. Sure do appreciate the great response. I am glad that there is help out there like you.

Thanks
Bruce

[Tom Cone Jr]

RE: OnPush copy then delete a record.

Bruce,

This thread illustrates something you might want to keep in mind as you continue learning about Alpha Five.

Operations, as a general rule, are intended to be run against entire tables. Multiple records are typically involved.

When your design needs to manipulate a single record look for other alternatives.

There's no reason to use a sledgehammer when a much smaller implement will suffice. In a multi-user networked environment using the smaller tool will pay big dividends when performance is an issue, too.

-- tom