nuBuilder Forum

Today I tried to modify data in a temporary table without succes. Maybe somebody can help me?
nuBuilder-Master downloaded 30-1-2021 from github
What I did:
1. I created a browseedit form with php in before_browse I created a new table + one record (just for testing). This (seems to) works fine. 2. I clicked on first record --> empty record opened in edit-form

I figured out what happened:
3. I added a nuDebug-line of the sql-query to my before-browse php
4. Deleted all debug-records
After opening form again I see 3 debug-records: first (oldest): SQL-syntax error:

'SELECt * FROM #TABLE_ID# WHERE id2 = '601951e106a343d'' --> #TABLE_ID# is not replaced with my temportarary browse table name + it runs before my 'before browse php'

second:

SQL error 'Table doesn't exist ': Select * From `___nu16019b9e97b815___` Where `id2` = '' --> new tablename is availabley but table doesn't exists + it runs before my 'before browse php'

third: debug of my sql-string in 'before browse php': 5. After clicking on the first record again two Debug-error-lines are created: They are nearly the same ase those who where made when I opened browse-form: Only difference is a new temp-table-name in the second one

Hi,

Temporary tables are just used to display data in a Browse Form and is deleted again after it has loaded.
What exactly are you trying to do?

I tried to modify data in a temporary table during a session because I should like to give my users a easy way to insert data for a html-field in the normal database
I expected that it should be possible to create a temporary table and use it during the whole login-session.

Background:
I have made a nubuilder-database for church-presentations of songs (this works fine!) and want to add the possibility of different kinds of html-based presention text-slides for themes, bible verses etc..
My users must have a easy way to fill in these slides in a form on the website of our church

The idea:
-user chose a slide-type
-I create a temporary table with al needed fields
-User fills records in a easy to edit nubuilder-form
-I combine the input with javascript/php in a html-field of a non-temporary table.
-After user log-off al temporary tables are removed --> no waste
-Same html-field could be used for different slide-types

Is it necessary to create this temporary table or will a persistent table do?
When logging out (or at regular intervals), this can be emptied again.

Can it be stored on the fly in an array and then unset when nolonger needed? - Large ones will consume huge memory though.

Thank you @Kevin and @apmuthu! I decided to create persistant tables and remove data weekly after the divine service