Performing a 'Describe' SQL query with CAPI.Exec()...

Message from Sean M Alderman via eLinkIs this possible?I'm trying to execute this SQL statement from an OScript...String sqlStatement = "describe webnodes"Dynamic results = CAPI.Exec(dbConnection, sqlStatement)echo(results)results contains E675086344, and echoes "Error executing an Sqlstatement."Any ideas? I was hoping to use the results to create a skeleton recArray, which I'll later put values into (maybe).- Sean M. AldermanITRACK Systems AnalystPACE/NCI - NASA Glenn Research Center(216) 433-2795

Find more posts tagged with

Comments

eLink User

Message from Hans Stoop <<A HREF="mailto:hstoop@opentext.com">hstoop@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

With the fololwing construct you also get detailed error message about what went wrong.

dynamic row = CAPI.exec( prgCtx.dSession().fDBconnect.fConnection, "select * from otpp_regarea where NodeId = :A1", node.pID )
Assoc errList = prgCtx.fDbConnect.CheckError(row)

echo(errList)

The other thing to do is to run the SQL query on the database directly.

Hans Stoop

--------------
Register your subtypes in the OScript Registry:
https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2454603
Consultant Partner Programs Europe
hstoop@opentext.com
+31 23 5652333
http://www.opentext.com/

-----Original Message-----
From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of eLink Discussion: Development Discussion
Sent: woensdag 6 juni 2001 17:15
To: eLink Recipient
Subject: Performing a 'Describe' SQL query with CAPI.Exec()...

Performing a 'Describe' SQL query with CAPI.Exec()... Posted by eLink on 06/06/2001 11:15 AM

Message from Sean M Alderman <Sean.M.Alderman@grc.nasa.gov> via eLink

Is this possible?

I'm trying to execute this SQL statement from an OScript...

String sqlStatement = "describe webnodes"
Dynamic results = CAPI.Exec(dbConnection, sqlStatement)
echo(results)

results contains E675086344, and echoes "Error executing an Sqlstatement."

Any ideas? I was hoping to use the results to create a skeleton recArray, which I'll later put values into (maybe).

- Sean M. Alderman
ITRACK Systems Analyst
PACE/NCI - NASA Glenn Research Center
(216) 433-2795

Maurizio_Giglio

See my answer athttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2530295&objAction=view&show=0

eLink User

Message from Sean M Alderman via eLinkYes... The query works just fine from sqlplus...SQL> describe daudit Name Null? Type ------------------------------- -------- ---- AUDITID NUMBER(10) DATAID NOT NULL NUMBER(10) USERID NOT NULL NUMBER(10) AUDITDATE DATE EVENT VARCHAR2(255) EVENTDESC VARCHAR2(255) DNAME VARCHAR2(255)SQL>Basically I just wanted to get the column names of a table (not necessarily daudit) to use as the list arg to RecArray.Create().I found another way to accomplish this though.At 04:51 AM 06/07/2001 -0400, you (eLink Discussion: Development Discussion) wrote:- Sean M. AldermanITRACK Systems AnalystPACE/NCI - NASA Glenn Research Center(216) 433-2795