Operation_Binary Table/OLE Object

The table dbo_Operation_binary has a field called bits whose content is OLE Object. How can I print this on a report in access?

Find more posts tagged with

VISUAL - Enterprise General Discussions

Comments

unknown

Morning,

You should find all you need to know in the KB 739670.

Just bear in mind you will need to take into account from V8 onward the Db schema changed to NVARCHAR so you will need to amend the SQL statement accordingly.

I can fire up my V8 test rig if you need the statement

ATB
R

unknown

I have not been able to locate KB 739670. Any help would be appreciated

unknown

www.inforxtreme.com/.../SoHoViewSolutionC.aspx

unknown

I would create a view in SQL server then link to access.

/*

Visual 7.1.2

*/

SELECT WORKORDER_TYPE, WORKORDER_BASE_ID, WORKORDER_LOT_ID, WORKORDER_SPLIT_ID, WORKORDER_SUB_ID, SEQUENCE_NO, TYPE, BITS,

CONVERT(VARCHAR(8000), CONVERT(BINARY(8000), BITS)) AS BITS_CONVERTED

FROM OPERATION_BINARY

/*

Visual 9.0.1

*/

SELECT WORKORDER_TYPE, WORKORDER_BASE_ID, WORKORDER_LOT_ID, WORKORDER_SPLIT_ID, WORKORDER_SUB_ID, SEQUENCE_NO, TYPE, BITS,

CONVERT(NVARCHAR(4000), CONVERT(BINARY(8000), BITS)) AS BITS_CONVERTED

FROM OPERATION_BINARY

unknown

Create a module and place the text as shown below.

I use it in Access2010 for VM8.0

In your query replace data with the "bits" field.

Option Compare Database

Public Function RAW2STR(DATA)

RAW2STR = StrConv(DATA, vbUnicode)

End Function

Public Function STR2RAW(DATA)

STR2RAW = StrConv(DATA, vbFromUnicode)

End Function

unknown

In the query:

Expr1: RAW2STR([dbo_OPERATION_BINARY]![BITS])

unknown

Jim, I know this is an old post but I have a question. We just converted from 7.0 to 9.08 and I'm having problems with the RAW2STR(DATA) function. It is only returning the 1st character of the spec box. I have the same module as you have above. Have you used it in 9.08 yet?

unknown

I haven't but:

'RAW2STR = StrConv(DATA, vbUnicode)

has been changed to:

RAW2STR = "" & DATA

Copyright © 2025 Infor. All rights reserved.