Table field limits

[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?

[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

[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.

[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.

[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.

[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.