Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - jop

Pages: [1]
1
Bugs and Issues / Re: Formatted fields in SQL Fragments
« on: December 15, 2016, 01:53:27 pm »
Geert, thank you so much for taking the time to post that, the square brackets totally worked for me.

And thanks Simon M for the sql tips, obviously it's not my forte.

2
Bugs and Issues / Re: Formatted fields in SQL Fragments
« on: December 06, 2016, 05:08:30 pm »
Hi Simon
I can't get this to work in .13

Template:
Code: [Select]
custom >
{ObjectNotes-Formatted}
< custom


SQL query:
Code: [Select]
SELECT TO1.Name AS Source, t_connector.Notes AS 'ObjectNotes-Formatted'
    FROM ((t_connector
           LEFT JOIN t_object AS TO2
                 ON t_connector.End_Object_ID=TO2.Object_ID )
           LEFT JOIN t_object AS TO1
                 ON t_connector.Start_Object_ID=TO1.Object_ID)
WHERE t_connector.End_Object_ID = #OBJECTID#

When I try to generate doc on this I get an error message.   Is it supposed to work?

thanks

Pages: [1]