With Fast Form I was trying to create a Browse Form. In Table Name I selected a database view. After clicking "Build Fast Form" a message popped up with the text "A Form has been created".
The form is nowhere to be found, also not in the table zzzzsys_form.
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Fast Form / view
Re: Fast Form / view
Timo,
You can't use a VIEW to create a Fast Form - because it doesn't have a Primary Key.
But you can manually create a Form and Run Button that will use a VIEW.
Steven
You can't use a VIEW to create a Fast Form - because it doesn't have a Primary Key.
But you can manually create a Form and Run Button that will use a VIEW.
Steven
-
- Posts: 785
- Joined: Sun Oct 14, 2018 11:25 am
Re: Fast Form / view
Generally speaking,
1) Fast Form fails to create a form if there's no primary key. This applies to both views and tables.
2) And it also fails to create a form if you enter the primary key as field name. This only applies if the table does not yet exist and should be created by Fast Form.
In both cases, there's a success message after clicking "Build Fast Form".
This makes the user believe that the form was successfully created but in reality it is nowhere to be found.
1) Fast Form fails to create a form if there's no primary key. This applies to both views and tables.
2) And it also fails to create a form if you enter the primary key as field name. This only applies if the table does not yet exist and should be created by Fast Form.
In both cases, there's a success message after clicking "Build Fast Form".
This makes the user believe that the form was successfully created but in reality it is nowhere to be found.
-
- Posts: 4
- Joined: Mon Jul 15, 2024 4:07 pm
Re: Fast Form / view
Hi,
I am a newbie.
I have the same problem to use a "View" and browse it in a form or fast form of nubuilder 4.5.
I have just understood the question that there isn't Primary Key, but I don't undestand how I resolve.
I created a new form with Fast Form, but how do I populated it with the data of sql view table?
Thank you
Roberto
I am a newbie.
I have the same problem to use a "View" and browse it in a form or fast form of nubuilder 4.5.
I have just understood the question that there isn't Primary Key, but I don't undestand how I resolve.
I created a new form with Fast Form, but how do I populated it with the data of sql view table?
Thank you
Roberto
-
- Posts: 4
- Joined: Mon Jul 15, 2024 4:07 pm
Re: Fast Form / view
Hi,
I resolved by myself with a trick: I created from my View a new Table and add it a Primary Key. After, the Fast Forms ... as usual
I resolved by myself with a trick: I created from my View a new Table and add it a Primary Key. After, the Fast Forms ... as usual