sql - DBNETLIB errors -

-

what should very straight forward query giving me trouble.

first, here's code: 

`select accthist.acct, accthist.cpnyid, accthist.fiscyr, accthist.ledgerid, accthist.ptdbal04 curr_month, sum(accthist.ptdbal00+accthist.ptdbal01+accthist.ptdbal02+accthist.ptdbal03+accthist.ptdbal04) ytd_bal  ffneapp.dbo.accthist accthist  (accthist.acct>='4000000' , accthist.ledgerid in ('actual','stat','budget','budstat') , accthist.fiscyr in ('2014','2015') , accthist.cpnyid not in ('999'))  group accthist.acct, accthist.cpnyid, accthist.fiscyr, accthist.ledgerid, accthist.ptdbal04`

when refresh query via connection in ms excel, 3 errors.

first [microsoft][odbc sql server driver][dbnetlib]connectionwite (send()).

next [microsoft][odbc sql server driver][dbnetlib]general network error. check network documentation.

last problems obtaining data.

oddly, when remove 'budget' clause, works. cause query fail? particular record ledgerid of budget cause hang up? if so, what's best way figure out record?


Comments

Post a Comment

Popular posts from this blog

Android : Making Listview full screen -

-
<linearlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".mainactivity"> <edittext android:layout_margintop="5dp" android:layout_width="match_parent" android:layout_height="50dp" android:background="@drawable/location_edittext" android:id="@+id/locationeditext" android:textsize="15sp" android:textcolor="#999" android:paddingleft="15dp" /> <com.example.ravi_gupta.slider.viewpagercustomduration android:layout_width="wrap_content" android:layout_height="0dp" android:id="@+id/viewpager" android:scrollbarstyle="outsideoverlay" android:layout_weight="0.5...
Read more

javascript - Parse JSON from the body of the POST -

-
i'm using cameratag.com record video on website. service can send json response server can save data database. don't know how proceed here: the documentation states please note json repsonse passed in body of post , not form parameters. here example of how parse response in ruby: data = json.parse(request.raw_post) video_uuid = data["uuid"] but don't know how data on javascript. i'm not experienced in js please bare me :) post sample: { "uuid": "00012710-4b65-0131-ffe6-22000a499ea4", "camera_uuid": "98373a20-79ee-0130-3e42-1231390fcc11", "created_at": "2013-12-20t05:25:02.000z", "percent_complete": 100, "short_code": "kktb4q", "metadata": { }, "state": "published", "recorded_from": "http://singwho.com", "publish_type": null, "formats": [ { "name...
Read more

javascript - How to Hide Date Menu from Datepicker in yii2 -

-
basically in datetimepicker widget date choose first time, how can hide date option widget , filter according time. tried not working want hide remove button [ 'attribute'=>'time', 'label'=>'time', 'format'=>'raw', 'value'=>function($data){ return date('h:i:s',strtotime($data->time)); }, 'filter'=> datetimepicker::widget([ 'model' => $searchmodel, 'attribute' => 'time', 'clientoptions' => [ 'autoclose' => true, 'format' => 'hh:ii', 'showon' =...
Read more