Subject | Can we retrieve the SQL statement from pisc_stmt_handle? |
---|---|
Author | Chee Yang |
Post date | 2011-03-25T03:53:48Z |
Hi,
When I prepare a SQL Statement (INSERT, SELECT, DELETE, or UPDATE, ...), isc_dsql_prepare will return a pisc_stmt_handle for me.
Is that possible to get back the SQL Statement from pisc_stmt_handle by using function like isc_dsql_sql_info or something similar?
If yes, how would I achieve that? Thank you.
Best Regards,
Chee-Yang, Chau
When I prepare a SQL Statement (INSERT, SELECT, DELETE, or UPDATE, ...), isc_dsql_prepare will return a pisc_stmt_handle for me.
Is that possible to get back the SQL Statement from pisc_stmt_handle by using function like isc_dsql_sql_info or something similar?
If yes, how would I achieve that? Thank you.
Best Regards,
Chee-Yang, Chau