Function API_ROUTINE isc_embed_dsql_declare

src/yvalve/user_dsql.cpp:170–197

____________________________________________________________ Declare a cursor for a dynamic request.

//	Declare a cursor for a dynamic request.
//
ISC_STATUS API_ROUTINE isc_embed_dsql_declare(ISC_STATUS*	user_status,
											  const SCHAR*	stmt_name,
											  const SCHAR*	cursor)
{
	ISC_STATUS_ARRAY local_status;

	INIT_DSQL(user_status, local_status);
	try
	{
		// get the symbol table entry

		dsql_stmt* statement = lookup_stmt(stmt_name, statement_names, NAME_statement);

		const ISC_STATUS s = isc_dsql_set_cursor_name(user_status, &statement->stmt_handle, cursor, 0);
		if (s) {
			return s;
		}

		Firebird::WriteLockGuard guard(global_sync, FB_FUNCTION);
		statement->stmt_cursor = insert_name(cursor, &cursor_names, statement);

		return s;
	}
	catch (const Firebird::Exception& ex)
	{
		return error(ex);
	}
}


//____________________________________________________________