ycollier Posted December 21, 2009 Report Share Posted December 21, 2009 It is now possible to update the data of one Table in a view. Is it possible to delete the data of one Table in a view? Thanks Anthonyjulk 1 Quote Link to comment Share on other sites More sharing options...
0 shengnandou Posted December 23, 2009 Report Share Posted December 23, 2009 Hi ycollier, We do not offer options for our clients to directly delete the data of a table from a view for safety consideration. For you to delete records in a Search and Report DataPage based on view, you need to create a simulated delete link in the results page so when a user clicks on the link, another Search and Report DataPage (this one will be based on the real table) will be displayed with the record being enabled to be deleted. This requires additional DataPage and passing parameters. Here I attached a document including the procedures to do so. Hope it helps. Regards, Shengnan Quote Link to comment Share on other sites More sharing options...
0 bahar_vm Posted January 13, 2010 Report Share Posted January 13, 2010 Hi, Caspio has released a new feature which enables one Table in the View to be editable. So if you enable this feature in the View wizard, you will be able to delete records using a DataPage which is linked to this view. I hope this helps. Best, Bahar M. Quote Link to comment Share on other sites More sharing options...
0 jlwilliford Posted November 8, 2010 Report Share Posted November 8, 2010 I have a view that joins attendance records with person records, so I can see the person's name, etc., in my attendance report. Even though I've marked the Attendance table as "editable" in the view, it does not allow me to select "Delete". So I can edit, but I can't delete through the search-and-report. I think you have to use an additional datapage just to do the delete. The "How To" website provides a page explaining how to do this. Quote Link to comment Share on other sites More sharing options...
0 bahar_vm Posted November 8, 2010 Report Share Posted November 8, 2010 Hi, Sorry for confusion, let me correct my statement, the current behavior of the system is to not allow delete in a View which includes more that one table. So if the View only includes one table for filtering purpose, the delete option is available. If the View joins tables then for data integrity purpose the system does not allow delete option in the report. I will update this post if we enable the delete feature for a multi-table View. Best, Bahar M. Quote Link to comment Share on other sites More sharing options...
0 bahar_vm Posted November 8, 2010 Report Share Posted November 8, 2010 And yes, currently you need to create one more DataPage which is based on the table to delete the records. Best, Bahar M. Quote Link to comment Share on other sites More sharing options...
0 DAG4Debt Posted December 16, 2013 Report Share Posted December 16, 2013 Do you have the documentation for this. I can't find it on the Caspio site and need to create a datapage to delete a field in a table based on a view Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted December 18, 2013 Report Share Posted December 18, 2013 Create a delete link to the page on your report page by adding a HTML Block and pass the unique value of the record through the link in this format: <a href="Link to the next page&ID=[@field:UNIQUEFIELDNAME]"> Delete </a> and then create a predefined details page which is filtered by this unique field and is receiving the value in this format [@ID]. Get the link to this page and replace it with "Link to the next page" make sure to enable parameters for both pages and select "[@field:UNIQUEFIELDNAME]" in the code above from the picker on the bottom right corner of HTML Block In the details page to see the delete button you need to enable this option in Details Page Options screen Quote Link to comment Share on other sites More sharing options...
Question
ycollier
It is now possible to update the data of one Table in a view.
Is it possible to delete the data of one Table in a view?
Thanks
Link to comment
Share on other sites
7 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.