Originally posted by HeliCraig
View Post
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
test please delete
Collapse
This is a sticky topic.
X
X
Collapse
-
Where are we going? And what’s with this hand basket? -
Originally posted by voodooflux View PostNice shade of blusher that.Comment
-
Comment
-
Originally posted by voodooflux View Post
SPACE INVADERS
...........................................................................................
.............
...........................................................................................
.............
...........................................................................................
.............
...........................................................................................
.............
...........................................................................................
.............
.............
...........................................................................................
.............
.............
.............
Comment
-
Originally posted by HeliCraig View PostOh FFS... I give up.
We have a piece of code which can receive a nasty reply from SQL (deadlock), and it turns out the first thing which the error handler tries to do is close the recordset. Recordset not been opened yet, so the error handler fails. Leave connection object to DB open for eternity. Nice.
OfficeIdiots suggestion: Put an "on error resume next" statement in the error handler.
And now you can see why the code was tulipe in the first place. FFS.
If recordset open THEN close recordset?
Or some such. Looks like it's not an Oracle database, so I don't care.Comment
-
-
Originally posted by HeliCraig View PostCan I have it back when you are finished?Where are we going? And what’s with this hand basket?Comment
-
Originally posted by TheFaQQer View PostHow about:
If recordset open THEN close recordset?
Or some such. Looks like it's not an Oracle database, so I don't care.
My god, he is such a numpty idiot. How? Just how?
(Oh, and you're right Faqqer, its MS SQL).
I did take it a step further and suggest that while this would fix the sympton, perhaps he should go and hassle the DBA's to find out why we are getting so many deadlock victim situations when none of our scripts do too much heavy work!! He looked at me gone out. Then did his usual "yes sir, yip, k mate, would look into that aspect today afternoon yesterday please." statement - so I know that'll be fixed then!Comment
-
Comment
-
Originally posted by HeliCraig View PostOfficeIdiots suggestion: Put an "on error resume next" statement in the error handler.
a) my code
b) his data
Guess which it was.
(Clue: it wasn't 'a').Where are we going? And what’s with this hand basket?Comment
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Comment