Problems with Stored Procs(MSSQL6.5) and Delphi 3
Posted on 1998-07-16
I'm having problems with my StoredProc with MS SQL 6.5 and Delphi 3.
The Stored Procs(stp) works on record that match a certain id. The stp takes 2 parameters both integers. If the stp works on more than 15 records, it quits about on record 14. It will post the first 14 but after that not 15 and later. (14 is not consistant either sometimes less never more) If this is wrapped in a transaction nothing is rolled back and no errors are returned.
Now to debug this I have pulled all the code and placed executing the stp in a button click, this didn't help. If I execute this stp from ISQL everything works fine...I'm going crazy...if Delphi3Detected then ScrewWithRick...