Viewing 15 posts - 2,251 through 2,265 (of 2,469 total)
ling ming - am addressing ONLY the error portion...
"[MICROSOFT][ODBC SQL SERVER DRIVER][SQL SERVER]Violation of PRIMARY KEY constraints '..._PK'. Cannot insert duplicate key in object 'Table_name'"
Somewhere a piece of code is...
May 28, 2005 at 9:24 am
You have 2 FROM statements...
Don't know what this is:
"FROM (Select tr.Id as TestRequestId, p.FirstName, p.FullAddressName, a.AddressLine1, a.AddressLine2, a.Town, a.PostCode, p.FullLegalName, h.Id AS HerdID, ttli.Name AS TestType,...
May 26, 2005 at 9:34 pm
The formatting's all off so your post is one long line...
however, if you want to check if your code is successful then @@ERROR should return 0.
If you have several statements...
May 26, 2005 at 12:47 pm
sachin - as far as I know the only way you can preserve and display formatting is by using an image datatype.
As Brendan points out - I tried using an...
May 26, 2005 at 8:45 am
Ling Ming - can you please describe briefly what you want to accomplish!
May 26, 2005 at 6:52 am
WOW! It took a lot of courage to say and do what you did (last day - 10 minute window or not)...
Unfortunately PeopleSoft doesn't seem to be very different from...
May 25, 2005 at 4:48 pm
The first request for an ado function has been addressed in one of the other forums.
The second one should be:
UPDATE table1
SET b1 = B.b1,
c1 = B.c1,
...
May 25, 2005 at 3:27 pm
Here're some links for you - the first seems to have what you want!
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=183331#bm184520
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=181191#bm181614
May 25, 2005 at 3:09 pm
Vidya - I don't have time to analyze your problem but your syntax seems to be incorrect in the last line...
try : SELECT @cTAGVALUEText = REPLACE(@ParaInd, '', '@' + @ParaValue)
May 25, 2005 at 3:02 pm
Steve - I sent you a personal msg through scc...everytime I try to send an email to anything@sqlservercentral.com it bounces back...
fyi - the msg I sent you pertains to both...
May 25, 2005 at 9:49 am
I'm not really sure I understand your question but can you not ensure that something is selected from the dropdown box when the user tries to enter "other data" -...
May 25, 2005 at 8:07 am
Michael - I read on one of the sites that you can enable impromptu log in [Impromptu - Audit Configuration] and if it is a database connection error you will...
May 25, 2005 at 7:49 am
Ryan - I don't have the time to check the exact syntax but your editor should be able to help you along...here's something to get you started...
Private Function KeyFields(strTable As...
May 25, 2005 at 7:24 am
It seems that you have a default constraint on that column. Remove the constraint and alter the column to accept Nulls.
May 25, 2005 at 6:40 am
These may seem obvious - but are you using system dsn (as opposed to user) & are you referencing the dsn name in your connection string (& not the db...
May 25, 2005 at 6:30 am
Viewing 15 posts - 2,251 through 2,265 (of 2,469 total)