Author Topic: Data Module Relationships: SQL expression builder  (Read 458 times)

Offline Blessed2

  • Full Member
  • ***
  • Join Date: Sep 2006
  • Posts: 10
  • Forum Citizenship: +0/-0
Data Module Relationships: SQL expression builder
« on: 15 May 2020 10:24:53 am »
Within the relationship builder for Data Modules is there a way to edit the relationship expression using sql statements?  In the Relationship Editor for FM, the ability to edit and create your own SQL is available in the Expression builder at the bottom for users needing to create more complex relationship statements.

Offline bus_pass_man

  • Statesman
  • ******
  • Join Date: May 2008
  • Posts: 436
  • Forum Citizenship: +43/-0
Re: Data Module Relationships: SQL expression builder
« Reply #1 on: 15 May 2020 10:44:49 am »
If you upgrade to 11.1.4 or higher you can define relationship operators. 


There's no relationship expression functionality.

Offline Blessed2

  • Full Member
  • ***
  • Join Date: Sep 2006
  • Posts: 10
  • Forum Citizenship: +0/-0
Re: Data Module Relationships: SQL expression builder
« Reply #2 on: 15 May 2020 10:52:34 am »
Ok, thank you.
We are on 11.1.5.  Was looking for the same flexibility and control to manually model complex relationships within the Data Module as what is available within Framework Manager.  Maybe they will add the functionality in upcoming versions.