Stored procedure doesn't work 2nd time around 1

[whateveragain]

I may have asked the wrong question in a previous post. I call a stored procedure twice. The first time it works. The second time, it seems that it's not even entered. What should I look for? Below is the process:

1. FormA = made selections calls stored procedureA to create tables
2. stored procedureA creates tables
3. FormB displays new table and calls FormC
4. FormC - new selections made and calls stored procedureB
5. Stored procedureB drops original tables
6. stored procedureC updates selection table -> works
7. stored procedureA is re-called to make new tables with selection table -> This doesn't work 2nd time. I tested procedure to see if it were entered a 2nd time and it wasn't.
8. FormB is called and displays old data

 

[jmeckley]

to start, the whole process seems overly complex. why alter the db schema with creating and dropping tables. not to mention what if multiple users use this same process at the same time? just make the tables permanent and insert/select/delete records in batches.

if you provide the sql and code we will be able to better assist you.

Jason Meckley
Programmer

faq855-7190
faq732-7259