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
SELECT CONVERT(VARCHAR(MAX), <varbinary_value>, 2)
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
I'm confused about what you need. Is this in a jet report? What is the dependent function or what error are you getting?
Hi,
You may use http://basitaalishan.com/tag/converting-varbinary-to-string/
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (