OdxCloseCursor

OdxCloseCursor closes a cursor.

Syntax

OdxCloseCursor @cursor[, @options]

@cursor integer input
The cursor number that was assigned when OdxOpenCursor was called.

@options varchar input
List of options to be passed to CLoaconnect. Optional.

Options

Example

This example takes a connection string as input from the calling procedure, establishes a connection, opens a cursor and returns the instance number, cursor number and status.

CREATE PROCEDURE prODXConnect
@connect_string varchar(100),
@instance_no int output,
@cursor_no int output,
@status int output
AS
-- Connect
exec @status = master.dbo.OdxConnectEnv @connect_string, @instance_no output, 'FILE=DSN'
if @status <> 0 return

-- Open a cursor
exec @status = master.dbo.odx_open_cursor @instance_no, @cursor_no output
if @status <> 0 exec prODXDisconnect @cursor_no, @instance_no
GO

Top