A Update Datatable that is based on a View

A Update Datatable that is based on a View

greggreggreggreggreggreg Posts: 42Questions: 19Answers: 2

I have a Datatable thats working nice, but I needed some extra data from the DB, that was easier to get in a MySQL View. SO I have created the view and updated my Datatable to use the View.

But I am not sure how to then link the Update/New/Delete buttons to the original data. The way I am seeing it is in a Update, when clicking a row, the modal comes up blank.

Are you able to point me at a example?

thanks

This question has an accepted answers - jump to answer

Answers

  • greggreggreggreggreggreg Posts: 42Questions: 19Answers: 2
    Answer ✓

    ignore this. Fixed it. I had to label my fields in the editor the same as the fields on the viewer.

  • allanallan Posts: 63,498Questions: 1Answers: 10,471 Site admin

    Thanks for posting back - good you hear you've got it sorted.

    Allan

This discussion has been closed.