Yes, @record should work very well as it is generic. On Mon, Aug 27, 2018 at 10:38 AM joyce <young.joyc...@gmail.com> wrote:
> Yes, I can add dictionary records, and thanks for the reply! The system > that I've inherited isn't flush with dictionary definitions. I'm adding > them as I can, but sometimes need to perform queries on the fly and don't > have time to add the definitions. > > I did get another reply from someone suggesting I try the syntax below, > and it works great! Just what I needed! > Instead of PRICE<1,1,1> use @record<field,value,subvalue> > > > > On Monday, August 27, 2018 at 8:38:17 AM UTC-4, Dick Thiot wrote: >> >> From what you wrote I think that you mean column rather than row. If you >> are an admin you can define columns by updating the dictionary with the >> column definition. Definitions like *A5 are default definitions and now >> found on all systems. Also, generic definitions may not take into account >> conversions for dates, money or other "formatted" data. >> >> The dictionary record to define your column is pretty simple. Do you >> have access to the system to edit your dictionary? >> >> Dick Thiot >> >> On Thu, Aug 23, 2018 at 10:30 AM joyce <young....@gmail.com> wrote: >> >>> All, >>> >>> I have the working query statement below that allows me to view a single >>> value from a multivalue row. But most of our rows don't have dictionary >>> definitions. Is it possible to use this query statement on a row that's not >>> defined? For example, instead of PRICE, using *A5? I can’t seem to make it >>> work, and am hoping I just don’t have the syntax correct. Thank you! >>> >>> >>> LIST FBNK.SECURITY.TRANS EVAL 'PRICE<1,1,1>' >>> >>> -- >>> -- >>> IMPORTANT: T24/Globus posts are no longer accepted on this forum. >>> >>> To post, send email to jb...@googlegroups.com >>> To unsubscribe, send email to jbase-un...@googlegroups.com >>> 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 jbase+un...@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- > -- > IMPORTANT: T24/Globus posts are no longer accepted on this forum. > > To post, send email to jBASE@googlegroups.com > To unsubscribe, send email to jbase-unsubscr...@googlegroups.com > 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 jbase+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com 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 jbase+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
