|
Indeed. Checking the SQL error codes would be a more robust approach.
However, it sounds like this is a program that's only ever run on one computer, so it's unlikely to suddenly start throwing errors in Dutch. 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Richard Deeming wrote: However, it sounds like this is a program that's only ever run on one computer
I wish I had gotten a penny everytime that assumption fell apart
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
When I do it right, I walk the InnerExceptions to find the first System.Data.SqlClient.SqlException with one of the following error codes:
errorcodes = new System.Collections.Generic.Dictionary<int,PIEBALD.Data.ErrorCode>() ;
errorcodes [ 1205 ] = PIEBALD.Data.ErrorCode.Deadlock ;
errorcodes [ 2601 ] = PIEBALD.Data.ErrorCode.Duplicate ;
errorcodes [ 2627 ] = PIEBALD.Data.ErrorCode.Duplicate ;
errorcodes [ 547 ] = PIEBALD.Data.ErrorCode.ReferentialIntegrity ;
errorcodes [ -2 ] = PIEBALD.Data.ErrorCode.Timeout ;
Then wrap it in a custom Exception:
public partial class DuplicateException : PIEBALD.Data.OperationFailedException ...
public partial class ReferentialIntegrityException : PIEBALD.Data.OperationFailedException ...
public partial class TimeoutException : PIEBALD.Data.OperationFailedException ...
Then my code can catch and act on specific error codes.
|
|
|
|
|
What if locale is not english
TVMU^P[[IGIOQHG^JSH A#@RFJ\c^JPL>;"[, /|+&WLEZGc
AFXc!L<br />
%^]*IRXD#@GKCQ R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_ADEPABIKRDFVS)EVLQK)JKQUFK[MUKs$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia> -----------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
ALTER TABLE [tablename] ADD DEFAULT (NULL) FOR [fieldname]
Well yes - that should make a huge difference....
|
|
|
|
|
Duncan Edwards Jones wrote: that should make a huge difference
You can never be too clear. 
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Then why is there no comment explaining the default? 
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Eddy Vluggen wrote: Then why is there no comment explaining the default?
Reminds me of some code I inherited.
DataManager dm = new DataManager();
dm.Open();
Ya, thanks for the helpful comment.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
That is rather helpful; it explains that the DataManager is merely a wrapper round a connection, and that it probably should be deleted from the project and simply replaced by an IDbConnection and a factory
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Working on Google sign in API for one of my project which need to load one j query file called
https://apis.google.com/js/client:plusone.js
i copy this link send it to my co-worker by Skype, he copied and apply that code. Boom, g-sign in button do not click. the same code working fine on the test project that we have created but not on our main project.
Reason,
Skype see "client:plusone.js" and convert :P to  and when same code goes to vs it leaves a blank space and copied like "client lusone.js". after spending some half an hour we finally got a working example of Google sign in.
Ravi Khoda
|
|
|
|
|
Thank God the code didn't use mooning
|
|
|
|
|
Words just fail me...
Help wiht a code[^]
"If you don't fail at least 90 percent of the time, you're not aiming high enough."
Alan Kay.
|
|
|
|
|
|
It has been removed. What did it say?
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
Have not seen it either, but from the tip of my tongue Id' guess it was similar to what my link below Shows off...
|
|
|
|
|
Thanks Marco, that's the one.
"If you don't fail at least 90 percent of the time, you're not aiming high enough."
Alan Kay.
|
|
|
|
|
It was someone trying to compile poorly formatted XML as C++
I don't know why.
What do you get when you cross a joke with a rhetorical question?
The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism.
Do questions with multiple question marks annoy you???
|
|
|
|
|
|
Same question again. I did see the first one. 
What do you get when you cross a joke with a rhetorical question?
The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism.
Do questions with multiple question marks annoy you???
|
|
|
|
|
I didn't 
|
|
|
|
|
My favorite part is:
- Perhaps you should create a spreadsheet.
- Hey! Can you help creating a spreadsheet? I'm new into programming.
|
|
|
|
|
Hi fellows, I'm stuck I need to extract data, the code was send to me from the statistics department of Mexico I need to extract information from a webpage, it says is API information. I tried to copy and paste the code on Dev- C++ 4.9.9.2 and click on run but it says file not compiled, after that I save the file and still is the same. The information is about energy consumption. THANKS! <DATASET_BIINEGI xmlns="http://schemas.datacontract.org/2004/07/BIINEGI.Model" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> <Data> <GeneralNote/> <GeneralSource> Secretaría de Energía. Balance nacional de energía. </GeneralSource> <Serie> <Obs> <CurrentValue>9250.67</CurrentValue> <NotesPeriod i:nil="true"/> <SourcesPeriod i:nil="true"/> <TimePeriod>2010</TimePeriod> <ValueStatus/> </Obs> </Serie> </Data> <MetaData> <CreationDate>13/07/2015 10:23:56 a.m.</CreationDate> <Freq>Anual</Freq> <Indicator>13241</Indicator> <LastUpdate>2012/08/27</LastUpdate> <Name>Total</Name> <NoOfDecimals>3</NoOfDecimals> <Unit>Petajoules</Unit> <Region>Nacional</Region> </MetaData> </DATASET_BIINEGI>
I intentionally kept the delightful formatting of the original.
"If you don't fail at least 90 percent of the time, you're not aiming high enough."
Alan Kay.
|
|
|
|
|
cmd.CommandType = CommandType.Text
...no comment... 
|
|
|
|
|
Duncan Edwards Jones wrote: ...no comment...
... would have been preferable.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
This one is epic 
while (true) {
continue;
}
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
