AppGini Community Forums

Suppose i have two tables A and B.

Can I create a View which shows some rows of A and some from B (based on the query , i will write query ). No need of editing,adding, or deleting.

In short can we create something like a report.

Yes. There is a way. It's a little trick.

1. Create a dummy table in AppGini With matching field types and names to what will come from table A and B.
2. Upload your app and let AppGini create this table for you on your db.
3. Enter and delete some record in this table to verify your frontend PHP is all ok.
4. Now drop that table from your db using phpMYAdmin.
5. Using phpMYAdmin create a view on your db with the same name as the table you created in step 1 and 2. This table must have matching field names and types. The view will have the SQL to bring data from tables A and B.
6. Run your application to observe your AppGini PHP can still talk to the view created in step 5.

Nice trick, Kerem ... thanks for sharing it. I plan to add support for views in future releases.

Great! Support for views would help with many needs. Thanks for considering this.

Thank You Kerem. This would be very helpful to me.

Sorry to bump an old thread, but a hearty YES to views. Especially if they include calculated columns.

this trick works for mass deletion as well? when u delet stuff from table A does it get removed from the view?