Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sybase 12.5 and Dynamic SQL

Status
Not open for further replies.

Mifo

Programmer
May 22, 2012
1
0
0
AE
Hi all, this is the fist time to post here.
I have a problem and want to ask about and if there is a solution.

I built a stored procedure to do the following:
1- I have a physical indexed table A, and another physical table B
2- a built a dynamic SQL inside the stored procedure to read from table A some information and insert it to table B and do some update actions on table B, then get the result from table and delete the inserted records of table B.

the problem is, all actions go on the right way except for deleting from table B, in spite of deleting from table B without where condition. all rows of table B still exist.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top