AppGini Community Forums

Hi,
Is there a simple way to create a view within Appgini?
Wat I do now is:
- within Mysql I create a view
- save the MySql code in notepad
- delete the view

Now I have to make that view known in the application.
- create in the application a new table —-> becomes a physic table in Mysql database with the wanted View name
- generate a project.
All the wanted “view” files where created

After login to the the project in a browser you see the table, where I like to see and use the view.
- So I delete the table in Mysql and create the wanted view with the right name. ( view name = generated table name)

When I try to execute the view nothing happens, in the Admin area I see MySql defenition Errors.
I try to have it fixed, no result.

So… I have view, within the project show as a table but I cann’t use this because off unfixable errors.

There must be a much easyer way to handle views.
Ron

Hi Ron,

have a look here : https://forums.appgini.com/phpbb/viewtopic.php?t=3405

Hi pbottcher,

And again, you helped me out, thank you!

Beneath I state what I did, maybe useful for others, so one don't have to go years back.
(by the way: a search action within the forum(s) sucks, it gives: to busy )

My steps:
Create a table of which you want a view of within AppGini
Save project and generate

Go to MySql environment
Create the desired view, with a different name than the table name (table- and view names should be unique) After this a view has been created however with a not desired name
Stay in MySql environment
Delete the, by AppGini, generated table of which you like to have the view of Change the name of the view to the former table name, you still are in the Mysql environment
The most simple way of doing this is:
(still within MySql) After this you should be able to work with the view
Don't forget to the delete the not wanted view!

Goodluck
Ron