As stated Pick dictionaries are purely for producing formatted output. Think of dictionaries much like Excel and all the features you have to format your cells. You will often find multiple dictionaries pointing at the same data but having different formats (Dates in different formats, DD/MM DD/MM/YY, etc). Pick dictionaries can do much of what Excel formulas do. You can add fields together, do if statements, lookups (excel calls them vlookups). It is very powerful but internally the pick storage engine has no constraints as you would see in a SQL system. Pick data itself is just a large 3-dimensional array of what is essentially VarChar's. It is much closer in concept to Mongo/JSON than SQL.
I did a video at MultiValue | Powerful NoSQL Database (pickmultivalue.com) <https://www.pickmultivalue.com/> about the pick files system where I describe the basics of the Multi-Value structure and try to relate them to structures outside of Pick. On Wednesday, January 27, 2021 at 8:22:07 AM UTC-8 [email protected] wrote: > Perfect, thank you - that helps a lot! Thanks to you both for your help! > Joyce > > On Wednesday, January 27, 2021 at 10:19:15 AM UTC-5 DanE wrote: > >> There are actually 3 fields pertaining to length in your dictionary >> example >> >> 0001 A >> 0002 01 >> 0003 DESC >> 0004 >> 0005 >> 0006 >> >> 0007 T1,35 <-- this is a >> conversion which tells the report to limit the length to 35 characters or >> more precisely to show characters 1 through 35 >> 0008 >> 0009 L <-- this >> justification says to left justify the field. This could be R for right or >> T for Text which is like L for left except it word wraps at word rather >> than just length >> 0010 35 <-- this is the >> length associated with where it wraps. NOT how much shows, that is >> determined in this DICT by field 7 >> >> So, for example if you wanted it to wrap at 20 characters here would be >> field 7, 9 and 10 >> >> 0007 >> 0009 L >> 0010 20 >> >> If you wanted it to word wrap at 20 they would be >> >> 0007 >> 0009 T >> 0010 20 >> >> And if you wanted it to only show the first 20 >> >> 0007 T1,20 >> 0009 L >> 0010 20 >> >> >> >> >> Dan Ell | jBASE Technical Engineer >> jBASE International, Inc. >> *813-498-2544* <813-498-2544> | 866‑582‑8447 <(866)%20582-8447> >> *[email protected]* | www.jbase.com >> 1050 Calle Amanecer, Suite A | San Clemente, CA 92673 >> >> *From:* [email protected] <[email protected]> *On Behalf Of *Joyce >> White >> >> *Sent:* Wednesday, January 27, 2021 9:59 AM >> *To:* jBASE <[email protected]> >> >> *Subject:* Re: Need Help Understanding jBASE Field Length >> >> >> >> Follow-up - still trying to understand the value of even having a >> dictionary length. Let's say I create a report and make a synonym for a >> field. My synonym is named "ReportDescrip" and has a length specified in >> the dictionary as 20. So if I call the synonym from my report, will it then >> limit the value it returns to the specified dictionary length? >> >> Joyce >> >> On Wednesday, January 27, 2021 at 9:36:55 AM UTC-5 [email protected] >> wrote: >> >> Joyce, >> >> Multi-value fundamentals … >> >> >> >> There is no relationship between the dictionary and the data in terms of >> actual field length. >> >> >> >> The length set in the dictionary was determined by the original >> implementor based on suitability for display/print purposes. >> >> >> >> You will often find that there are several synonym items for the same >> field with different lengths depending on the requirements for a certain >> report. >> >> >> >> Mike >> >> >> >> *From:* [email protected] <[email protected]> *On Behalf Of *Joyce >> White >> *Sent:* 27 January 2021 14:27 >> *To:* jBASE <[email protected]> >> *Subject:* Need Help Understanding jBASE Field Length >> >> >> >> I have a customer asking me about a jBASE field length. My dictionary >> looks like below, so I thought the length was 35. But I can go into records >> and type values with lengths much longer than 35 into field 1. In fact, >> there doesn't seem to BE a limit. What gives? >> >> Thanks, >> >> Joyce >> >> READ ONLY File RM]D , Record '1' >> >> Command-> >> >> 0001 A >> >> 0002 01 >> >> 0003 DESC >> >> 0004 >> >> 0005 >> >> 0006 >> >> 0007 T1,35 >> >> 0008 >> >> 0009 L >> >> 0010 35 >> >> -- >> -- >> IMPORTANT: T24/Globus posts are no longer accepted on this forum. >> >> To post, send email to [email protected] >> To unsubscribe, send email to [email protected] >> For more options, visit this group at >> http://groups.google.com/group/jBASE?hl=en >> <https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgroups.google.com%2Fgroup%2FjBASE%3Fhl%3Den&data=04%7C01%7Cdane%40jbase.com%7C8f243ff4d4cd4ed24d2308d8c2d41a6f%7Cbfd62fcabd384e07a0785e9943d1f9c0%7C0%7C0%7C637473563528705275%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=uyv72aT6poZSckMBsF18DEAthXQJ9tYTzGtwBtdK%2BvU%3D&reserved=0> >> >> --- >> You received this message because you are subscribed to the Google Groups >> "jBASE" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jbase/190bed23-e5a7-46f7-911e-03239265e537n%40googlegroups.com >> >> <https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Fjbase%2F190bed23-e5a7-46f7-911e-03239265e537n%2540googlegroups.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=04%7C01%7Cdane%40jbase.com%7C8f243ff4d4cd4ed24d2308d8c2d41a6f%7Cbfd62fcabd384e07a0785e9943d1f9c0%7C0%7C0%7C637473563528715230%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=7RTatusZ0uHNuVzE%2BSEI8Z6IKOgq7jC8lCumByZ5VO4%3D&reserved=0> >> . >> >> -- >> -- >> IMPORTANT: T24/Globus posts are no longer accepted on this forum. >> >> To post, send email to [email protected] >> To unsubscribe, send email to [email protected] >> For more options, visit this group at >> http://groups.google.com/group/jBASE?hl=en >> <https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgroups.google.com%2Fgroup%2FjBASE%3Fhl%3Den&data=04%7C01%7Cdane%40jbase.com%7C8f243ff4d4cd4ed24d2308d8c2d41a6f%7Cbfd62fcabd384e07a0785e9943d1f9c0%7C0%7C0%7C637473563528725186%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=XfH5NKXoIz4fGf2le%2B0Vw5Xt%2B%2BdZ923%2FChu0IpGfuD8%3D&reserved=0> >> >> --- >> You received this message because you are subscribed to the Google Groups >> "jBASE" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jbase/fafd2869-d0ba-45f6-b838-4753977bcee2n%40googlegroups.com >> >> <https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Fjbase%2Ffafd2869-d0ba-45f6-b838-4753977bcee2n%2540googlegroups.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=04%7C01%7Cdane%40jbase.com%7C8f243ff4d4cd4ed24d2308d8c2d41a6f%7Cbfd62fcabd384e07a0785e9943d1f9c0%7C0%7C0%7C637473563528725186%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=rJ2TYbAP29GhbsYWLIANaluPthXhiWlwtb5fF9oks%2B0%3D&reserved=0> >> . >> > -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/ab515a60-9ed7-4236-af43-4b3b6c1cf4e4n%40googlegroups.com.
