>>Thanks for your help. As far as I can tell, I allocating a new
>>statement for each one:
>>
>>STATEMENT = 'update ...'
>>STATUS<-1> = SQLAllocStmt(connection.env,update.stmt.env)
>>STATUS<-1> = SQLExecDirect(update.stmt.env,STATEMENT)
>>
>>STATEMENT = 'select * from ...'
>>STATUS<-1> = SQLAllocStmt(connection.env,query.stmt.env)
>>STATUS<-1> = SQLExecDirect(query.stmt.env,STATEMENT)
>>
>>In that order, it works fine. If I put the query first, (which I
need
>>to do!) I get a status of -1 when I try to execute the update.
Wendy - I know this may sound dumb but is the update section returning
a value which you need for the query section? Is something running
after the update section before the query that is needed for the query
section?
dan
----------------------------------------------------------------------
This communication may contain information that is legally privileged,
confidential or exempt from disclosure. If you are not the intended
recipient, please note that any dissemination, distribution, or
copying
of this communication is strictly prohibited. Anyone who receives
this
message in error should notify the sender immediately by telephone or
by return e-mail and delete it from his or her computer.
----------------------------------------------------------------------
Daniel Plocinik [EMAIL PROTECTED]
Sr. Programmer Analyst
Arnold & Porter LLP Telephone: 202-942-6392
555 Twelfth Street, NW Fax: 202-942-5999
Washington, DC 20004-1206
For more information about Arnold & Porter LLP, click here:
http://www.arnoldporter.com
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
