Table of Contents

How to detect unsupported features

Unsupported features & workarounds

Unsupported features that can be detected

SetTrans

Data pipeline

MobiLink

Oracle RPC arrays

SQLPreview

SQLReturnData property

Unsupported features that cannot be detected

Transaction trace

Unsupported use cases in Embedded SQLs

Retrieve As Needed and Rows to Disk

SyntaxFromSQL

Commit or Rollback Transaction using Dynamic SQL

Data retrieval and SQL operations in the RetrieveRow event

Discrepancies & workarounds

Discrepancies that cannot be detected

DB connection

Alias name

rowsupdated value

DisableBind parameter

TableBlob retrieval

Dynamic DataWindow

TransactionName

Data type in Dynamic SQL Format 4

Decimal data type in static SQL or DataWindow

Timing of transaction rollback

Oracle AutoCommit and Lock

Stored procedure parameter

Transaction commit

Use Describe in Dynamic SQL Format 4

Bit data field

SelectBlob/UpdateBlob supports UTF8 only

SQLNRows property (with Cursor)

SQLCode property (with SP)

Column name from view

Incompatible coding styles

PBLs contain DataWindows with the same name

Object name using C# reserved words

DataWindow name containing special characters

Editing SQL

Column order in data source and Column Specification

One compute expression containing multiple computed columns

Cursor syntax

Syntax after UNION