bug: cannot build fast form based on a view

[Rolf]

I believe I've run into a bug. I created a view in MariaDB (basically, a table created on the fly based on data in the database) and then tried to build a fast form based on this view. nuBuilder informs me that FF3 was created but in fact, that's not true. FF3 does get created when I build a fast form based on a normal table.

Can you reproduce?

[Rolf]

A view doesn't necessarily have what would be the primary key in a normal table. Maybe that's the problem?

[marc]

This is not a bug, it's by design (or a limitation).
But it could be solved that way.
Create a (temporary) table form the view as explained here: https://stackoverflow.com/questions/924 ... x-in-mysql
Add a primary key.
Build the fast form based on the table.
Delete the table.
Replace the table with the view in the browse query

[Rolf]

Thanks, Marc. I will look into your suggestion.

I fail to see how that could not be a bug. If a view isn't meant to be used as the basis for a form, then nuBuilder should not autosuggest it and stick to normal tables only. The view is part of the autocomplete list of the table field of the form.

[admin]

.

[marc]

Thanks, Marc. I will look into your suggestion.

I fail to see how that could not be a bug. If a view isn't meant to be used as the basis for a form, then nuBuilder should not autosuggest it and stick to normal tables only. The view is part of the autocomplete list of the table field of the form.

I agree Rolf. I hope my suggestion worked for you.

[admin]

This has been fixed now - there are no views in the list now.

[Rolf]

The alternative to using a MySQL would be the SQL Builder from within nuBuilder itself, am I right?

[admin]

Rolf,

Forms can only be based on 1 table.


Steven