I suspect that nobody has worried much about getting metadata when
composing their own SQL using executeImmediate. After all, if you are
generating the SQL, you usually have some basis for knowing what is going
to come back. This is not to say that it wouldn't be good to have it
available, just that it probably hasn't been an issue.
If you have some abstracted scheme for generating sql on the fly, you might
want to think about setting up some data objects, then decide which one to
use via a naming convention. This way you would get the full power of data
objects without locking into any one of them.
For example, I built a framework which had a concept of "section", which
could correspond to any table or view (the choice of the term "section" was
driven by the nature of the application). "section" is passed as a String
parameter to various methods, including constructors. The link to the data
objects was by a naming convention. If the value of "section" was, for
example, "Appointments", then the code would get a reference to a
CSpMultiSQL data object called "TransMultiSQLAppointments".
-- Curt Springer, Team ND
At 06:28 AM 12/22/99 -0800, Naftali wrote:
> I am using executeImmediate() and am trying to get
> the names of the columns
> returned.It seems the only way to get column names when
> using executeImmediate() is to get it from the
> CSpDBResultSchema (via the
> getColumn() method).The problem is that
> executeImmediate returns an empty
> CSpDBResultSchema (as an empty array).Please remember
> that since i am
> using executeImmediate i have no dataObject to work with.
> Is there another way to get column info when using
> executeImmediate?
>_________________________________________________________________________
>
>For help in using, subscribing, and unsubscribing to the discussion
>forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>
>For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
