Forums

Hi,
I have a table with data from DB.
How can I delete rows from table and DB?

In "Views" => "Table" => "Columns list" I insert this:
_DELETE_:Delete

Now I have column "Delete" in table but it's empty.
What have I done wrong?

Thank you in advance for your response.

Hello Twickbot,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How to load one row from a DB table into your form
P.S: I'm just an automated service😉

All rows in table already is loaded from DB.

Hi Twickbot,

You need to setup a delete event for this and add a delete button view and point it to that event.

Let me know if you can not get it done and I will try to prepare a tutorial.

Best regards,
Max

I setup delete event.
Add a delete button view and point it to that event.

Work fine but this button delete ALL rows in table (by condition).

How can I select and delete ONE row only?

Hi Twickbot,

You need to configure the "Delete conditions" in the delete function, the button link must contain a parameter to identify the record and then you can use this parameter in the delete conditions box, please let me know if you can not get it done and I will prepare a tutorial.

Best regards,
Max

>>...the button link must contain a parameter to identify the record...

Yes I understant.
But what kind of parameter should this be?

And how can I insert column in table:
- checkbox in every row with a parameter to identify the record
or
- link (or button) "Delete" in every row with this parameter

How can I do it?

Thank you very much for your help.
Works great now.

Hi Twickbot,
Did you read the Connectivity 6 tutorial available in the FAQs section ?

I read, but did not understand that paragraphs 5 and 6 are relevant to my case.

Hi Twickbot,

I'm preparing a full manual and hopefully it will be ready by the end of the month.

Best regards,
Max