sql server - SQL Update not working in a stored procedure unless run manually -


the following snipit of stored procedure (a.k.a. sp) have set running on mssql(a.k.a. db). sp used take data db view , export results csv file via bcp. works no issues. last step update db table, db view grabbing data, current time stamp. now, here issue. when manually run stored procedure via ms sql server management studio, works planned. when same sp executed externally via software, bcp export works yet update table not work, i.e. no current time stamp entry in table. declarations, variable sets, set ansi_nulls on , set quoted_identifier on in place prior snipit.

suggestions?

curt

if exists (select * dticket formid = @formid)  begin     select @csvdata = 'select * dticket formid = '''+@formid+''''     select @bcpsql ='bcp "'+ @csvdata + '" queryout "'+ @filepath + @filename + '" -c -t"|" -u '+@user+' -p '+@pw+' -s '+ @server +' -d maindb'     exec master..xp_cmdshell @bcpsql     update "udticket" set exportdate = getdate()  formid = @formid , exportdate null  end

have @ following article https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/xp-cmdshell-transact-sql seem update happening before bcp done. capture return value xp_cmdshell example below

declare @rtn int  exec @rtn =exec master..xp_cmdshell @bcpsql if @rtn = 0 begin update "udticket" set exportdate = getdate()  formid = @formid , exportdate null  end  else .....

Comments

Post a Comment

Popular posts from this blog

Retrieving ETA (estimated time of arrival) with Google Distance Matrix API and public transit as transport mode -

Image
is possible retrieve eta google's distancematrix api (or alternative api). fyi, eta different duration, when using public transport. following example clarify request. when leave on friday @ 8.15 i'll able catch train @ 8.30 , arrive @ 9.00 am. google says duration 30 minutes. however, when leave on saturday @ 8.15 i'll able catch first train @ 9.00 , arrive @ 9.30 am. google still says duration 30 minutes, means ignore delay. google map supports functionality there api around giving me eta instead of duration. can see, distance-matrix' response no good. clarifying question little. eta estimated time of arrival , it's clear user wants know entire duration of transport (including waiting time public transport).
Read more

javascript - Confirm a form & display message if form is valid with JQuery -

i'm developing django application , use javascript in order improve website. i have form , display 2 things : confirm form before submit if form submitted, display message : 'form saved' it's first time i'm using js , need make process. this code : <form class = "form" method='post' action=''> {% csrf_token %} <br></br> {{ form.as_p}} <br></br> <button type="submit">valider</button> </form> <script> $('#form').submit(function() { var c = confirm("click ok continue?"); return c; //you can return c because true or false }); </script> and if form valid , saved : <script type="text/javascript" > $(document).on('valider', 'form.form', function(form) { var $form = $(form); $.ajax({ ...
Read more

ionic framework - Meteor - Error: Failed to execute 'insertBefore' on 'Node' -

i trying make dynamic list display using meteor, idea load more elements each time bottom of page reached. the html template following : <template name="contacts"> {{#contentfor "headertitle"}} <div class="bar bar-header bar-assertive"> <h1 class="title">contacts :</h1> </div> {{/contentfor}} {{#ionview}} {{#ioncontent}} <div class="list"> {{#each contacts}} <a class="item item-avatar" href="/contacts/{{_id}}"> <img src="/img/ico_client.png"> <h2>{{full_name}}</h2> <p>{{company}}</p> </a> {{/each}} </div> {{#if moreresults}} <div id="showmoreresults" style="margin-left: 25px;"> <span class="loading">loading...</span> </div> {{/if}} {{/ioncontent}} {{/ionview}} </te...
Read more