Page 1 of 1
Table field limits
Posted: Tue Apr 16, 2013 6:15 pm
by user#606
I use a table field to store information. In my application, it was chosen to quickly save and recall the data in a neat structure, from a programmer's view, not a database view.
For example, to save:- (shown for the benefit of fellow Nubies)
Code: Select all
put field "Table 1" into url ("File:" & field "FilePath")
To recall:-
Code: Select all
put field "FilePath"into recalledfile
put "file:" & recalledfile into recalledfile
put url recalledfile into Field "TempTable1"
I started out with this use of a Table Field, as an experiment while developing the application, and have been surprised at how it copes with all the data it has been forced to hold.
My next stage in development might well break it and I need some advice on the limits of text a cell can hold and also, the limit of text in the whole table.
Does anyone know this or how the table works when holding text?
Re: Table field limits
Posted: Tue Apr 16, 2013 6:25 pm
by jmburnod
Hi user#606
Try this:
Code: Select all
put field "FilePath" into recalledfile
--put "file:" & recalledfile into recalledfile
put url("file:" & recalledfile) into Field "TempTable1"
Best regards
Jean-Marc
Re: Table field limits
Posted: Tue Apr 16, 2013 7:03 pm
by user#606
Hi Jean-Marc,
The code I showed works for me and is necessary for reasons not discussed.
I put my issue in context for other users, but the question is not the code but at the end.
The point was about the amount of text that can be held in a Table field.
Re: Table field limits
Posted: Tue Apr 16, 2013 7:05 pm
by jacque
A table field is just a regular field with some properties set. You could reproduce the same thing yourself using any generic field as long as you set all the properties correctly. That means that a table field has the same limits as any other field, which is effectively none. Fields can hold as much text as you have memory, up to a 4-gig limit.
I think you'll be fine.
Re: Table field limits
Posted: Tue Apr 16, 2013 7:50 pm
by user#606
Thanks Jacque, I feel better about progressing along this convenient path.
I must feel like most Newbies when trying a particular approach and not knowing if it is doomed to failure. Looks like I got it right for once.
Re: Table field limits
Posted: Tue Apr 16, 2013 10:31 pm
by jacque
Yup, you did. But note that the 4-gig limit is for the whole stack, so unless your app has only one field the limit will be less. Like, maybe, 3.5 gigs.
Frustration always comes with a new language, but I'd say you're doing pretty good.