tag:blogger.com,1999:blog-6683247817777829819.post9091805641006222842..comments2024-03-02T08:36:46.140+00:00Comments on In Touch with Dynamics (GP): Returning Ole Notes File names in Dynamics GPAndy Hallhttp://www.blogger.com/profile/16467321633045548311noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-6683247817777829819.post-86117417127684577022010-04-21T05:20:55.115+01:002010-04-21T05:20:55.115+01:00Also have a look at
http://blogs.msdn.com/develo...Also have a look at <br /><br /><a href="http://blogs.msdn.com/developingfordynamicsgp/archive/2009/10/05/copying-record-notes-and-ole-attachments-between-companies.aspx" rel="nofollow">http://blogs.msdn.com/developingfordynamicsgp/archive/2009/10/05/copying-record-notes-and-ole-attachments-between-companies.aspx</a><br /><br />It has some simpler code for this purpose.<br /><br />convert(binary(4),cast(TN.NOTEINDX as integer)) as OLEPATH<br /><br />David<br /><a href="http://blogs.msdn.com/DevelopingForDynamicsGP/" rel="nofollow">http://blogs.msdn.com/DevelopingForDynamicsGP/</a>David Musgravehttps://www.blogger.com/profile/15001247843646031525noreply@blogger.com