Click here to Skip to main content
15,921,716 members
Home / Discussions / Database
   

Database

 
GeneralRe: substring function Pin
Krish - KP19-Nov-07 23:12
Krish - KP19-Nov-07 23:12 
GeneralRe: substring function Pin
Sonia Gupta20-Nov-07 0:28
Sonia Gupta20-Nov-07 0:28 
AnswerRe: substring function Pin
Michael Sync19-Nov-07 19:30
Michael Sync19-Nov-07 19:30 
QuestionDatetime format Pin
Assaf8219-Nov-07 12:52
Assaf8219-Nov-07 12:52 
AnswerRe: Datetime format Pin
Colin Angus Mackay19-Nov-07 13:06
Colin Angus Mackay19-Nov-07 13:06 
Questionextremely strange ado.net issue Pin
ekynox19-Nov-07 11:21
ekynox19-Nov-07 11:21 
AnswerRe: extremely strange ado.net issue Pin
Colin Angus Mackay19-Nov-07 12:26
Colin Angus Mackay19-Nov-07 12:26 
GeneralRe: extremely strange ado.net issue Pin
ekynox19-Nov-07 14:08
ekynox19-Nov-07 14:08 
LOL Colin that's one funny pointer.

I managed to work out my problem, it was do with timing issue. By the time MethodA finishes executing, I believe access has not had time to update Table A, then MethodB starts executing and Table A is missing the relavant data and MethodB fails to insert a row in Table B.

Why does it work in debug mode well when debugging there is ample time for Access to actually commit the data into the table.

Solution was to a a Thread.Sleep() to cause pause and it all works.

Yes you are right about placing tracing code.

<br />
public void AddStuffToDB()<br />
{<br />
   MethodA(string x,string y);<br />
<br />
   MethodB(string x);<br />
}<br />

QuestionADO: Encoding problem ? Pin
Gofur Halmurat19-Nov-07 7:50
Gofur Halmurat19-Nov-07 7:50 
QuestionHow to access a variable and foward it down the Data Flow in SSIS 2005 Pin
huertj19-Nov-07 6:15
huertj19-Nov-07 6:15 
QuestionSQL Reporting services 2005 Pin
MSinha19-Nov-07 4:17
MSinha19-Nov-07 4:17 
AnswerRe: SQL Reporting services 2005 Pin
pmarfleet19-Nov-07 5:23
pmarfleet19-Nov-07 5:23 
GeneralRe: SQL Reporting services 2005 Pin
MSinha20-Nov-07 19:40
MSinha20-Nov-07 19:40 
GeneralRe: SQL Reporting services 2005 Pin
pmarfleet20-Nov-07 22:01
pmarfleet20-Nov-07 22:01 
QuestionWindows authentication / ms access connection string Pin
desboss19-Nov-07 3:58
desboss19-Nov-07 3:58 
Questionsql express keyword to identify new row Pin
dandamudi padma18-Nov-07 21:14
dandamudi padma18-Nov-07 21:14 
AnswerRe: sql express keyword to identify new row Pin
pmarfleet18-Nov-07 21:41
pmarfleet18-Nov-07 21:41 
GeneralRe: sql express keyword to identify new row Pin
dandamudi padma18-Nov-07 21:49
dandamudi padma18-Nov-07 21:49 
GeneralRe: sql express keyword to identify new row Pin
pmarfleet18-Nov-07 21:53
pmarfleet18-Nov-07 21:53 
AnswerRe: sql express keyword to identify new row Pin
Pete O'Hanlon18-Nov-07 22:16
mvePete O'Hanlon18-Nov-07 22:16 
Questionsql express Pin
dandamudi padma18-Nov-07 21:14
dandamudi padma18-Nov-07 21:14 
AnswerRe: sql express Pin
Panchal Hardik21-Nov-07 1:15
Panchal Hardik21-Nov-07 1:15 
Questionsql express Pin
dandamudi padma18-Nov-07 20:51
dandamudi padma18-Nov-07 20:51 
AnswerRe: sql express Pin
Giorgi Dalakishvili18-Nov-07 20:56
mentorGiorgi Dalakishvili18-Nov-07 20:56 
Questionoracle query Pin
mahenputta18-Nov-07 20:39
mahenputta18-Nov-07 20:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.