Sam Jones Posted December 30, 2016 Share Posted December 30, 2016 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? Quote Link to comment
Hippocode Posted December 31, 2016 Share Posted December 31, 2016 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. Quote Link to comment
Sam Jones Posted December 31, 2016 Author Share Posted December 31, 2016 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. Quote Link to comment
MullinRJ Posted January 2, 2017 Share Posted January 2, 2017 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 Quote Link to comment
Miguel Barrera Posted January 6, 2017 Share Posted January 6, 2017 You could also read/write to text files as we had to do some time ago. I use CSV files to read survey files, which may contain 10K+ lines of data, and CSV tables/spreadsheets. You now have the ability to also read/write to xml files, which have a more structured format. Quote Link to comment
Recommended Posts
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.