The reason that the appliaction was hanging was
SQLCA.AutoCommit = False
I added Commit; after Execute Immediate :ls_sql;
Commit is also needed after a stored procedure.
I am working in Powerbuilder V10.1 and SQL Server 2000. Within the application I dynamically Drop then recreate a view named view_selection_list. When another user accesses any screen using view_selection_list the screen will hang on the statement "If Exists (SELECT name FROM sysobjects WHERE...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.