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

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

{{tag>category:"OpenInsight 32-bit" author:"Bruce Cameron"}}

[[https://www.revelation.com/the-works|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]]


==== SQL Connector vs Dataset connection (OpenInsight 32-bit) ====
=== At 27 JUN 2022 04:16:01PM Bruce Cameron wrote: ===
 
 
<QUOTE>
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.








</QUOTE>

[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=3EA280AADCC74C4B9475E2C8390A2B5C|View this thread on the Works forum...]]