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 <[email protected] <javascript:>> > 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 [email protected] <javascript:> >> To unsubscribe, send email to [email protected] <javascript:> >> 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] <javascript:>. >> 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 [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]. For more options, visit https://groups.google.com/d/optout.
