Jump to content
Developer Wiki and Function Reference Links ×

Limits to Record Capacity


Sam Jones

Recommended Posts

I have a record with 8 fields.  3 of those fields I want to store strings of

23625 characters

23625 characters

31500 characters

I don't seem to be able to do that.  all fields after the 2nd of those 3 are emptied, and I think (not sure) that the 2nd field is short.  Are records limited to  a total capacity 32767 characters?

Link to comment

If that is the case, splitting up these 3 strings over 3 records could be an easy solution?

Since it's such a large string, I assume it contains a sort of delimiter key which is using a lot of space? Consider storing each substring in a separate field of each record?

 

http://developer.vectorworks.net/index.php/SDK:User_Data Is also a good option, I'm starting to use it a lot lately.

You can always create your custom VS implementation to keep working with Vectorscript.

Link to comment

Conceptually easy, but a pain to implement, and clutters things up a bit; although I imagine that I will end up hiding the records.  Also, when editing extra steps need to be determine which record to search based on limits to the criteria, e.g. I cannot look in the "Feeder Cable" record based on a value in the "Connector" field; I have to determine if the value of the Connector exceeds the value for the first record and look in the second record.  Not rocket science...

While not possible, it would be nice to just have one humungous string that could be accessed with the substring function.  

 

Link to comment

Sam,

Though I don't know your exact implementation, you can keep a separate record format that stores the assignments of your large block text field records. Think of it as a table of contents record. Or, you could place a short field at the beginning of your long field records to indicate what portion of the large text block is in that record; a table of contents field, as it were. There are many ways to organize your data. If one way is not appealing enough, devise another way that addresses its shortcomings and explore that path. You'll eventually find a way that allows you to save an unlimited amount of data behind the scenes and have quick access to it. 

 

Good luck,

Raymond

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...