Gossamer Forum
Home : Products : DBMan : Discussions :

Re: Number of Fields

Quote Reply
Re: Number of Fields In reply to
Since nothing is "remembered" from one running of the script to the next, nothing can be kept in memory.

There are three ways you could break up the forms into several pages.

1--On the second and following pages, have hidden fields which contain the values from all previous pages.

2--Create intermediate files as you go along. That is, as each page is filled out, save a temporary file with the information from that page and then when the last page is filled out, pull the data from the temporary files and add all the information at once to the database.

3--Create a separate, linked database for each page of information.

Actually, the second one sounds like it probably would be the best choice.

However, the problem comes in with the size of the database. Remember that performance in the non-SQL DBMan begins to degrade after the .db file reaches 1M in size. If you have hundreds of fields, it wouldn't take very many records to make a 1M file.

JPD
http://www.jpdeni.com/dbman/
Subject Author Views Date
Thread Number of Fields jai 4597 Jun 17, 2000, 8:33 AM
Post Re: Number of Fields
LoisC 4497 Jun 17, 2000, 11:39 AM
Thread Re: Number of Fields
JPDeni 4510 Jun 17, 2000, 1:50 PM
Thread Re: Number of Fields
jai 4486 Jun 17, 2000, 4:37 PM
Thread Re: Number of Fields
JPDeni 4480 Jun 18, 2000, 12:39 AM
Thread Re: Number of Fields
jai 4501 Jun 19, 2000, 1:48 AM
Thread Re: Number of Fields
JPDeni 4469 Jun 19, 2000, 10:28 AM
Thread Re: Number of Fields
jai 4476 Jun 19, 2000, 4:07 PM
Post Re: Number of Fields
AstroBoy 4475 Jun 19, 2000, 5:02 PM