Page 1 of 1

Create view across multiple tables

Posted: 2016-06-08 14:36
by suesayram
Hi All,

In plain SQL I can create a view instead of a table:

Code: Select all

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_nameA, table_nameB
WHERE condition
In AppGini v 5,5, I only see a button to create table. How do I create a view?

Sue

Re: Create view across multiple tables

Posted: 2016-08-30 10:05
by grimblefritz
As you've probably learned, AppGini does not (yet) support views. It's been discussed and the author has indicated it's a potential for a future version, but there's no ETA for it.

Meanwhile, search the forum. Someone recently posted a workaround that allowed views to be used.