Plex 2E

  • Private Community

  • 1.  Is it possible to do a SQL JOIN to a CURSOR in CA2E ?

    Posted Jun 25, 2015 11:45 AM

    Is it possible to do a SQL JOIN to a CURSOR in CA2E, if so any examples or docs appreciated.



  • 2.  Re: Is it possible to do a SQL JOIN to a CURSOR in CA2E ?

    Posted Jun 29, 2015 03:11 PM

    Redirecting...Is anyone able to help out this user with their question?

     

    Thank you!



  • 3.  Re: Is it possible to do a SQL JOIN to a CURSOR in CA2E ?

    Posted Jun 29, 2015 07:30 PM

    I suspect from the lack of responses that this has not been attempted by anyone before. You are breaking new ground here... would be keen to see how you resolve the problem.



  • 4.  Re: Is it possible to do a SQL JOIN to a CURSOR in CA2E ?

    Posted Jul 06, 2015 06:00 PM

    Unless this is somehow 'magically' accomplished thru custom 2E pre-compiler process... 

     

    As far as I know, the only way to do SQL JOIN in 2E right now is thru SQL View (ex: virtual fields in file-to-file relationship).  It is a very basic INNER JOIN, implemented with multiple files in the FROM and the join definition as part of the WHERE clause (ie: no INNER JOIN clause).  And other JOIN types (ex: LEFT/RIGHT OUTER/EXCEPTION JOIN, etc) currently are not supported yet.