How can I retrieve a VB snapshot?

From: Dave Ranzau <ranzdr_at_comfort.com>
Date: 1997/03/20
Message-ID: <01bc3546$90a8dda0$3228010a_at_IS-413B-2.COMFORT.com>#1/1

I'm looking for guidance in how to return a snapshot (VB4-16 / DAO 2.5) from an Oracle table using SQL Passthrough (using PL/SQL syntax).

With SQL Server a standard Select statement works (directly or through a stored procedure), and a Select without passthrough (Jet) works against Oracle tables.

I'm guessing I need to explicitly use cursors but I don't have much experience using them, especially in Oracle.

I'm using the ODBC driver from Oracle (version 7).

TIA
Dave Ranzau

ranzdr_at_comfort.com Received on Thu Mar 20 1997 - 00:00:00 CET

This message: [ Message body ]
Next message: Jens U. Veigel: "STUPID NEWBIE QUESTION: How do I get/display record/sequence number in Forms 4.5"
Previous message: RGrahamMDC: "***** ANY ORACLE CONTEXT OPTION USERS OUT THERE? *****"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message