PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Data Read logic in nomads DD or View definition  (Read 1727 times)

michaelgreer

  • Diamond Member
  • *****
  • Posts: 129
    • View Profile
Data Read logic in nomads DD or View definition
« on: July 09, 2018, 12:44:29 PM »
I don't really use nomads, but use the Data dictionary and views definitions to create ODBC links to PVX data.  Is there a way to create a column in a table or view that includes logic to set the value of the field based on other fields in the record, or data from another table.  Thanks!  Michael

Jane Raymond

  • Staff
  • Diamond Member
  • *****
  • Posts: 280
    • View Profile
    • PVX Plus Technologies
Re: Data Read logic in nomads DD or View definition
« Reply #1 on: July 10, 2018, 08:53:29 AM »
When you define a Data Source for a View, on the Elements tab you can add your own element and include a PxPlus expression in the Expression column to build the value you want.
Jane Raymond
Software Developer
PVX Plus Technologies Ltd.