Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: DBLibrary/NSQL question
Date: Mar 23 1999 6:02PM
Wechsler, Steven M writes:
> If I use nsql() with the HASH option to execute a query that returns
> multiple result sets (such as sp_spaceused), will I still be able to
> reference the columns of the last set of results (e.g. reserved, data, etc)
> using the column names? Is there a more straightforward way of doing this?
You *should* be able to. I haven't looked that closely at nsql(), but
dbnextrow() always returns a hash with the column names set for the
current row, so I would think that nsql() will do the right thing.
Michael Peppler -||- Data Migrations Inc.
email@example.com -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
Sybase on Linux mailing list: firstname.lastname@example.org