SQL Connector vs Dataset connection (OpenInsight 32-bit) [Revelation On-Line Wiki]

OpenInsight 32-bit, Bruce Cameron

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 27 JUN 2022 04:16:01PM Bruce Cameron wrote:

Hello,

Having any issue with an existing (working well for over a year) OI SQL connection/dataset connection.

While trying to figure out the problem I'm noticing that using COUNT and LIST/READNEXT return different results/# of records.

If I try and view the SQL data from the SQL Query window in the DBMgr I see 700+ records.

If I LIST the OI table (aka the dataset?) then only 3 records display.

Wondering if there is a quick/obvious explanation or any documentation from OI that does a deep dive into the available windows and tools? Admittedly my SQL knowledge is novice.

Thanks.

View this thread on the Works forum...