Command button (DeleteRecord) for a grid deletes other datasource record

(0) Share

Report

Posted on by Abhinay Tharwal

1,244

Hi,

I have a command button (of command DeleteRecord) in a form's button group control. The datasource selected on that button group, and all it's parent form controls is PurchReqLine.

I also have PurchReqTable as one of the datasources.

The JoinSource on the PurchReqLine datasource is PurchReqTable (LinkType: InnerJoin).

Whenever I select a record in the PurchReqLine and hit the Remove button, it deleted record from PurchReqTable.

Is there anything wrong?

Regards,

Abhinay

I have the same question (0)

All responses (11)

Answers (1)

Sort by

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

Does it delete ONLY the PurchReqTable? Or also PurchReqLine?

Also please double check that all the parent controls of the CommandButton are really pointing to PurchReqLine.

If you still have the issue, perhaps you could share some screenshots of your form design, and this button.

Was this reply helpful? Yes No
Abhinay Tharwal 1,244 on at

Like (0)

Report
Copy link

Link copied!

Hi Nikolaos,

Thank you for your reply!

The PurchReqTable has the delete action which deletes the relevant records from the PurchReqLine table.

I put a break-point on the delete() method of both the datasources, the PurchReqTable's DS gets executed first.

Best regards,

Abhinay

Was this reply helpful? Yes No
Sukrut Parab 71,741 Moderator on at

Like (0)

Report
Copy link

Link copied!

You must have highlighted header receive record and hit remove that's why header got removed and the addosiated lines. If that is not the case , please check if you have modification which is causing this.

Was this reply helpful? Yes No
Abhinay Tharwal 1,244 on at

Like (0)

Report
Copy link

Link copied!

Hi Sukrut,

Thank you for your reply.

The expected behavior is that, the datasource specified on the button group should be referred to for the actions of a command button.

A form grid will always have a record in selection.

The record selected in the PurchReqTable should not matter when the datasource specified on the button group is PurchReqLine.

Regards,

Abhinay

Was this reply helpful? Yes No
nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Abhinay,

if you still have the issue, could you provide the information that I requested previously?

Was this reply helpful? Yes No
Abhinay Tharwal 1,244 on at

Like (0)

Report
Copy link

Link copied!

Hi Nikolaos,

Sorry, I cannot share any screenshots here because of the non disclosure clauses. But please take my word that the datasources selected are correct.

The behavior changes when I remove the JoinSource of PurchReqLine, and only the expected records get deleted.

That means the datasources selected are correct.

Regards,

Abhinay

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

If I'm looking at some standard header-lines forms such as SalesTable, the Link Type of the line data source is "Delayed", not "InnerJoin".

Does it work if you change the link type to Delayed?

Was this reply helpful? Yes No
Abhinay Tharwal 1,244 on at

Like (0)

Report
Copy link

Link copied!

Hi Nikolaos,

I will try that and update you.

Regards,

Abhinay

Was this reply helpful? Yes No
Abhinay Tharwal 1,244 on at

Like (0)

Report
Copy link

Link copied!

Hi Nikolaos,

The JoinSource property should be set to 'Delayed' to avoid this situation.

I would have to figure out another way to achieve this, as I need the JoinSource to InnerJoin.

Thanks!

Regards,

Abhinay

Was this reply helpful? Yes No
nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi, why do you need it to be InnerJoin?

Was this reply helpful? Yes No