Hi All,
What is field type is better to use for save the collection variables type?
Thanks
Ferdinando
Il 13/07/2021 15:31, Randy Kaempen ha scritto:
Ferdinando,
On Jul 13, 2021, at 5:04 AM, stardata.info <http://stardata.info> via
4D_Tech <[email protected] <mailto:[email protected]>> wrote:
I need to save some information of several type in one record.
For example for one test i need to save more than one result.
These results are variables, 20/30/40 results for every test.
So for one test, I need to save a variable number of rows.
For every row, I have more than one information (code, value, times
and other )
Use the object field is a correct solution?
Or is better to use a text field with field separators and row
delimiters?
The traditional way was to have a related file for the multiple
records, related to the primary record. This multiple file would have
field for the code, value, times, and other fields. There could be an
automatic relation between this file and the primary file to load them.
If you really need the data in one record for some reason, then an
object is the best way to handle it. You can make arrays and store
them in the object.
If related records work, that offers you more options as far as
querying the multiple records in order to retrieve the primary record.
It all depends on your implementation.
Randy Kaempen
Intellex Corporation
**********************************************************************
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
