search

SQLiteFlow / SQLiteFlow-Issues

SQLiteFlow Support
9 stars 1 forks source link

View #196

Closed TheHartz closed 2 years ago

TheHartz commented 2 years ago

I seem not to bee able to create or save a view

SQLiteFlow commented 2 years ago

Could you add more details about what's your steps? What you actually see? And what you expect to see?

TheHartz commented 2 years ago

I use the following code and the expect to se VW_hoevaak in de views (expand) column The views column is and stays empty

drop view if exists VW_hoevaak; CREATE VIEW VW_hoevaak AS SELECT Lokatie.[Lokatie Naam] AS [Naam],
Lokatie.[Lokatie Plaats] AS [Plaats], Lokatie.[Lokatie Land] AS [Land], Count(Evenementen.[ID Evenement]) AS Aantal FROM Lokatie INNER JOIN Evenementen ON Lokatie.[ID Lokatie] = Evenementen.[ID Lokatie] GROUP BY Lokatie.[Lokatie Naam], Lokatie.[Lokatie Naam] HAVING (((Lokatie.[Lokatie Naam])<>"Onbekend")) ORDER BY Count(Evenementen.[ID Evenement]) DESC

SQLiteFlow commented 2 years ago

Does right click on the database name, then click "Refresh" work?

Screenshot:

a
TheHartz commented 2 years ago

How simple life can be. Sorry and Thanks

SQLiteFlow commented 2 years ago

That's absolutely true, and you're welcome.