web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Record ID field in the...
Microsoft Dynamics NAV (Archived)

Record ID field in the Record Link table

(0) ShareShare
ReportReport
Posted on by Community Member

How can I convert the Record ID field in the Record Link table from VARBINARY to VARCHAR and back to VARBINARY.  The binary field must be encrypted or setup a special way.  We use Jet Reports on this table and it displays in Text.  How do they accomplish this?

*This post is locked for comments

I have the same question (0)
  • mmv Profile Picture
    mmv 11,471 on at

    Hi,

    You may use http://basitaalishan.com/tag/converting-varbinary-to-string/

  • Community Member Profile Picture
    Community Member on at

    I'm confused about what you need. Is this in a jet report? What is the dependent function or what error are you getting?

  • Community Member Profile Picture
    Community Member on at

    I am writing an interface from Nav 2013 to ADP Open Invoice web application.  One part of the interface is to send a pdf of the scanned field ticket signed by the customer.  This document is linked in the nav system so I know the “Record ID” field of the Record Link” table in TEXT.  Using an SQL script, I try to Select the record using the where statement on the “Record ID” field and it won’t select the record because it is in some sort of encrypted VARBINARY field in the table.  I have tried many variations of the CONVERT and CAST function but nothing seems to work. I notice in JetReports it displays the “Record ID” field in TEXT and I was wondering if you can give me some insight on how I can accomplish the same thing using an SQL Script

  • Community Member Profile Picture
    Community Member on at

    SELECT CONVERT(VARCHAR(MAX), <varbinary_value>, 2)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans