SqlGetLastStatementEx()

Discussion forum about all things Gupta, OpenText and the community.
Mirko
Italy
Posts: 1299
Joined: 04 Apr 2017, 08:56
Location: Geneva

SqlGetLastStatementEx()

Post by Mirko » 15 Mar 2012, 17:27

Hi all,

It would be really nice to enhance SqlGetLastStatement !
Kind of SqlGetLastStatementEx( RESOLVE_BINDS ) that would return the last statement BUT with binds resolved !!!

so that, for istance, if SqlGetLastStatement returns : "insert into mytable( mycol1, mycol2) values( :nMyFirstValue, :sMySecondValue)" then SqlGetLastStatementEx( RESOLVE_BINDS ) would return : "insert into mytable( mycol1, mycol2) values( 123, 'This is not a love song' )"

it would be so quicker to trap unmached FK and not nulls :P

TIA
Mirko

RainerE
Germany
Posts: 2225
Joined: 27 Apr 2021, 12:40
Location: Germany

Re: SqlGetLastStatementEx()

Post by RainerE » 16 Mar 2012, 11:49

And I would like to have a SqlGetStatement( hSql ) which get's the statement for a specified Sql Handle, not the last statement prepared for any handle.

Regards,
Rainer

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests